Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Management Platform
Data Services Platform
Real-Time Big Data Platform
Before you begin
- You have selected the Profiling perspective.
- You have read What you need to know about some databases carefully.
About this task
In the DQ Repository tree view, expand
Metadata, right-click DB
Connections and select Create DB
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.
Set other connection metadata (Purpose,
Description, and Author) in the
The Database Connection wizard opens.
- Click Next.
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.
- In the DB Version field, select the version of the database to which you are creating the connection.
- Enter your login, password, server, and port information in their corresponding fields.
In the Database field, enter the database name you are
When you need to connect to all of the catalogs within one connection, if the database allows you to, leave this field empty.
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.
Export your connection as a context and centralize it under the
Context node in the
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.
Click Finish to close the Database
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.
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.