Our app provides an option to create a synced connection with an external database.
To create a database connection, go to Apps → STAGIL Assets → Database SQL sync.
On this page administartiors can create new connections and manage existing.
To create a new connection click on the ‘Create synchronizer’ button.
To edit an existing connection click a 3-dot icon associated with the particular connection an select ‘Edit'.
Connection settings
Name: Specify a name for your configuration.
Database type: select a database type (Oracle, MySQL, PostgreSQL, Microsoft SQL Server)
Server and port: specify connection endpoint.
Database name: specify the database’s name.
Database table or view: specify a database table.
Database user: An authorized user for the database.
Database password: Authorized user password.
SQL Where filter: add a filter from your database.
