Information Steward job server leverages scheduling service of BI platform. This service is hosted within Information Steward job server which is deployed in BI platform. Information Steward Task Scheduling Service processes ad-hoc and scheduled ‘data profiling’ and ‘data validation’ tasks. Information Steward Task Scheduling Service More than one instances of Data Services job servers can be associated with Information Steward repository for load balancing and high availability. Note that Data Services job server has to be associated with Information Steward repository using Data Services Server Manager in order to make it available for execution of ‘data profiling’ and ‘data validation’ tasks. In addition, if ‘Failed Data Connection’ is defined for Information Steward rule tasks, data validation job populates failed data repository with all the records that failed the validation rules. These jobs populate Information Steward repository with profile results, rule results as well as sample data associated with these results. These tasks are expressed as ETL jobs in Data Services where source is same as ‘Data Profiling Source’ defined in Information Steward.
View Data from a table in Data Insight project ‘Workspace Home’ tab.Add ‘Table’ to the project workspace - View Data within ‘Browse Metadata’ dialog.
This functionality is leveraged within following user interactions: Any filtering or sorting criteria defined within Information Steward UI is applied on all of the records within source but only top 500 rows can be viewed within Information Steward. View Data Service fetches a limited set of records (typically 500) from the source system. Note that within Information Steward, as a part of data discovery scenario, data stewards and data analysts want to understand how data looks but do not necessarily want to see all of the records. View Data Service also leverages enterprise connectivity layer within SAP Data Services in order to display data within Information Steward. Within Data Insight, when you add a table to your project workspace, Information Steward uses Metadata Browsing service to display the metadata structures in ‘Browse Metadata’ dialog (as shown in the diagram below) and consequently import metadata into Information Steward repository. Metadata Browsing Service is built on top of robust enterprise connectivity layer within SAP Data Services. We will now take a look at each service within the context of this usage scenario. Within these scenarios, following backend servers and services are leveraged. This scenario is implemented using Data Insight module within Information Steward. He has more than 14 years of information technology experience in the following areas: ETL architecture, development, and tuning logical and physical data modeling and mentoring on data warehouse, data quality, information governance, and ETL concepts.This article will discuss SAP Information Steward backend servers and services that are leveraged in Data Profiling, Data Quality Assessment and Data Quality Monitoring scenarios.
He is an SAP Certified Application Associate on SAP BusinessObjects Data Integrator, and he is very active in the SAP community, speaking globally at numerous SAP and ASUG conferences and events.
Sap data steward full#
Sap data steward how to#
Overrun and overwhelmed by an influx of data? Monitor data in real-time with this E-Bite on SAP Information Steward! Discover how to assess, analyze, and cleanse your data with three modules: use Data Insight for building scorecards and rules, Metadata Management for metadata collection and organization, and Metapedia for defining business standards and terminology against data.
0 kommentar(er)
