# Supported databases

You can access databases using specific connectors, such as [DB V2](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/db-v2), [Stream DB V3](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/stream-db-v3), and [Stored Procedure](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/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

| Supported versions |
| ------------------ |
| 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

| Supported versions      |
| ----------------------- |
| DB2 level version: 11.5 |
| Driver version: 4.26.14 |

**Connection string**

```
jdbc:db2://127.0.0.1:1724/dbtest
```

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](https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads).

***

### Apache Hive

Supported via JDBC Connector 2.6.17 for Cloudera Enterprise only.

| Supported versions       |
| ------------------------ |
| Apache Hive 1.0.0 to 3.1 |

**Connection string**

```
jdbc:hive2://localhost:10002
```

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](https://docs.cloudera.com/documentation/other/connectors/hive-jdbc/2-6-17.html).

***

### Teradata Database

| Supported versions |
| ------------------ |
| 16.10              |
| 16.20              |
| 17.00              |
| 17.10              |
| 17.20              |

**Connection string**

```
jdbc:teradata://192.168.64.2/DATABASE=DBC,DBS_PORT=1025
```

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

| Supported 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]]
```

Connection via Microsoft SQL Server 2019 is supported, but some features of this version may not be available.

{% hint style="warning" %}
When using the connection string as a [Global variable](https://app.gitbook.com/s/jvO5S91EQURCEhbZOuuZ/platform-administration/settings/globals), the backslash must be escaped (`\\`) so the driver correctly identifies the instance:

{% code overflow="wrap" %}

```
jdbc:sqlserver://[serverName[\\instanceName][:portNumber]]
```

{% endcode %}
{% endhint %}

***

### Oracle

| Supported versions |
| ------------------ |
| 19.x               |
| 18.3               |
| 12.2 or 12cR2      |
| 12.1 or 12cR1      |
| 11.2 or 11gR2      |

**Connection strings**

{% tabs %}
{% tab title="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)))
```

{% endtab %}

{% tab title="Service Name SyntaxTab" %}

```
jdbc:oracle:thin:@//localhost:5221/orcl
```

{% endtab %}
{% endtabs %}

Only thin-type connections are supported. By accessing the databases specified in this connection string, you confirm that you have the required Oracle licenses.

{% hint style="info" %}
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](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/db-v2), [Stream DB V3](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/stream-db-v3), and [Stored Procedure](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/stored-procedure), note that the timeout applies to each endpoint individually, not globally.&#x20;
{% endhint %}

***

### MySQL

| Supported versions |
| ------------------ |
| 5.6                |
| 5.7                |
| 8.0                |

**Connection string**

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

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

| Supported versions |
| ------------------ |
| 5.5.3+             |

**Connection string**

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

The Digibee Integration Platform deactivates the MySQL driver's interpretation of MariaDB strings.

***

### Progress

| Supported versions |
| ------------------ |
| OpenEdge 10.1.x+   |

**Connection string**

```
jdbc:datadirect:openedge://hostname:port
```

***

### Sybase

| Supported versions |
| ------------------ |
| SAP/Sybase ASE     |

**Connection string**

```
jdbc:sybase:Tds:host:port
```

***

### PostgreSQL

All versions are supported.

**Connection string**

```
jdbc:postgresql://host:port/database
```

***

### OLAP DataSource via MDX

| Supported versions                |
| --------------------------------- |
| Hyperion Essbase 7                |
| Microsoft Analysis Services 2005  |
| Mondrian (no version information) |
| SAP BW 3.0a+                      |

**Connection strings**

{% tabs %}
{% tab title="MS SQL Server" %}
{% code overflow="wrap" %}

```
jdbc:jdbc4olap:http://<server>:<port>/OLAP/msmdpump.dll
```

{% endcode %}
{% endtab %}

{% tab title="Mondrian" %}

```
jdbc:jdbc4olap:http://<server>:<port>/mondrian/xmla
```

{% endtab %}

{% tab title="SAP BW" %}

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

{% endtab %}
{% endtabs %}

***

### JTOpen for AS/400

No compatibility information.

**Connection string**

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

The Database Access port (default 8471) must be mapped according to the [IBM documentation](https://www.ibm.com/support/pages/tcpip-ports-required-ibm-i-access-and-related-functions). 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**

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

***

### Firebird

| Supported versions |
| ------------------ |
| 2.5+               |

**Connection string**

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

***

### DB Informix

No compatibility information.

{% hint style="warning" %}
By accessing the databases specified in this connection string, you confirm that you have the required IBM licenses.&#x20;
{% endhint %}

**Connection string**

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

***

### Netsuite

No compatibility information.

{% hint style="warning" %}
By accessing the databases specified in this connection string, you confirm that you have the required Netsuite licenses.&#x20;
{% endhint %}

This database driver supports only the SELECT operation.

**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

{% hint style="warning" %}
By accessing the databases specified in this connection string, you confirm that you have the required Snowflake licenses.
{% endhint %}

| Supported versions |
| ------------------ |
| 3.51.x+            |

**Connection strings**

{% tabs %}
{% tab title="Syntax" %}

```
jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>
```

{% endtab %}

{% tab title="Example" %}

```
jdbc:snowflake://wxyz.us-central1.gcp.snowflakecomputing.com/?db=snowflake_sample_data&sfSchema=TPCH_SF100
```

{% endtab %}
{% endtabs %}

Read [Snowflake's documentation](https://docs.snowflake.com/en/user-guide/jdbc-configure.html) to learn more about configuring connection string parameters.

{% hint style="info" %}
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](https://docs.snowflake.com/en/release-notes/client-change-log-jdbc) for more details.&#x20;
{% endhint %}

**Known limitations**

* **CLOB and BLOB:** Not supported. The "Blob as File" option will not work in the [DB V2](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/db-v2) and [Stream DB V3](https://docs.digibee.com/documentation/connectors-and-triggers/connectors/structured-data/stream-db-v3) connectors. See Snowflake's documentation on [unsupported data types](https://docs.snowflake.com/en/sql-reference/data-types-unsupported.html) and [binary input and output](https://docs.snowflake.com/en/user-guide/binary-input-output.html).
* **OUT and INOUT parameters:** Not supported. The driver returns a `SQLFeatureNotSupportedException` error.
* **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.