After you create a JDBC connection, save the connection. You can then publish the JDBC connection and click the Metadata tab to view the generated process objects for the connection.
When you publish a JDBC connection, a list of Objects appear in the Metadata tab. The Objects section displays the entities along with the column metadata for the schema you specified in the connection. You can also preview the data.
The following image shows the Metadata tab for a published JDBC connection:
When you publish a JDBC connection, the Metadata tab is refreshed by default. You can click Publish - Skip Metadata Refresh to skip the metadata refresh and reduce publishing time.
Best practices for metadata refresh
•When you create a JDBC connection for the first time, click Publish to download the metadata. Subsequently, you can click Publish - Skip Metadata Refresh if there are no metadata changes.
•If you want to change credentials in a JDBC connection but you know that the metadata has not changed, skip the metadata refresh while publishing the connection to apply just the credential changes.
•If you know that the metadata has changed, you must click Publish to retrieve the metadata changes.
