How can we show data on our website that is generated locally from SQL results?
There are three ways to achieve the request:
1. Import the data into the DNN database either by using SSIS integration or any other similar integration and display the information on your website by using a custom Module.
2. Expose the DB that has the information to the internet and add a connection string to your DNN website allowing the website to pull data from the external Database.
3. Create a local REST API that allows you to pull data from the website to the database, you will need to have that API accessible through the WAN connection.