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.

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:

Amazon Aurora

The Digibee Integration Platform offers support for both Amazon Aurora engines.

Amazon Aurora MySQL

The Digibee Integration Platform offers support for the following versions:

  • 1, 2, and 3

Connection String

jdbc:mysql://<host>:<port>/<database>

Amazon Aurora PostgreSQL

The Digibee Integration Platform offers support for all versions.

Connection String

jdbc:postgresql://<host>:<port>/<database>

DB2

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/dbtest

Apache Hive

The 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:10002

Teradata Database

The 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=1025

SQL Server

The 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]]

Oracle

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/orcl

MySQL

The Digibee Integration Platform offers support for the following versions:

  • 5.6

  • 5.7

  • 8.0

Connection String

jdbc:mysql://<host>:<port>/<database>

Maria DB

The Digibee Integration Platform offers support for the following version:

  • 5.5.3+

Connection String

jdbc:mariadb://<host>:<port>/<database>

Progress

The Digibee Integration Platform offers support for the following version:

  • OpenEdge 10.1.x+

Connection String

jdbc:datadirect:openedge://hostname:port

Sybase

The Digibee Integration Platform offers support for the following version:

  • SAP/Sybase ASE

Connection String

jdbc:sybase:Tds:host:port

PostgreSQL

The Digibee Integration Platform offers support for all versions.

Connection String

jdbc:postgresql://host:port/database

OLAP DataSource via MDX

The 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.dll
  • Mondrian

jdbc:jdbc4olap:http://<server>:<port>/mondrian/xmla
  • SAP BW

jdbc:jdbc4olap:http://<server>:<port>/sap/bw/soap/xmla?sap-client=number

JTOpen for AS/400

No compatibility information

Connection String

jdbc:as400://<server>[:port];prompt=false

SAP HANA

No compatibility information

Connection String

jdbc:sap://<server>:<port>

Firebird

The Digibee Integration Platform offers support for the following versions:

  • 2.5+

Connection String

jdbc:firebirdsql://<HOST>:<PORT>/C:\PATH_TO_DATABASE/DATABASE_FILE.FDB

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

jdbc:informix-sqli://<HOST>:<PORT>/<DATABASE>:informixserver=<INFORMIX_SERVER>

Netsuite

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})

Snowflake

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_SF100

Read Snowflake's documentation to know more about configuring connection string parameters.

Last updated

Was this helpful?