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
You can use a JDBC connection to connect to any database to extract the following metadata objects:
•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 Data Lineage in the Working With Assets help.