Forum
Table Manager Support
Table Manager SupportForums
Public write access is disabled. Please login
Re: External database 06.08.2020 11:14
Hello,
the extension uses your default Joomla connection, that is only able to access the same schema you're using for that Joomla installation. If you only need to 'read' data from the external database, you could create a 'view' at each Joomla schema refering your external table, and then configure Table Manager linked to the view.
If you will need to write data on that table/s, then you can look for a more complex solution. We've not tried, but a federated table should do the work:
https://dev.mysql.com/doc/refman/5.6/en/federated-storage-engine.html
You can try to create federated tables at each Joomla installation, they will read/write data from the external ones, and you can link Table Manager to them in order to manage from each Joomla installation. As this is a quite specific configuration, you will need to ask your hosting if they allow you to create these kind of tables.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
the extension uses your default Joomla connection, that is only able to access the same schema you're using for that Joomla installation. If you only need to 'read' data from the external database, you could create a 'view' at each Joomla schema refering your external table, and then configure Table Manager linked to the view.
If you will need to write data on that table/s, then you can look for a more complex solution. We've not tried, but a federated table should do the work:
https://dev.mysql.com/doc/refman/5.6/en/federated-storage-engine.html
You can try to create federated tables at each Joomla installation, they will read/write data from the external ones, and you can link Table Manager to them in order to manage from each Joomla installation. As this is a quite specific configuration, you will need to ask your hosting if they allow you to create these kind of tables.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es