Skip to main content Skip to complementary content

Creating a connection

Before you begin

About this task

When you create a connection from the Profiling perspective, the connection is also created in the Integration perspective under Metadata > DB connections.

Procedure

  1. In the DQ Repository tree view, expand Metadata, right-click DB Connections and select Create DB Connection.
    Contextual menu of the DB connections node in the Profiling perspective.
  2. In the Name field, enter a name for this new database connection.
    Do not use spaces in the connection name.
    Information noteImportant:

    Do not use the following special characters in the item names: ~ ! ` # ^ * & \\ / ? : ; \ , . ( ) ¥ ' " « » < >

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

  3. Optional: Set other connection metadata (Purpose, Description, and Author) in the corresponding fields.
    The Database Connection wizard opens.
  4. Click Next.
  5. From the DB Type drop-down list, select the type of database to which you want to connect. For example, MySQL.
    Information noteNote: To connect to a database that is not supported in Talend 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; 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.
  8. In the Database field, enter the database to which you are connecting.
    When 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.
    When you have not installed the database driver (.jar file) necessary to use the database, you see 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 Installing external modules to Talend Studio or click the How to install a driver link in the wizard.
    For further information about the Module view, see Displaying the Modules view.
  10. Optional: Export your connection as a context and centralize it under the Context node in the Integration perspective.
    This lets you 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. The connection editor opens with the defined metadata in Talend Studio.

    If you created this connection in a reference project, expand Tables > table name > Columns to select the columns from the main project.

Results

When you created 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.

From the connection editor, you can click:

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

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

  • 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!