Business Example
You are a catalog administrator in a multinational retail organization. The data analysts in your department need to view the metadata from different database schemas and database tables in multiple sources to perform an advanced data analysis. You also need to make sure that the data analysts understand and trust the data that they use. The organization might plan regular security audits to find sensitive data in the data sources and mask or protect them as required.
The retail organization that you work for has the following configured systems:
- •Human resources management system set up on an Oracle database.
- •Order management system set up on the same Oracle database.
- •Data warehouse hosted on a Hadoop repository. The data warehouse has integrated information from multiple data sources.
- •PowerCenter to perform data integration tasks across databases and schemas.
- •Reporting system set up on an SAP Business Object source.
The administrator in the organization can perform the following tasks in Catalog Administrator to effectively meet the data governance needs in this example:
- •Use Catalog Administrator to create an Oracle resource for the human resource management system and another Oracle resource for the order management system. You can configure the source metadata settings to extract the metadata into the catalog. You might not need to configure the profiling metadata settings for these resources. The resources provide the required database table and source column objects into catalog for analysis.
- •Create a Hive resource for the Hadoop warehouse. The Hive resource fetches tables and columns to the catalog. In addition to the source metadata extraction, you can configure the profiling metadata settings so that you have information related to data quality for further analysis.
- •Create a PowerCenter resource that maps to the data integration requirements. The resource configuration provides the links between the Oracle data objects and Hive objects.
- •Create an SAP Business Objects resource and configure the resource to extract reporting metadata. The resource provides reporting metadata based on the links between the Business Objects and the Oracle and Hive objects.
- •Set up a recurring schedule for each resource so that the scanners extract source and profiling metadata from the source systems at regular intervals.
- •Periodically monitor the tasks and jobs in Catalog Administrator that extract metadata. Monitor the tasks and jobs to get a functional view of Enterprise Data Catalog. Monitoring also helps you to analyze and estimate the type of content the scanners fetch into the catalog.