Show data generated from SQL DB on website

Question

How can we show data on our website that is generated locally from SQL results?

Solution

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. 

Comments

0 comments

Please sign in to leave a comment.