We have some SQL view on-promise server, we would like to display this data on the SharePoint online.
Normally once we need to connect to this database from different network, VPN connection is required.
I'm looking for any guide to resolve this, read some articles about this issue.
some of these articles mentioned app development with visual studio. However, how about the VPN connection.
What I have currently
SharePoint online E3 2013
SQL server database on-promise
I have some programming skills with Web development, as I have noted that Sharpoint 2013 is highly developed with .NET WEB FORM as well as it not as any normal web XSLT is heavily used in SharPoint 2013.
What is the possibility to connect on-promise Database to sharePoint online, while database server required VPN?