Creating a connection to a custom database - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

The database connection wizard in Talend Studio lists the databases to which you can create a connection and do profiling and integration processes.

Currently, fewer databases in the list are supported for profiling data. For further information, see What databases are supported from the Profiling perspective and Supported database or business systems for Talend components.

You can still use Talend Studio to connect to a custom unsupported database.

Procedure

  1. Choose JDBC as the database type in the connection wizard.
  2. Fill in the connection parameters.
    For further information, see Centralizing JDBC metadata.

What to do next

After you created the connection to a custom database, you can profile and monitor data in this database by using different analyses and indicators, as you do with supported databases. You may need to change, in the Indicator Settings editor, the SQL query template for some indicators, such as the regex indicator where each database has a different function to call. For further information, see Editing a system indicator and Editing a user-defined indicator.

Remember: If you have a problem profiling a custom database even though you use a JDBC connection, the reason may be that some JDBC functions are not implemented by the JDBC driver library. For more information, contact Talend support.