IMPORTANT: This documentation has been discontinued. Read the updated Supported Databases documentation on our new documentation portal.
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>
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.