# Compatible databases

The following tables provide information on the recommended and supported databases you can use with Talend server modules.

In the following documentation:

* Recommended: designates an environment recommended by Talend based on our experiences and customer usage.
* Supported: designates a supported environment for use with the listed component or service.
* Supported with limitations: designates an environment that is supported by Talend but with certain conditions explained in notes.

## Talend Administration Center

Compatible databases for Talend Administration CenterCompatible databases for Talend Administration Center

| Database | Version | Supported driver | Support type |
| --- | --- | --- | --- |
| MySQL^1^ | 8.0 | mysql-connector-java-8.x.jar | Recommended |
| 5.7 | Supported |  |  |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c release 1 | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | jtds-1.3.1\_patched.jar | Supported |
| H2 ^2^ | 1.4 | h2-1.4.187.jar | Not supported for production |
| MariaDB ^3^ | 10.1 | mariadb-java-client-1.1.7.jar | Supported |
| MS SQL Server ^4^ | 2017 | jtds-1.3.1.jar | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 SP2 | Supported |  |  |
| PostgreSQL | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 | Supported |  |  |

Information noteNote: All the databases stated above are supported regardless of the hosting mode, Google Cloud Platform and Amazon RDS included.

^1 MySQL cluster is not supported for Talend Administration Center.^

^2 Embedded for developement, test, and demo purposes only.^

^3 When you create a database schema using MariaDB 10.1, you must use UTF8 encoding. For example: CREATE DATABASE &lt;YOUR\_DATABASE\_NAME&gt; DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8\_general\_ci;^

^4 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

## Talend MDM Server

Compatible databases for Talend MDM Server Compatible databases for Talend MDM ServerTalend MDM Server

| Database | Versions | Supported drivers | Support type |
| --- | --- | --- | --- |
| MySQL ^1,<br>5^ | 8.0 | mysql-connector-java-8.x.jar | Recommended |
| 5.7 | Supported |  |  |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c Release 1 ^5^ | Recommended |  |  |
| 11g | Supported |  |  |
| Amazon Aurora Database |  |  | Supported |
| AzureSQL |  | jtds-1.3.1\_patched.jar | Supported |
| H2 ^2^ | 1.4 | h2-1.4.187.jar | Not supported for production |
| IBM DB2 | 10.5 |  | Supported |
| MS SQL Server | 2017 ^5^ | mssql-jdbc-9.2.1.jre8.jar<br><br>mssql-jdbc-9.2.1.jre11.jar | Supported |
| 2016 (SP2) | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 (SP2) | Supported |  |  |
| PostgreSQL | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 ^5^ | Supported |  |  |

^1 Google Cloud SQL is supported.^

^2 Embedded for developement, test, and demo purposes only.^

^3 When you create a database schema using MariaDB 10.1, you must use UTF8 encoding. For example: CREATE DATABASE &lt;YOUR\_DATABAE\_NAME&gt; DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8\_general\_ci;^

^4 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^5 Amazon RDS is supported.^

## Talend Identity and Access Management

Information noteNote:

Use the same database type and version for oidc and idp databases.

