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.
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 ...