# Supported databases for profiling data

Available in...

* Big Data Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Real-Time Big Data Platform

The table below lists the databases supported from the Profiling perspective of Talend Studio. For a complete list about supported third-party systems, see [Supported database or business systems for Talend components](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-04-and-earlier/supported-systems-databases-and-business-applications-talend-components "Their access depends on the Talend Studio monthly version you are using. For more information, see Talend Release Notes.").

Information noteTip: If the database you want to connect to is not in the list but has a JDBC driver, like Snowflake, you can use a JDBC connection.

| Database name | Database version |
| --- | --- |
| Amazon Aurora | Amazon RDS for Aurora<br><br>MySQL 8 (from 8.0 R2023-06)<br><br>MySQL<br>5 |
| Amazon Redshift | Initial release of Amazon Redshift<br><br>Information noteNote: External tables are<br>supported from Talend Studio 8.0 R2023-07 onwards. |
| AS/400 | <ul> <li>V7R1 to V7R3</li> <li>V6R1 to V7R2</li> </ul> |
| Hive | See [Supported Hive distributions for profiling data](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-04-and-earlier/supported-hive-distributions-for-profiling-data "The table below shows the compatibility between big data distributions and the HiveServer."). |
| IBM DB2 and IBM DB2 Z/OS | <ul> <li>11.1</li> <li>10.5</li> </ul><br><br>Information noteNote: Binary large objects (BLOBs) are not supported. |
| Impala (a sub-module of Cloudera) | CDP 7.1.1 and later |
| Informix | 11.50 |
| Microsoft SQL Server | <ul> <li>Amazon RDS for SQL Server</li> <li>Azure SQL Database</li> <li>Azure Synapse Analytics</li> <li>2017</li> <li>2016</li> <li>2014</li> </ul> |
| MySQL | <ul> <li>Amazon RDS for MySQL</li> <li>Amazon RDS for MariaDB</li> <li>Azure Database for MySQL</li> <li>MySQL 8.0</li> <li>MySQL 5.1/5.5/5.6</li> <li>MariaDB</li> </ul> |
| Netezza | <ul> <li>7.2</li> <li>6</li> </ul> |
| Oracle with SID | <ul> <li>Amazon RDS for Oracle</li> <li>Oracle 19c</li> <li>Oracle 18c</li> <li>Oracle 12c Release 1</li> </ul> |
| Oracle with service name | <ul> <li>Amazon RDS for Oracle</li> <li>Oracle 19c</li> <li>Oracle 18c</li> <li>Oracle 12c Release 1</li> </ul> |
| Oracle Custom with SSL | Oracle 18 and later |
| PostgreSQL | <ul> <li>Amazon RDS for PostgreSQL</li> <li>Azure Database for PostgreSQL</li> <li>12 and later</li> <li><div><span>Availability-note</span><a data-type="deprecated" aria-describedby="availability-tooltip-24b9f8" href="https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-deprecated" target="_blank">Deprecated</a><div>This content is deprecated.</div></div>8.3, 9.1+, and 10</li> </ul><br><br>Information noteNote: From Talend Studio 8.0.<br>R2024-03 onwards, only the PostgreSQL versions 12 and later are supported. The earlier<br>versions have been removed.<br><br>Information noteNote: Foreign tables are supported from Talend Studio 8.0 R2023-07 onwards. |
| SAP HANA | 2.0<br><br>SAP HANA is supported for Table, View, and Calculation View<br>schemas. |
| SQLite | 3.6.7 |
| Sybase (ASE and IQ) | <ul> <li>16.0</li> <li>15.7</li> <li>15.2</li> <li>12.7</li> <li>12.5</li> </ul> |
| Teradata | <ul> <li>16</li> <li>15</li> <li>14</li> <li>13</li> <li>12</li> </ul> |
| Vertica | <ul> <li>12</li> <li><div><span>Availability-note</span><a data-type="deprecated" aria-describedby="availability-tooltip-01626d" href="https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-deprecated" target="_blank">Deprecated</a><div>This content is deprecated.</div></div>9.x</li> </ul> |