Supported connectors
Synthetic Data supports two types of database connectors:
-
Native connectors – Built into the product and require no additional setup.
-
Extended connectors – Created using a user-uploaded JDBC driver to support additional relational databases.
Use native connectors when available for simplified configuration. Use extended connectors when you need to connect to databases that are not supported natively.
Native connectors
The following database is supported out of the box:
| Database | Connection method | Notes |
|---|---|---|
| Oracle | Host, port, SID or service name, or JDBC URL | Fully supported using built-in connector configuration |
Extended connectors
You can use extended connectors to connect to additional relational databases by uploading a compatible JDBC driver. For information on creating an extended connector, refer to Create an extended connector topic.
The following configurations have been tested:
| DBMS | DBMS version | Host OS | JDBC driver | Driver version | Driver class |
|---|---|---|---|---|---|
| PostgreSQL | 11.2 | SUSE Linux Enterprise Server 12 (x86_64) | PostgreSQL JDBC Driver | 42.2.6 | org.postgresql.Driver
|
| PostgreSQL | 12.7 | Red Hat Enterprise Linux 7.9 (x86_64) | PostgreSQL JDBC Driver | 42.7.11 | org.postgresql.Driver
|
| IBM DB2 for IBM i (iSeries) | V7R5M0 (IBM i 7.5) | IBM i V7R5M0 | IBM Toolbox for Java (jt400) | 20.0.8 | com.ibm.as400.access.AS400JDBCDriver
|
| IBM DB2 for IBM i (iSeries) | V7R5M0 (IBM i 7.5) | IBM i V7R5M0 | IBM JCC JDBC 4 Driver (db2jcc4.jar+ db2jcc_license_cisuz.jar) | 11.1 | com.ibm.db2.jcc.DB2Driver
|
| IBM DB2 for IBM i (iSeries) | V7R5M0 (IBM i 7.5) | IBM i V7R5M0 | IBM JCC JDBC 4 Driver (db2jcc4.jar + db2jcc_license_consvAS.jar) | 12.1.4 | com.ibm.db2.jcc.DB2Driver
|
Limitations
-
Only relational databases are supported
-
JDBC driver must:
-
Be Type 4 compliant
-
Support ANSI SQL
-
-
Some database-specific features may not behave as expected, including:
-
Custom data types
-
Data casting behaviour
-