The databases are accessed by components created specifically for that, such as:

If you want to know more about the components above, just click on their names or versions to read the respectives articles.

The Digibee Platform currently supports the following databases:

SQL Server

In these versions:

  • 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

In these versions:

  • 19.x

  • 18.3

  • 12.2 ou 12cR2

  • 12.1 ou 12cR1

  • 11.2 ou 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

IMPORTANT: keep in mind that only the thin-type connections are supported. When accessing the databases specified in this connection string, you agree that you have the necessary Oracle licenses.

Mysql

In these versions:

  • 5.6

  • 5.7

  • 8.0

Connection String

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

IMPORTANT: Digibee Platform disables the Maria DB strings interpretation by Mysql driver. However, it's possible to use Maria DB drive to connect to older versions of Mysql.

Maria DB

In the version:

  • 5.5.3+

Connection String

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

IMPORTANT: Digibee Platform disables the Maria DB strings interpretation by Mysql driver.

Progress

In the version:

  • OpenEdge 10.1.x+

Connection String

jdbc:datadirect:openedge://hostname:port

Sybase

In the version:

  • SAP/Sybase ASE

Connection String

jdbc:sybase:Tds:host:port

PostgreSQL

In all the versions

Connection String

jdbc:postgresql://host:port/database

OLAP DataSource via MDX

In these versions:

  • Hyperion Essbase 7

  • Microsoft Analysis Services 2005

  • Mondrian (sem informação de versão)

  • 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

IMPORTANT: this connection mode uses the XMLA standard (XML for Analysis), which must be enabled in the OLAP server to be accessed.

JTOpen for AS/400

No compatibility information

Connection String

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

IMPORTANT:

  • The Database Access port (standard 8471) must be mapped according to the IBM documentation. Click here to access it.

  • Specify the “prompt=false” parameter for the driver not to request credentials, which are automatically provided.

SAP HANA

No compatibility information

Connection String

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

Data Bricks (managed Apache Spark)

In all the versions

Connection String

jdbc:spark://<server-hostname>:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/0/xxxx-xxxxxx-xxxxxxxx;AuthMech=3

IMPORTANT: the driver supports connections with the Data Bricks service. To obtain a license of use, click here to make the necessary registration.

Hive JDBC Connector

In the versions:

  • Apache Hive (from 0.11 to 3.1)

Connection Strings

  • with Kerberos

jdbc:hive2://node1.example.com:10000;AuthMech=1; KrbRealm=EXAMPLE.COM;KrbHostFQDN=hs2node1.example.com; KrbServiceName=hive;KrbAuthType=2

  • with user and password

jdbc:hive2://node1.example.com:10000;AuthMech=2; transportMode=sasl

Firebird

In the versions:

  • 2.5+

Connection String

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

DB Informix

By accessing the databases specified in this connection string, you confirm to have the necessary IBM licenses.

No compatibility information

Connection String

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

Netsuite

By accessing the databases specified in this connection string, you confirm to have the necessary Netsuite licenses.

IMPORTANT: this database driver supports the SELECT operation only.

No compatibility information

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

When accessing the databases specified in this string connection, you agree to have the necessary Snowflake licences.

In the 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

Click here to have more information about abou the string connection parameters configuration.

IMPORTANT:

1. The 3.10.3 version of the JDBC driver is being used due to a limitation in its current versions - it's not possible to work with micro service by allocating a 64MB memory, configurations that refers to a small pipeline in the Digibee Platform. For more information about the change log of this driver, click here.

2. Snowflake doesn't support the CLOB or BLOB fields. Given that, the “Blob as File” option won't work for the DB and Stream DB componentes. Click here and here to obtain more information.

3. When the batch mode is used and there's an error, the Snowflake driver doesn't return the amount of successful transactions or the amount of errors. Only the first SQL execution error is returned and the rollback of the whole transaction is made even when the “rollbackOnError” option isn't selected.

4. Snowflake doesn't support the OUT and INOUT parameters, returning the SQLFeatureNotSupportedException error.

5. When the batch mode is used, the BINARY and VARBINARY fields aren't supported.

Did this answer your question?