Configuring Your Database Connection

Start with the configuration of the database connection.

Open

Name

This is just the name for this specific database connection to easily recognize it.

Database Type

Select your database type. MySQL, Microsoft SQL Server, PostgreSQL, Oracle and Informix are currently supported.

Server and port

Enter your server and port number like this: yourdomain.com:1433 or 192.168.0.10:1433

Database

Insert the name of your Database.

DB Table or View

Enter the name of your table or view. This table needs to contain all the data you want to sync. You cannot add additional tables or views e.g. using a JOIN function.

Sync Interval

Enter your cron expression for the sync schedule. If nothing is entered, the sync will run every hour.

User

Database user account that is being used to connect to the database.

Password

Password of the user account connecting to the database.

Input WHERE

Here you have the possibility to limit the data that will be used for synchronization by adding a WHERE function to the DB query.

To save the settings please click "Save".