Hi Steve,
At this time connecting to other databases is only supported in the Data Explorer (see screenshot below). I kind of added this feature to see if users are interested in this functionality. And because I liked to add it! 🙂 Within the Data Explorer you can switch database and edit any table in any other database to which you have access.
https://wpdataaccess.files.wordpress.com/2019/07/data-explorer-switch-database.png
So basically this feature is available, but… You cannot access tables in another database from the Data Designer, Data Projects, Data Menus and the Data Publisher (will be part of the next release). It can be done, but it is quite a lot of work.
Personally I like your idea! But I wonder how many WordPress users are interested. Do you know if this is done a lot?
Best regards,
Peter
What I did instead is use a different prefix for the same database.
All WordPress related tables start with wp_
The ones I need for another purpose start with xyz_
That way they’re quite separate and easy to export, but you don’t have to go through the trouble of trying to connect to a different database.
Anonymous User 17526928
(@anonymized-17526928)
I came here with the same question and request.
I have created summary data in a database and table using Python and PHP of some IoT sensors and now want to publish it as a dynamic report using WordPress to make it look really professional. I am brand new to WordPress, but so far the project is coming along.
Hi Bernard,
I added this request to my to do list. At this time the list is quite long, so I can’t promise when it will become available. But it will…
Thank you for your input!
Best regards,
Peter
We would really, really, really like this feature.
Please add my vote to the list.
Thanks
Noted your request Charles! 😉
I’ll let you know when it is available.
Best regards,
Peter
Hi all,
Sorry, I see that I forgot to answer to this topic. The current version supports remote database connections, as long as the remote database is a MySQL database (or MySQL clone). You can find the documentation via the link below.
https://wpdataaccess.com/2020/01/30/remote-database-connections-available-in-all-tools/
Best regards,
Peter
