If you often need to connect to database tables of any kind, then you may want to centralize the connection information details in the Metadata folder in the Repository tree view.
This setup procedure is made of two separate but closely related major tasks:
Set up a database connection,
Retrieve the table schemas.
The sections below describe how to complete the tasks in detail.
Prerequisites: Talend Studio requires specific third-party Java libraries or database drivers (.jar files) to be installed in order to connect to sources or targets. Due to license restrictions, Talend may not be able to ship certain required libraries or drivers; in that situation, the connection wizard to be presented in the following sections displays related information to help you identify and install the libraries or drivers in question. For more information, see Talend Installation and Upgrade Guide.