Supported databases
Discover the types and versions of databases supported by the Digibee Integration Platform and how they can make integration pipeline creation easier for all users.
Was this helpful?
Discover the types and versions of databases supported by the Digibee Integration Platform and how they can make integration pipeline creation easier for all users.
Was this helpful?
Was this helpful?
You can access databases using specific components, such as:
The database support mentioned here doesn't apply to deprecated versions of components. We recommend that you don't use deprecated components. Some examples of deprecated components are:
The Digibee Integration Platform currently supports the following databases:
The Digibee Integration Platform offers support for both Amazon Aurora engines.
The Digibee Integration Platform offers support for the following versions:
1, 2, and 3
Connection String
jdbc:mysql://<host>:<port>/<database>
The Digibee Integration Platform offers support for all versions.
Connection String
jdbc:postgresql://<host>:<port>/<database>
The Digibee Integration Platform offers support for the JDBC IBM DB2 driver and covers the following versions:
DB2 level version: 11.5
Driver version: 4.26.14
Connection String
jdbc:db2://127.0.0.1:1724/dbtestThe Digibee Integration Platform offers support for Apache Hive via JDBC Connector 2.6.17 for Cloudera Enterprise only and covers the following versions:
Apache Hive versions 1.0.0 to 3.1
Connection string
jdbc:hive2://localhost:10002The Digibee Integration Platform offers support for the following versions:
Teradata Database 16.10, 16.20, 17.00, 17.10 and 17.20.
Connection String
jdbc:teradata://192.168.64.2/DATABASE=DBC,DBS_PORT=1025The Digibee Integration Platform offers support for the following versions:
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
jdbc:sqlserver://[serverName[\instanceName][:portNumber]]The Digibee Integration Platform offers support for the following versions:
19.x
18.3
12.2 or 12cR2
12.1 or 12cR1
11.2 or 11gR2
Connection Strings
Oracle Net Syntax
jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=5221))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=5221)))
(CONNECT_DATA=(SERVICE_NAME=orcl)))Syntax with Service Name
jdbc:oracle:thin:@//localhost:5221/orclThe Digibee Integration Platform offers support for the following versions:
5.6
5.7
8.0
Connection String
jdbc:mysql://<host>:<port>/<database>The Digibee Integration Platform offers support for the following version:
5.5.3+
Connection String
jdbc:mariadb://<host>:<port>/<database>The Digibee Integration Platform offers support for the following version:
OpenEdge 10.1.x+
Connection String
jdbc:datadirect:openedge://hostname:portThe Digibee Integration Platform offers support for the following version:
SAP/Sybase ASE
Connection String
jdbc:sybase:Tds:host:portThe Digibee Integration Platform offers support for all versions.
Connection String
jdbc:postgresql://host:port/databaseThe Digibee Integration Platform offers support for the following versions:
Hyperion Essbase 7
Microsoft Analysis Services 2005
Mondrian (no version information)
SAP BW 3.0a+
Connection Strings
MS SQL Server
jdbc:jdbc4olap:http://<server>:<port>/OLAP/msmdpump.dllMondrian
jdbc:jdbc4olap:http://<server>:<port>/mondrian/xmlaSAP BW
jdbc:jdbc4olap:http://<server>:<port>/sap/bw/soap/xmla?sap-client=numberNo compatibility information
Connection String
jdbc:as400://<server>[:port];prompt=falseNo compatibility information
Connection String
jdbc:sap://<server>:<port>The Digibee Integration Platform offers support for the following versions:
2.5+
Connection String
jdbc:firebirdsql://<HOST>:<PORT>/C:\PATH_TO_DATABASE/DATABASE_FILE.FDBNo compatibility information
By accessing the databases specified in this connection string, you confirm that you have the required IBM licenses.
Connection String
jdbc:informix-sqli://<HOST>:<PORT>/<DATABASE>:informixserver=<INFORMIX_SERVER>No compatibility information
By accessing the databases specified in this connection string, you confirm that you have the required Netsuite licenses.
Connection String
jdbc:ns://{Server Host}:{Server Port};ServerDataSource={Server Data Source};encrypted=1;Ciphersuites={Cipher Suite};CustomProperties=(AccountID={Account Id};RoleID={Role Id})By accessing the databases specified in this connection string, you confirm that you have the required Snowflake licenses.
The Digibee Integration Platform offers support for the following versions:
3.51.x +
Connection Strings
Syntax
jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>Example
jdbc:snowflake://wxyz.us-central1.gcp.snowflakecomputing.com/?db=snowflake_sample_data&sfSchema=TPCH_SF100Read Snowflake's documentation to know more about configuring connection string parameters.