Pulling data from MSSQL

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question.

    Unfortunately, I have bad news here: Connecting TablePress to custom SQL databases/tables is not possible. TablePress can only use its own storage as a “Custom Post Type” in the WordPress database.

    To use data in your own DB, you’ll need to develop a custom solution, as a custom plugin that queries the DB with PHP.
    If you want, you can then manually add the sorting, etc. functions by integrating the DataTables JS library from https://www.datatables.net.

    Regards,
    Tobias

    Thread Starter Gitominoti

    (@gitominoti)

    Is there any possibility of a future extension to get this kind of thing done?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no, sorry, I do not have such plans, as this is a very special requirement that not many users of TablePress would ever need.

    I have recently found a commercial WordPress plugin that can be used to access databases: https://themes.karaliki.ru/wpdatatables/
    I have no affiliation or experience with that, and I don’t know if MSSQL tables work, but maybe it’s helpful.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Pulling data from MSSQL’ is closed to new replies.