Creating a connection to a custom database - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

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

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.

What to do next

After creating 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. But 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.

Note: If you have a problem profiling a custom database even though you use a JDBC connection, the reason could be that some JDBC functions are not implemented by the JDBC driver library. Please raise an issue or ask support via Talend Community at: https://community.talend.com/