# Supported databases for profiling data

Available in...

* Big Data Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* 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/supported-systems-databases-and-business-applications-talend-components).

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

| Database name | Database version |
| --- | --- |
| Amazon Aurora | Amazon RDS for Aurora<br><br>MySQL 8 |
| Amazon Redshift | Initial release of Amazon Redshift<br><br>Information noteNote: External tables are<br>supported. |
| AS/400 | <ul> <li>V7R3 and later</li> <li>V6R1 to V7R2 (deprecated)</li> </ul> |
| Hive | See [Supported Hive distributions for profiling data](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/supported-hive-distributions-for-profiling-data). |
| 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>2025</li> <li>2022</li> <li>2019</li> <li>2017</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.x except 8.0</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 23ai<p>Vector and JSON data types are                              not supported.</p></li> <li>Oracle 19c</li> <li>Oracle 18c</li> </ul> |
| Oracle with service name | <ul> <li>Amazon RDS for Oracle</li> <li>Oracle 23ai<p>Vector and JSON data types are                              not supported.</p></li> <li>Oracle 19c</li> <li>Oracle 18c</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> </ul><br><br>Information noteNote: Foreign tables are supported. |
| SAP HANA | 2.0<br><br>SAP HANA is supported for Table, View, and Calculation View<br>schemas. |
| Snowflake | Not applicable.<br><br>You can use the following authentication methods:<br><br><ul> <li>Basic</li> <li>Key-pair</li> <li>OAuth 2.0</li> </ul> |
| SQLite | 3.6.7 |
| Sybase (ASE and IQ) | 16.0 |
| Teradata | <ul> <li>16</li> <li>15</li> <li>14</li> <li>13</li> <li>12</li> </ul> |
| Vertica | <ul> <li>12</li> <li>9.x (deprecated)</li> </ul> |