Creating a connection - 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 you begin

You have selected the Profiling perspective of Talend Studio.

Procedure

  1. In the DQ Repository tree view, expand Metadata, right-click DB Connections and select Create DB Connection.
    The Database Connection wizard opens.
  2. In the Name field, enter a name for this new database connection.
    Do not use spaces in the connection name.
    Note:

    Avoid using special characters in the item names including:

    "~", "!", "`", "#", "^", "&", "*", "\\", "/", "?", ":", ";", "\"", ".", "(", ")", "'", "¥", "'", """, "«", "»", "<", ">".

    These characters are all replaced with "_" in the file system and you may end up creating duplicate items.

  3. If required, set other connection metadata (purpose, description and author name) in the corresponding fields and click Next to proceed to the next step.
  4. In the DB Type field and from the drop-down list, select the type of database to which you want to connect. For example, MySQL.A warning message pops up if the database type you have selected cannot be used in the Profiling perspective.
    For further information about supported databases, see the Talend Installation Guide.
    Note: If you select to connect to a database that is not supported in the studio (using the ODBC or JDBC methods), it is recommended to use the Java engine to execute the column analyses created on the selected database. For more information on column analyses, see Defining the columns to be analyzed and setting indicators, and for more information on the Java engine, see Using the Java or the SQL engine.
  5. In the DB Type field and from the drop-down list, select the type of database to which you want to connect. For example, MySQL.A warning message pops up if the database type you have selected cannot be used in the Profiling perspective.
    For further information about supported databases, see the Talend Installation and Upgrade Guide .
    If you select to connect to a database that is not supported in the studio (using the ODBC or JDBC methods), it is recommended to use the Java engine to execute the column analyses created on the selected database. For more information on column analyses, see Defining the columns to be analyzed and setting indicators, and for more information on the Java engine, see Using the Java or the SQL engine.
  6. In the DB Version field, select the version of the database to which you are creating the connection.
  7. Enter your login, password, server and port information in their corresponding fields.
    If needed, click the button to show all connection fields without having to scroll down in the wizard.
  8. In the Database field, enter the database name you are connecting to. If you need to connect to all of the catalogs within one connection, if the database allows you to, leave this field empty.
  9. Click the Check button to verify if your connection is successful.
    If you have not already installed the database driver (.jar file) necessary to use the database, you will have a wizard prompting you to install the relative third-party module, click Download and Install and then close the wizard.
    For further information about identifying and installing external modules, see the Talend Installation and Upgrade Guide or click the How to install a driver link in the wizard.
    For further information about the Module view, see Displaying the Module view.
  10. If needed, export your connection as a context and centralize it under the Context node in the Integration perspective of your Studio. This enables you to reuse this context in the data quality analyses that use the current connection. You can also create different context parameters for the same connection and later choose to execute an analysis on one specific context. For further information, see Using context variables to connect to data sources.
  11. Click Finish to close the Database Connection wizard.
    A folder for the created database connection is displayed under DB Connection in the DQ Repository tree view and under the Metadata node in the Integration perspective. The connection editor opens with the defined metadata in Talend Studio.
    Once you create the connection, you can open in Talend Studio a preview of the data in a specific database table. For further information, see Previewing data in the SQL editor.

Results

From the connection editor, you can:

  • Click Connection information to show the connection parameters for the relevant database.

  • Click the Check button to check the status of your current connection.

  • Click the Edit... button to open the connection wizard and modify any of the connection information.

For information on how to set up a connection to a file, see Connecting to a file.