Connecting to a database - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

Before proceeding to analyze data in a specific database, you must first set up the connection to this database. From the Profiling perspective of Talend Studio, you can create a connection on the DataBase Management System (DBMS) and show database content.

The databases you can analyze from the Studio include Hive and Amazon Redshift. For further information about what databases you can profile, see What databases are supported from the Profiling perspective and the section about supported databases in the Talend Installation and Upgrade Guide.

Connections to different databases are reflected by different tree levels and different icons in the DQ Repository tree view because the logical and physical structure of data differs from one relational database to another. The highest level structure "Catalog" followed by "Schema" and finally by "Table" is not applicable to all database types. For further information, see Catalogs and schemas in database systems.