Simplifying ETL execution with system configurations

Working in multiple source and target environments is very common. The development of ETL processes by accessing data directly from the production system happens very rarely. Most of the time, multiple copies of the source system database are created to provide the working environment for ETL developers.

Basically, the development environment is an exact copy of the production environment with the only difference being that the development environment holds an old snapshot of the data or test data in smaller volumes for quick test job execution.

So, what happens after you create a datastore object, import all required tables from database into it, and finish developing your ETL? You have to switch ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.