Creating a database connection

Create a reusable database connection in Talend Studio.

1. In the Repository, expand the Metadata node.
2. Right-click Db Connections and click Create connection.

   

3. In the list of databases, select MySQL and click Finish.
4. 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.
5. Optional: Enter a Purpose and a Description.
6. Click Next.
7. Enter your database information.

   Example

   

8. Click Export as context to create context variables out of your database information.
   1. Select Create a new repository context and click Next.
   2. Enter a Name, Purpose and Description for your context group and click Next.
   3. Click Finish.

      Example

      

9. Click Test connection, click OK if the test is successful, then click Finish.
10. Expand the Metadata > Db Connections nodes, then right-click your connection and click Retrieve schema.
11. In the dialog box that appears, keep the default settings and click Next.
12. Select your movies table.

    

13. Click Next, then click Finish.