To centralize DB table based metadata into a JDBC connection under the Metadata node of the Repository tree view, the procedure is made of two separate but closely related tasks:
Set up a JDBC connection,
Retrieve the table schemas.
The sections below describe how to complete the tasks in detail.
For an example of using a JDBC connection, see Data Integration Job Examples