 |
 | Create a Db connection metadata
|
In the Repository on the left of the Talend Open Studio main screen:Expand the Metadata node. Right-click on Db Connections. In the menu, click Create connection to open the Database Connection wizard.
Next
|
 |
In the Database Connection wizard: In the Name field, name the connection RemoteDBMS. Click Next to continue.
|
 |
In the Database Settings area: In the DB Type list, select the type of database you want to connect to. In the Login and Password fields, fill in the login and password used to connect to the database. In the Server field, fill in the name or IP address of the server on which the database is stored. In the Port field, fill in the listening port number of the database server. In the Database field, fill in the name of the database you want to connect to. Click Check to verify the database connection.
|
 |
Check Connection message box will indicate if the connection is working. Click OK.
|
 |
If the connection has succeeded, click Finish to close the wizard and create the new connection. If the connection has failed, change the database settings and click Check again.
|
 |
In the Repository view on the left: The new connection will appear under the Metadata > Db Connections node.
|
