Create a reusable database connection in Talend Studio.
Procedure
- In the Repository, expand the Metadata node.
-
Right-click Db
Connections and click Create
connection.
- In the list of databases, select MySQL and click Finish.
-
Enter a Name for your
connection, connection_mysql, for
example.
The name should start with connection_ in order to create variables that can be used to create a connection in Talend Management Console.
- Optional: Enter a Purpose and a Description.
- Click Next.
-
Enter your database information.
Example
-
Click Export as context to create context variables out
of your database information.
- Select Create a new repository context and click Next.
- Enter a Name, Purpose and Description for your context group and click Next.
-
Click Finish.
Example
- Click Test connection, click OK if the test is successful, then click Finish.
- Expand the Metadata > Db Connections nodes, then right-click your connection and click Retrieve schema.
- In the dialog box that appears, keep the default settings and click Next.
-
Select your movies
table.
- Click Next, then click Finish.