Creating a connection - 7.3

Talend Open Studio User Guide
Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

Open Studio for Data Quality

Before you begin

You have read What you need to know about some databases carefully.

Procedure

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

    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.
    Note: 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; on the Java engine, see Using the Java or the SQL engine.
  6. Enter your login, password, server, and port information in their corresponding fields.
  7. In the Database field, enter the database name you are connecting to.
    When you need to connect to all of the catalogs within one connection, if the database allows you to, leave this field empty.
  8. 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 the Talend Installation and Upgrade Guide or Talend Cloud Installation Guide or click the How to install a driver link in the wizard.
    For further information about the Module view, see Displaying the Modules view.
  9. 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.