Use import connections to import and automatically initiate new instances from other databases. You may configure any number of import connections for several database systems.
In each case you must create in the source database an import table named JRJOBIMPORT. Then populate this table with JobImport tasks, specifying the corresponding Instance parameters. Read more about such a table in the JobRouter Tech Doc manual. JobRouter databases have a JRJOBIMPORT table by default.
The JobServer service processes import connections and the available import tasks sequentially. A new instance of the respective process is started for each line in the table.
The currently supported database systems are Microsoft SQL Server, MySQL respectively MariaDB and Oracle. Additionally, nearly any ODBC-compliant data source can be accessed using the ODBC interface.
