You can use the JDBC catalog source to extract metadata from a source system.
Although the catalog source includes multiple capabilities, not all capabilities are available on all source systems that you can connect to.
The following table lists source systems that you can connect to along with the metadata management capabilities that you can configure on each of them:
Source System
Data Profiling and Data Quality Automation
Data Observability
Data Classification
Glossary Association
Amazon Aurora MySQL
Yes
Yes
Yes
Yes
Amazon DynamoDB
No
No
Yes
Yes
Apache Cassandra
No
No
Yes
Yes
IBM Db2
Yes
Yes
Yes
Yes
Marketo
No
No
Yes
Yes
Microsoft Azure Cosmos DB
No
No
Yes
Yes
Microsoft Dynamics CRM
No
No
Yes
Yes
MongoDB
No
No
Yes
Yes
NetSuite
No
No
Yes
Yes
SingleStore
No
No
Yes
Yes
Sybase ASE (Adaptive Server Enterprise)
No
No
Yes
Yes
Sybase IQ (Intelligent Query)
No
No
Yes
Yes
You can configure the following capabilities:
Data Profiling and Data Quality Automation
- Data Profiling. Assesses source metadata and analyzes the collected statistics to discover content and structure, such as value distribution, patterns, and data types.
- Data Quality. Measures the reliability of the data and enables data usage.
Data Observability
Identifies anomalies in the characteristics of the data that you profile.
Data Classification
Data classification is the process of identifying and organizing data into relevant categories based on the functional meaning of the data. Classifying data can help your organization manage risks, compliance, and data security.
Glossary Association
You can associate terms that are in the glossary with technical assets to provide user-friendly business names to technical assets. Glossary Association automatically associates glossary terms with technical assets or recommends glossary terms that you can manually associate with technical assets in Data Governance and Catalog.
Extracted metadata
You can extract specific metadata from source systems that you connect to with a JDBC catalog source.
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 profiling for Amazon Aurora MySQL objects
Configure data profiling to run profiles on objects that you extract from an Amazon Aurora MySQL source.
You can run profiles on the following object types:
•Char
•Date
•Decimal
•Double
•Float
•Integer
•Smallint
•Bigint
•Time
•Text
•Mediumtext
•Tinytext
•Longtext
•Varchar
•Character varying
Data profiling for IBM Db2 objects
Configure data profiling to run profiles on objects that you extract from an IBM Db2 source.
You can run profiles on the following object types:
•Bigint
•Char(L)
•Date
•Decimal(P,S)
•Float
•Graphic
•Integer
•Numeric(P,S)
•Smallint
•Time
•Timestamp
•Varchar
•Vargraphic
Compatible connectors
Before you configure a catalog source, you must connect to the JDBC source system.
Use the JDBC V2 connector to connect to the JDBC source system.
For information about configuring a connection, see Connections.