You can use Metadata Command Center to extract metadata from a source system.
A source system is any system that contains data or metadata. For example, SAP Datasphere is a source system from which you can extract metadata through an SAP Datasphere catalog source with Metadata Command Center. A catalog source is an object that represents and contains metadata from the source system.
Before you extract metadata from a source system, you first create and register a catalog source that represents the source system. Then you configure capabilities for the catalog source. A capability is a task that Metadata Command Center can perform, such as metadata extraction, lineage discovery, data profiling, data classification, or glossary association.
When Metadata Command Center extracts metadata, Data Governance and Catalog displays the extracted metadata and its attributes as technical assets. You can then perform tasks such as analyzing the assets, viewing lineage, and creating links between those assets and their business context.
The following table describes the capabilities of the catalog source:
Capability
Description
Data Profiling and Quality
- 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.
Lineage Discovery
Builds the complete lineage of a catalog source by recommending endpoint catalog source objects to assign to reference catalog source connections. When you run the catalog source job, Metadata Command Center assigns the reference catalog source connections to CLAIRE recommended endpoint catalog source objects. You can then view the list of CLAIRE recommendations and accept or reject them.
Preview Notice: Effective in the November 2024 release, the SAP Datasphere catalog source is available for preview. Preview functionality is supported for evaluation purposes but is unwarranted and is not supported in production environments or any environment that you plan to push to production. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.
Extraction and view process
To extract metadata from a source system, configure the catalog source and run the extraction job in Metadata Command Center. Then view the results in Data Governance and Catalog.
The following image shows the process to extract metadata from SAP Datasphere:
After you verify prerequisites, perform the following tasks to extract metadata from SAP Datasphere:
1Register a catalog source. Create a catalog source object, select SAP Datasphere, and then select and test the connection.
2Configure the catalog source. Specify the runtime environment and configure parameters for metadata extraction. Optionally, add filters to include or exclude source system assets from metadata extraction. You can also configure other capabilities such as data profiling and quality, data classification, or glossary association.
3Optionally, associate stakeholders. Associate users with technical assets, giving the users permission to perform actions determined by their roles.
4Run or schedule the catalog source job.
5Optionally, if the catalog source job generates referenced asset objects, you can assign a connection to referenced source system assets.
You can view the lineage with object references without performing connection assignment. After connection assignment, you can view the objects.
After you run the catalog source job, you view the results in Data Governance and Catalog.
About the SAP Datasphere catalog source
You can use the SAP Datasphere catalog source to extract metadata from an SAP Datasphere source system.
SAP Datasphere is a public cloud software as a service data warehouse that includes services for data modeling, data integration, cataloging, and data warehousing across SAP and non-SAP data.
Extracted metadata
You can use the SAP Datasphere catalog source to extract metadata from an SAP Datasphere source system.
Metadata Command Center extracts the following metadata from an SAP Datasphere source system:
•Space
•Table
•Table Column
•View
•View Column
•Analytic Model
•Analytic Model Column
Data profiling for SAP Datasphere objects
Configure data profiling to run profiles on the metadata extracted from an SAP Datasphere source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following objects:
