0 / 0
Supported data sources for metadata import and metadata enrichment
Supported data sources for metadata import and metadata enrichment

Supported data sources for metadata import and metadata enrichment

The following table lists the data sources from which you can import metadata and against which you can run metadata enrichment.

For metadata enrichment, a corresponding connection asset must exist in the project. If the asset types imported from a specific connection don't allow for enrichment, not applicable (abbreviated to N/A) is shown in the Metadata enrichment column.

Supported connections
Connection type Metadata import Metadata enrichment
Amazon RDS for MySQL
Amazon RDS for Oracle
Amazon RDS for PostgreSQL
Amazon S3
Analytics Engine HDFS
Apache Cassandra
Apache HDFS
Apache Hive
Box
Cloudera Impala
Generic S3
Google BigQuery
Greenplum
Connection type Metadata import Metadata enrichment
IBM Cloud Compose for MySQL
IBM Cloud Data Engine
IBM Cloud Databases for MongoDB
IBM Cloud Databases for PostgreSQL
IBM Cloud Object Storage
IBM Data Virtualization Manager for z/OS 1
IBM Db2
IBM Db2 Big SQL
IBM Db2 for i
IBM Db2 for z/OS
IBM Db2 Hosted
IBM Db2 on Cloud
IBM Db2 Warehouse
IBM Informix
IBM Netezza Performance Server
IBM Watson Query
Connection type Metadata import Metadata enrichment
MariaDB
Microsoft Azure Data Lake Store
Microsoft Azure SQL Database
Microsoft SQL Server
MongoDB
MySQL
Oracle 2
PostgreSQL
Salesforce.com
SAP ASE
SAP IQ
Snowflake
Teradata

Notes:

1 With Data Virtualization Manager for z/OS, you add data and COBOL copybooks assets from mainframe systems to catalogs in IBM Cloud Pak for Data. Copybooks are files that describe the data structure of a COBOL program. Data Virtualization Manager for z/OS helps you create virtual tables and views from COBOL copybook maps. You can then use these virtual tables and views to import and catalog mainframe data from mainframes into IBM Cloud Pak for Data in the form of data assets and COBOL copybook assets.

The following types of COBOL copybook maps are not imported: ACI, Catalog, Natural

Restriction: You can't import COBOL copybooks larger than 1 MB.

When the import is finished, you can go to the catalog to review the imported assets, including the COBOL copybook maps, virtual tables, and views. You can use these assets in the same ways as other assets in Cloud Pak for Data.

For more information, see Adding COBOL copybook assets.

2 Table and column descriptions are imported only if the connection is configured with one of the following Metadata discovery options:

  • No synonyms
  • Remarks and synonyms

Learn more

Parent topic: Curation