Configuring the database connection

Procedure

Double-click the tDBConnection_1 component to open its Basic settings view.
With the Property Type set to Built-In, specify the connection details in the relevant fields, including:
- the host name or IP address of your database server
- the listening port number
- the database name
- the user name and password for your database authentication.
If you have stored your connection details under the Metadata node in the Repository tree view, you can simply drop your centralized metadata item onto the tMysqlConnection component. For information on how to centralize a database connection, see Centralizing database metadata.
Select the Use or register a shared DB Connection check box so that the database connection open by this component can be shared across different Jobs. Then, enter a name for the shared connection between double quotes in the Shared DB Connection Name field, shared_mysql_connection in this example.

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