SAP DATA SERVICES (PRODUCT TUTORIALS)

What is the Data Services product?

In this 10-minute video you will build a Data Warehouse with one Fact table and a Slow Changing Dimension to get an idea how Data Services is used. Video

What is so special about Data Services?

Data Services is an ETL product like any other. But there are different product philosophies: one tends to do everything inside its own engine - the traditional ETL tools; the other pushes down the entire processing to the database with its powerful engine - so called ELT tools. Both methods have their pros and cons, and hence Data Services does both. That’s harder for us to develop, but easier for you to use. Video

ETL is more than just moving data

Data Quality

Copying data can be done with hand-coded scripts as well. So what is the advantage of using an ETL tool like Data Services?Video

Docs and Reports

Are you using scripts or a tool that is close to programming for your ETL task? Have you documented what these scripts are doing? In Data Services an entire feature set is around Self-Documentation, Operational Dashboards, and more. Actually, if you would use Data Services to document your code it would not take you any longer than creating comments, but you get all the advantages for free - and very likely better performance as well.Video

Performance of Data Services

Even the easiest to use ETL tool does not help much if the performance is not good. See what the performance of Data Services is and why all the published ETL benchmarks are meaningless.Video

Installation and Architecture

Planning for SAP Data Services and SAP Information Steward Installation (4.2) In this tutorial, you will prepare for installation of Data Services and Information Steward 4.2.Video

Install and Configure Data Services (4.2)

In this tutorial, you will install and perform initial configuration for Data Services 4.2.

interactive / video

Installation and Architecture of Data Services In this 15-minute video we install the Data Services product, look at its components, add the Data Cleansing option, and add the Global Address Dictionary.Video

Installing SAP BusinessObjects Data Services 4.0. A ten-minute video of the DS 4.0 installation together with the Information Platform Services (IPS, MiniBOE).Video

Data Services in the SAP ERP/BW environment

Getting Data in and Out of SAP Using Data Services A 15-minute video showing what technical interfaces Data Services offers today for reading and loading SAP ERP and SAP BW.Video

Using SAP ERP Extractors with Data Services A six-minute video on how to use SAP ERP Extractors with Data Services 4.0.If you don't know what ERP Extractors are or what kind of types exist, you might want to watch this short explanation.Video

What if there is No Matching Extractor? This 23-minute video shows using ABAP dataflows to read the SAP tables directly, including delta. Video

Information Governance: Common Questions

A 20-minute recording outlining some of the most common questions users ask when starting an information governance initiative. Video

Data Services How-to 

Data Services Workbench

Create Data Flow (4.2)

In this tutorial, you will use the Data Editor of Data Services Workbench to create a data flow for basic data integration.

interactive / video

Create Delimited Text File Format (4.2)

In this tutorial, you will create delimited text file formats and use them in a data replication job.

interactive / video

Use Replication Wizard (4.1)

A 10-minute simulation using the replication wizard in the Data Services 4.1 Workbench to replicate a data warehouse from one database to another.

Simulation

Edit Replication Job (4.1)

A 10-minute simulation editing a generated replication job by adding a filter, changing some mappings, looking at some more advanced capabilities, and then viewing the result in Data Services Designer.

Simulation

Promote Data Services Objects (4.2)

In this tutorial, you will configure the object export and object import environment and promote objects from a central repository to a local repository.

interactive / video

Additional Tutorials

Data Quality Management, version for SAP

SAP Data Quality Management, version for SAP solutions (DQM for SAP), enables you to embed support for data quality directly into SAP ERP, CRM and MDG applications.

UNDERSTANDING DQM FOR SAP

• Perform Postal Validation (1)
• Perform Postal Validation (2)
• Override Postal Validation
• Perform Duplicate Check
• Perform Duplicate Check - Skip Secondary Address
• Run the Quarterly Adjustments
• Run the Quarterly Adjustments (SP04) 
• Perform Batch Duplicate Detection
• Perform Batch Duplicate Detection (SP03, SP04) 
• Use Localized Address Validation and Duplicate Check Screens

INSTALLING DQM FOR SAP

• Install the Data Services Components
• Alter the Substitution Variables
• Create the Batch Staging Tables (pre SP02 only) 
• Configure Jobs as Services
• Install the RFC Server
• Add Additional RFC Servers as Services
• Add a New SAP Server to the RFC Server
• Activate the Region/Country Fields
• Perform the SAP Handshake
• Load the Supported Countries (pre SP02 only)
• Activate the Duplicate Check Index
• Activate BC Sets Through IMG Options (SP03, SP04) 

CONFIGURING DQM FOR SAP

