Step 1:
From the “Repository” panel right click on the “DB
Connections”. Select “Create connection”
from the pop-up men
In the pop-up window (“Database Connection”) that appears
next set a name for your connection and click on the “next >” button. The screen shown in step 2: should appear.
Follow the sub-steps ‘I’-‘IV’ which reference the screenshot below.
I.) Select
from the “DB Type” drop down the source database type. In the case of this example “MySQL” is
selected.
II.) Fill
in the connection criteria i.e. “Login”, “Password” and “Database”
III.) Once
the connection criteria has been entered click on the “Check” button to make
sure that Talend can connect to the database.
If the check fails then re-visit the connection criteria entered.
IV.) Once
the connection has been verified click on the “Finish” button.
Step 3:
Find your newly added Metadata connection object under
“Metadata” from the Repository Panel and right
click on your connection object (below in the screenshot “MySQL_test_connection”
is selected ) and click on “Retrieve Schema” .
Step 4:
From the pop-up that appears after clicking on “retrieve
schema” click on the “Next >” button, which will bring you to the screen shown
below. Under your connection database
select the tables that you will need to access. Below I have select "city", "country" and "countrylanguage" from the "world" table.
Once your selections are made click on “Next >”.
Step 5:
In the next window you will need to select each table from the right hand and click on the “Retrieve Scheme”
button for each.
Once this is done click on “Finish”
Step 6:
Find your newly added Metadata connection object under
“Metadata” from the Repository Panel and right click on your connection object and select “Edit Connection” from the right-click menu.
On the first “Database Connection” window that appears click
on “Next >”. In the window that appears next click on the “Export as context”
button as shown below
In the pop-up window that appears (“Create/Edit a context
Group” as shown below) click on the “Finish” button which will create an initial connections
context group. The screenshot below shows Step 2 of 2 which is shown after the "Next >" button is clicked.
After you click on the “Finish” button you will be returned
to the “Database Connection” window.
Click the “Finish” button from the “Database Connection”
window. You will be prompted to update all current jobs to use the context metadata. Selecting "Yes" will update all jobs that use the metadata to use the context based connection.
After this step a context group should have been created
under the “Contexts” menu in the “Repository” Panel with the same name as your
Metadata connection.
