Migrating ETL code with export/import

Data Services Designer has various options to import/export ETL code.

In this recipe, we will review all possible import/export scenarios and take a closer look at the file formats used for import/export in Data Services: ATL files (the main export file format for the Data Services code) and XML structures.

Getting ready

To complete this recipe, you will need another local repository created in your environment. Refer to the first two chapters of the book to create another repository named DS4_LOCAL_EXT in the new database, DS_LOCAL_REPO. Do not forget to assign the proper security settings for Data Services Administrator users in CMC after registering the new repository.

How to do it…

Data Services has two main ...

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.