For more information about the databases supported by Apache Syncope, see [Apache Syncope documentation](https://syncope.apache.org/docs/2.0/reference-guide.html#dbms).

Compatible databases for Talend Identity and Access Management Compatible databases for Talend Identity and Access ManagementTalend Identity and Access Management

| Database | Version | Supported drivers | Support type |
| --- | --- | --- | --- |
| MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c Release 1 ^3^ | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | Latest available version of Microsoft driver<br>supporting your version of SQL Server. For more information, check<br>[Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | Supported |
| H2 ^4^ | 1.4 | h2-1.4.187.jar | Not supported for production |
| MS SQL Server ^2, 3^ | 2017 | Latest available version of<br>Microsoft driver supporting your version of SQL Server. For more<br>information, check [Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 (SP2) | Supported |  |  |
| PostgreSQL ^3^ | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 ^3^ | Supported |  |  |

^1 Google Cloud SQL is supported.^

^2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^3 Amazon RDS is supported.^

^4 Embedded for developement, test, and demo purposes only.^

## Talend Activity Monitoring Console

Compatible databases for Talend Activity Monitoring Console Compatible databases for Talend Activity Monitoring ConsoleTalend Activity Monitoring Console

| Database | Version | Supported drivers | Support type |
| --- | --- | --- | --- |
| MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c release 1 ^3^ | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | jtds-1.3.1\_patched.jar | Supported |
| H2 ^4^ | 1.4 | h2-1.4.187.jar | Not supported for production |
| IBM DB2 | 10.5 |  | Supported |
| MS SQL Server ^2, 3^ | 2017 | jtds-1.3.1.jar | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 SP2 | Supported |  |  |
| PostgreSQL ^3^ | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 | Supported |  |  |

^1 Google Cloud SQL is supported.^

^2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^3 Amazon RDS is supported.^

^4 Embedded for developement, test, and demo purposes only.^

## Service Activity Monitoring (SAM)

Compatible databases for Service Activity Monitoring Compatible databases for Service Activity MonitoringService Activity Monitoring

| Database | Version | Supported drivers | Support type |
| --- | --- | --- | --- |
| MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c release 1 ^3^ | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | jtds-1.3.1\_patched.jar | Supported |
| Derby DB | 10.8 (or later) |  | Supported |
| IBM DB2 | 10.5 |  | Supported |
| MS SQL Server ^2, 3^ | 2017 | jtds-1.3.1.jar | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 SP2 | Supported |  |  |
| PostgreSQL ^3^ | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 | Supported |  |  |

^1 Google Cloud SQL is supported.^

^2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^3 Amazon RDS is supported.^

## ESB Service Registry/Authorization/Event Logging

Compatible databases for ESB Service Registry/Authorization/Event LoggingCompatible databases for ESB Service RegistryService Registry/Authorization/Event Logging

| Database | Version | Supported drivers | Support type |
| --- | --- | --- | --- |
| MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c release 1 ^3^ | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | jtds-1.3.1\_patched.jar | Supported |
| HSQL ^4^ | 2.3.2 |  | Supported |
| Derby DB | 10.8 (or later) |  | Supported |
| IBM DB2 | 10.5 |  | Supported |
| MS SQL Server ^2, 3^ | 2017 | jtds-1.3.1.jar | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 SP2 | Supported |  |  |
| PostgreSQL ^3^ | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 | Supported |  |  |

^1 Google Cloud SQL is supported.^

^2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^3 Amazon RDS is supported.^

^4 Embedded in the product.^

Availability-note[Deprecated](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-deprecated)

This content is deprecated.

## Talend DQ Portal

Talend DQ Portal is deprecated from Talend 7.1 onwards.

Compatible databases for Talend DQ Portal Compatible databases for Talend DQ PortalTalend DQ Portal

| Database | Version | Supported drivers | Support type |
| --- | --- | --- | --- |
| MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended |
| 5.7 | Supported |  |  |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c release 1 ^3^ | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | jtds-1.3.1\_patched.jar | Supported |
| MS SQL Server ^2, 3^ | 2017 | jtds-1.3.1.jar | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 SP2 | Supported |  |  |
| PostgreSQL ^3^ | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 | Supported |  |  |

Information noteNote:

If you are using MySQL, the my.ini file of your MySQL server installation directory must be edited in order to add the following line:

```
max_allowed_packet = 64M
```

The 64M value is only given as example. It represents the maximum size of a query packet the server can handle as well as the maximum query size the server can process. You can replace it with any value superior to 16M.

^1 Google Cloud SQL is supported.^

^2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^3 Amazon RDS is supported.^

| Database used to store the portal<br>configuration | Version | Support type |
| --- | --- | --- |
| HSQL ^1^ | 2.3.2 | Supported |

^1 Embedded in the product.^

## Talend Repository Manager

Compatible databases for Talend Repository Manager Compatible databases for Talend Repository ManagerTalend Repository Manager

| Database | Version | Supported driver | Support type |
| --- | --- | --- | --- |
| MySQL | 8.0 ^1, 5^ | mysql-connector-java-8.x.jar | Recommended |
| 5.7 | Supported |  |  |
| Oracle | 18c | ojdbc7-11g.jar<br><br>ojdbc7.jar<br><br>ojdbc8.jar | Supported |
| 12c release 1 ^5^ | Recommended |  |  |
| 11g | Supported |  |  |
| Azure SQL |  | jtds-1.3.1\_patched.jar | Supported |
| H2 ^2^ | 1.4 | h2-1.4.187.jar | Not supported for production |
| MariaDB ^3^ | 10.1 | mariadb-java-client-1.1.7.jar | Supported |
| MS SQL Server ^4, 5^ | 2017 | jtds-1.3.1.jar | Supported |
| 2016 | Supported |  |  |
| 2014 | Supported |  |  |
| 2012 SP2 | Supported |  |  |
| PostgreSQL ^5^ | 11 | postgresql-42.2.2.jre7.jar | Supported |
| 10 | Supported |  |  |
| 9.6 | Supported |  |  |
| 9.5 | Supported |  |  |

^1 Google Cloud SQL is supported.^

^2 Embedded for developement, test, and demo purposes only.^

^3 When you create a database schema using MariaDB 10.1, you must use UTF8 encoding. For example: CREATE DATABASE &lt;YOUR\_DATABAE\_NAME&gt; DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8\_general\_ci;^

^4 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.^

^5 Amazon RDS is supported.^

## Talend Data Preparation

Compatible databases for Talend Data Preparation Compatible databases for Talend Data PreparationTalend Data Preparation

| Database | Versions | Support type |
| --- | --- | --- |
| MongoDB | 4.x | Recommended (external to the product) |
| 3.6 | Recommended (external to the product) |  |

## Talend Data Stewardship

Compatible databases for Talend Data Stewardship Compatible databases for Talend Data StewardshipTalend Data Stewardship

| Database | Versions | Support type |
| --- | --- | --- |
| MongoDB | 4.0 | Recommended (external to the product) |
| 4.0 | Supported (embedded in the product)<br><br>Information noteNote: Version not recommended for production<br>environment as it does not support active/active<br>clustering. |  |
| 3.6 | Recommended (external to the product) |  |

## Talend Dictionary Service

Compatible databases for Talend Dictionary Service Compatible databases for Talend Dictionary ServiceTalend Dictionary Service

| Database | Versions | Support type |
| --- | --- | --- |
| MongoDB | 4.0 | Recommended (external to the product) |
| 4.0 | Supported (embedded in the product)<br><br>Information noteNote: Version not recommended for production<br>environment as it does not support active/active<br>clustering. |  |