We need to display a querys from SQL server DB. For now I do this with Excel and Access, but i have problems when many user do large querys. We need to display SQL data from SQL Server updated every 5 mins, for example.
With wpDataTables, you can connect separate databases, and then create tables querying the data from that separate database. The connection to SQL data is live, so if the database updates every 5 minutes, the table will as well. The changes, however, can only be seen when the page is refreshed, but you'd be able to add an auto-refresh timer to these tables.
We need to display a querys from SQL server DB. For now I do this with Excel and Access, but i have problems when many user do large querys.
We need to display SQL data from SQL Server updated every 5 mins, for example.
With filters and search. Thanks in advance.,
Hi Victor
Thank you for reaching out to us.
With wpDataTables, you can connect separate databases, and then create tables querying the data from that separate database. The connection to SQL data is live, so if the database updates every 5 minutes, the table will as well. The changes, however, can only be seen when the page is refreshed, but you'd be able to add an auto-refresh timer to these tables.