• Maintain Fields for Address Review
• Maintain Fields for Duplicate List
• Create the Mapping for Quarterly Error Report
• Maintain Operating Parameters
• Configure Regions
• Change a Customer Address Reviewer Label
• Change a Suggestion List Label
• Maintain Suggestion List Fields (SP03, SP04) 

MDG-SPECIFIC

• Assign Services for MDG Generic Duplicate Check
• Configure MDG Generic Duplicate Check to Use DQM for SAP Search
• Set Up BAS-Based Duplicate Check for MDG (SP03, SP04) 

CONFIGURING THE BREAK KEY

• Modify the Break Key

EXTERNAL LIST MANAGEMENT

• Create a Marketing Attribute
• Map External List
• Import External List

TROUBLESHOOTING DQM FOR SAP

• Use Sample Input Files

Global Address Cleanse Transform

The Global Address Cleanse transform takes as input any address information and matches that, using different engines, against its Address Dictionary. The transform uses its internal knowledge how address lines are written to parse it into its segments and also corrects typing errors.

BASIC GAC FUNCTIONALITY

• Mapping Input fields
• Status codes
• Information Codes
• Assignment Levels
• Building and Firm Assignments

CERTIFICATION

• Canada Certification Options
• AU and NZ Certified Processing Options

REFERENCE DATA (ADDRESS DIRECTORY)

• Reference Data
• Intro to Reference Data
• What is Parsing
• Parsing Dictionary
• Assignment
• Country-Specific Assignment Directories
• All World Directory
• Why Purchase SAP Directories

SUGGESTION LISTS

• Infocodes to Suggestions
• NRDM Script
• Extra and Remainder

REGION-SPECIFIC FUNCTIONALITY

• Deleted records
• Netherland Compliant Street Name
• China and Japan Address Cleansing
• CJK-Specific Standardization Features
• Chinese Pinyin Fuzzy Search in GAC

Data Cleanse Transform

The Data Cleanse transform is used to perform parsing, standardizing, and enhancement of customer and operational data.

• DS 4.1 Run Data Cleanse Job - In this tutorial you will run an SAP Data Services job designed to cleanse person and firm data. 
• DS 4.1 Review Results of Data Cleanse Job - In this tutorial you will review results of running a Data Services job to cleanse person and date data. 
• DS 4.1 Modify Date Output Format - In this tutorial you will modify the date format of a Data Services job to cleanse person and firm data. 
• DS 4.1 Modify Output Language Date Format - In this tutorial you will modify the language output format of a Data Services job to cleanse person and firm data. 
• IS 4.1 Search Person Firm Cleansing Package - In this tutorial you will search the single global SAP supplied PERSON_FIRM Cleansing Package. 

Geocoder Transform

The Geocoder transform uses geographic coordinates expressed as latitude and longitude, addresses, and point-of-interest (POI) data to append data to your records. Using the transform, you can append address, latitude and longitude, census data, and other information. For census data, you can use census data from two census periods to compare data, when available. 

4.0 

• What is Geocoder?
• Different Levels of Geocoding
• Geocoder Point of Information Search
• Perform Address Geocoding Perform Geo Spatial Search
• Add Location Awareness
• Perform Point of Information Search

4.1 

• Find Latitude Longitude for an Address
• Search for POI

Text Data Processing

SAP Data Services Text Data Processing enables you to perform natural language processing and extraction processing on unstructured text.

• Introduction to Entity Extraction Transform
• Using Text Data Processing Blueprints
• Creating an Extraction Dictionary
• Text Data Processing and Data Quality Transforms
• Sentiment Analysis Creating Text Data Processing Rules in SAP BusinessObjects Data Services 4.0 
• Read an Unstructured File
• Configure Entity Extraction
• Filter Entity Extraction Output
• Create a Custom Dictionary
• Perform Dictionary Extraction
• Configure for Rule Extraction
• Combine Data Quality with Text Data Processing

Address Reference Data

Address Reference Data is address "lookup" information, collected from authoritative data sources across the globe. Three types of Reference Data is used during processing: a parsing dictionary, which contains common phrases found in an address block, country-specific directories, which contain detailed delivery point information, and the All World directory, which contains the data found on the last line data of an address block, such as locality, region, and postal code.

• Introduction to Reference Data
• What is address parsing?
• How is the parsing dictionary leveraged?
• What is address assignment?
• How are country-specific assignment directories leveraged?
• How and when is the All World directory leveraged?
• Why do I need SAP Reference Data?
• How to determine what address directories are being used

Source: SAP Data Services Product Tutorials

Source Complementary 1: Data Services Tutorial