/ Browse / Courses / Data Services - Platform and Transforms / Accessing data

Explaining SAP Data Services

Introducing SAP Data Services solution7 min
Describing the object model10 min
Quiz

Accessing data

Connecting to databases or applications using Datastores10 min
Accessing files using Flat File Formats10 min
Quiz

Developing jobs and data flows

Creating Batch Jobs2 min
Creating Data Flows27 min
Documenting Jobs5 min
Quiz

Troubleshooting batch jobs

Validating Jobs5 min
Testing Jobs10 min
Debugging Data Flows7 min
Quiz

Using functions, scripts, and variables

Computing data using built-in functions5 min
Designing independent reusable objects with variables and parameters10 min
Initializing variables using scripts10 min
Reusing logic with a custom function2 min
Using jobs in different system configurations5 min
Quiz

Querying data with Platform transforms

Building new data sets with the Query transform2 min
Choosing between lookup function and join operation5 min
Using the SQL Transform3 min
Quiz

Splitting and combining data with Platform transforms

Splitting data with the Case transform2 min
Splitting data with the Validation Transform10 min
Combining data with the Merge transform3 min
Quiz

Handling errors and recovering from failure

Auditing dataflows10 min
Setting up error handling20 min
Using automatic recovery mode5 min
Quiz

Updating data

Bringing changes to the target table17 min
Using Source-Based Changed Data Capture (CDC)7 min
Using Target-Based Changed Data Capture (CDC)11 min
Quiz

Designing advanced ETL scenarios using SAP Data Services Integrator transforms

Describing SAP Data Services Integrator transforms8 min
Converting columns to rows using the Pivot transform3 min
Quiz

Optimizing Performance

Optimizing data flows using the Data Transfer transform8 min
Setting options to improve performance24 min
Quiz

Explaining SAP Data Services

Introducing SAP Data Services solution7 min
Describing the object model10 min
Quiz

Accessing data

Connecting to databases or applications using Datastores10 min
Accessing files using Flat File Formats10 min
Quiz

Developing jobs and data flows

Creating Batch Jobs2 min
Creating Data Flows27 min
Documenting Jobs5 min
Quiz

Troubleshooting batch jobs

Validating Jobs5 min
Testing Jobs10 min
Debugging Data Flows7 min
Quiz

Using functions, scripts, and variables

Computing data using built-in functions5 min
Designing independent reusable objects with variables and parameters10 min
Initializing variables using scripts10 min
Reusing logic with a custom function2 min
Using jobs in different system configurations5 min
Quiz

Querying data with Platform transforms

Building new data sets with the Query transform2 min
Choosing between lookup function and join operation5 min
Using the SQL Transform3 min
Quiz

Splitting and combining data with Platform transforms

Splitting data with the Case transform2 min
Splitting data with the Validation Transform10 min
Combining data with the Merge transform3 min
Quiz

Handling errors and recovering from failure

Auditing dataflows10 min
Setting up error handling20 min
Using automatic recovery mode5 min
Quiz

Updating data

Bringing changes to the target table17 min
Using Source-Based Changed Data Capture (CDC)7 min
Using Target-Based Changed Data Capture (CDC)11 min
Quiz

Designing advanced ETL scenarios using SAP Data Services Integrator transforms

Describing SAP Data Services Integrator transforms8 min
Converting columns to rows using the Pivot transform3 min
Quiz

Optimizing Performance

Optimizing data flows using the Data Transfer transform8 min
Setting options to improve performance24 min
Quiz

Knowledge quiz

It's time to put what you've learned to the test, get 2 right to pass this unit.

1.

which information is mandatory to create a flat file format used as a source object?

There are three correct answers.

The file name.

The file type.

The column names.

The column data types.

The file location.

2.

Which of the following statements are true?

There are three correct answers.

A datastore provides a connection or multiple connections to data sources.

Data Services uses the datastore to import metadata that describes the data in the data source.

Data Services uses the datastore to read data from the source.

Data Services cannot use the datastore to write data to a target.

Datastore options are the same across all Relational Database Management Systems.