Remote Databases

Posts under the "Remote Databases" category

Performance

The connection to our data server may add a delay. The duration of the delay depends on the location of your server. A remote database connection may add an additional delay. You need to decide for yourself if the delay is acceptable.Copy table to another database If...

Indexes

Tables created from remote database connections and remote data files are not normal database tables. These tables are depending on their remote connection or data file. Most of these tables support local indexes, except tables created from JSON and XML files....

Synchronization

When you use the remote connection wizard to upload a data file, the plugin creates a database table for you. Data files usually change over time. You can synchronize the content of your data file and your database table in two ways: Manual synchronization Automatic...

Errors and messages

The result of each action on our data server is logged. The Messages icon in the toolbar is green when there are unread messages and red if there are unread errors. A widget appears as shown in the screenshot below to view your messages when you click the icon.If an...

Tutorials

Enable Premium Data ServicesBefore you can start using remote database connections and remote data files, you have to enable the service on your WordPress server. Access to each data server has to be enabled for your account separately, as each server needs to create...

MS Access

Your Microsoft Access database files are cached on our server. It is not possible to remote connect. Although you can make your MS Access table editable, you will not be able to write changes back to your remote database file.Each remote table needs its own remote...

Limitations

Read this BEFORE you start. Premium data services does not work behind the Sucuri WAF. We tried to get in though with Sucuri but got no response. Sorry! This limitation might apply to other security tools as well. Please get in touch if you have any questions. The IP...

MariaDB | MySQL

To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.PREPARATIONMake sure our server can access your MariaDB | MySQL Server.CREATION Start the Data Explorer Click the Connect icon to open the remote connection...

Oracle

To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.PREPARATIONMake sure our server can access your Oracle Server.CREATION Start the Data Explorer Click the Connect icon to open the remote connection wizard...

PostgreSQL

To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.PREPARATIONMake sure our server can access your PostgreSQL server.CREATION Start the Data Explorer Click the Connect icon to open the remote connection...