Configuring Your Database Connection
- Marina Dittrich (Deactivated)
Start with the configuration of the database connection.
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".
© 2023, STAGIL