Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #2762508
SQL Server
Closed

Comments

  • Victor Alarcon started the conversation

    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.,



  • [deleted] replied

    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.