JDBC is a Java API to connect and interact with databases. You can use a JDBC connection to extract metadata from any source system for which a JDBC driver is available. Metadata Command Center certifies the following source systems from which you can extract metadata using the JDBC catalog source:
•Amazon DynamoDB
•Microsoft Azure Cosmos DB
•Marketo
•Microsoft Dynamics CRM
•MongoDB
•IBM Netezza
•Sybase ASE (Adaptive Server Enterprise)
•Sybase IQ (Intelligent Query)
•Workday
•Apache Cassandra
•SAP SuccessFactors
•NetSuite
•SingleStore
•IBM Db2 for z/OS
To extract metadata from these source systems, download the source-specific JDBC drivers and procure appropriate licenses. For information about using the JDBC drivers and licenses to extract metadata, see the HOW TO: Use the JDBC drivers to extract metadata in Metadata Command Center Knowledge article.
Note:
MongoDB and Amazon DynamoDB are NoSQL databases that do not contain views and view columns.
Objects extracted
Metadata Command Center extracts the following metadata from source systems that you connect to with the JDBC catalog source:
•Database
•Schema
•View
•Table
•Column
•View Column
Data Lineage
The following lineage data is available for JDBC assets:
•From table to view
For more information about data lineage, see the Asset Discovery help.