Supported databases
Check the compatible versions and connection details for the databases.
You can access databases using specific connectors, such as DB V2, Stream DB V3, and Stored Procedure.
The database support mentioned here doesn't apply to deprecated connectors.
Database support by type
Amazon Aurora
The Digibee Integration Platform offers support for both Amazon Aurora engines.
Amazon Aurora MySQL
1
2
3
Connection string
jdbc:mysql://<host>:<port>/<database>Amazon Aurora PostgreSQL
All versions are supported.
Connection string
jdbc:postgresql://<host>:<port>/<database>DB2
DB2 level version: 11.5
Driver version: 4.26.14
Connection string
Your company's driver licensed by IBM must be activated to connect across supported database versions. This process is handled by the Digibee support team, but you must provide the JDBC IBM DB2 driver for activation. This process is exclusive to the requesting customer's realm.
The available features are based on the official DB2 documentation.
Apache Hive
Supported via JDBC Connector 2.6.17 for Cloudera Enterprise only.
Apache Hive 1.0.0 to 3.1
Connection string
Your company's driver licensed by Cloudera must be activated to connect across supported database versions. This process is handled by the Digibee support team, but you must provide the Cloudera JDBC driver for activation. This process is exclusive to the requesting customer's realm.
The available features are based on the official Cloudera JDBC driver documentation.
Teradata Database
16.10
16.20
17.00
17.10
17.20
Connection string
Your company's driver licensed by Teradata must be activated to connect across supported database versions. This process is handled by the Digibee support team, but you must provide the Teradata JDBC driver for activation. This process is exclusive to the requesting customer's realm.
SQL Server
Microsoft SQL Server 2019
Microsoft SQL Server 2017
Microsoft SQL Server 2016
Microsoft SQL Server 2014
Microsoft SQL Server 2012
Microsoft SQL Server 2008 R2
Azure SQL Database
Azure SQL Data Warehouse or Parallel Data Warehouse
Azure SQL Managed Instance (Extended Private Preview)
Connection string
Connection via Microsoft SQL Server 2019 is supported, but some features of this version may not be available.
When using the connection string as a Global variable, the backslash must be escaped (\\) so the driver correctly identifies the instance:
Oracle
19.x
18.3
12.2 or 12cR2
12.1 or 12cR1
11.2 or 11gR2
Connection strings
Only thin-type connections are supported. By accessing the databases specified in this connection string, you confirm that you have the required Oracle licenses.
The connection string can contain multiple endpoints. The driver will attempt to connect to each one in sequence until successful. If you configure "oracle.net.connect_timeout" in Custom Connection Properties for DB V2, Stream DB V3, and Stored Procedure, note that the timeout applies to each endpoint individually, not globally.
MySQL
5.6
5.7
8.0
Connection string
The Digibee Integration Platform deactivates the MySQL driver's interpretation of MariaDB strings. However, you can use the MariaDB driver to connect to older versions of MySQL.
MariaDB
5.5.3+
Connection string
The Digibee Integration Platform deactivates the MySQL driver's interpretation of MariaDB strings.
Progress
OpenEdge 10.1.x+
Connection string
Sybase
SAP/Sybase ASE
Connection string
PostgreSQL
All versions are supported.
Connection string
OLAP DataSource via MDX
Hyperion Essbase 7
Microsoft Analysis Services 2005
Mondrian (no version information)
SAP BW 3.0a+
Connection strings
JTOpen for AS/400
No compatibility information.
Connection string
The Database Access port (default 8471) must be mapped according to the IBM documentation. We recommend specifying the prompt=false parameter to prevent the driver from requesting credentials, which are passed automatically.
SAP HANA
No compatibility information.
Connection string
Firebird
2.5+
Connection string
DB Informix
No compatibility information.
By accessing the databases specified in this connection string, you confirm that you have the required IBM licenses.
Connection string
Netsuite
No compatibility information.
By accessing the databases specified in this connection string, you confirm that you have the required Netsuite licenses.
This database driver supports only the SELECT operation.
Connection string
Snowflake
By accessing the databases specified in this connection string, you confirm that you have the required Snowflake licenses.
3.51.x+
Connection strings
Read Snowflake's documentation to learn more about configuring connection string parameters.
We are currently using the legacy version 3.10.3 of the JDBC driver due to a limitation in more recent versions: it's not possible to work with a microservice allocating 64MB of memory (this configuration refers to a small pipeline in the Digibee Integration Platform). See Snowflake's driver change log for more details.
Known limitations
CLOB and BLOB: Not supported. The "Blob as File" option will not work in the DB V2 and Stream DB V3 connectors. See Snowflake's documentation on unsupported data types and binary input and output.
OUT and INOUT parameters: Not supported. The driver returns a
SQLFeatureNotSupportedExceptionerror.BINARY and VARBINARY fields: Not supported in Batch Mode.
Errors in Batch Mode: The driver doesn't return success or error counts — only the first SQL exception is returned and the entire transaction is rolled back, even if "rollbackOnError" is deactivated.
Last updated
Was this helpful?