We have a requirement in Office 365, SharePoint Online where we want to integrate it with local on-premise SQL database.
We will have a form which will directly insert the date into SQL db from SharePoint Online.
Please suggest the necessary actions that I have to perform or possible solutions.
You can take the advantage of the BCS services.BCS is supported with Office 365 Enterprise E3 and E4 plan. SharePoint Online only supports WCF and SQL Server Azure Connectors for Business Data Connectivity Services. thats mean you have a SQL azure instance and sync it with on prem SQL and Sharepoint.
For a detailed guide, you may refer to the
[Make an External List from a SQL Azure table with Business Connectivity Services and Secure Store]1
It is relatively easy to use BCS - just make sure you open the SQL port and make it publicly available to sharepoint and add necessary security around it. the second one done my alimaz is useless don't even waste your time - it has many bugs and costs you $65 + per month!!
