I need the best practices for code migration using export atl method in SAP BODS. In my current project we are using SVN repository to store the atl files for migration. I would like to know the process to synchronize the code between Dev/ST/SIT/UAT and Production repositories. And how to deal with datastores when using atl method as the datastores will have different configurations for each environment? How can I get a previous version as well.
You can either use system configurations to manage the different datastore configurations across your different environments (though that would require you have the DEV, QA and PROD datastore configurations setup in DEV) or you can do a 1-time setup of the different datastore configurations in each environment and always EXCLUDE the datastore object itself from your ATL exports.
In terms of managing your exports, I would strongly recommend using the Object Promotion feature within the DSMC as it prevents having to have Designer-level access in Production and it will keep a track record of all your migrated objects.
The first method seems to be a risk as the datastores point to all the environments. The latter seems to be a good method configuring the datstores and then excluding the datastores while migration seems to be a good method.
Currently, I’m following this method.
I’m not familiar with object promotion feature from CMC. I feel like it’s a bit hard to get used to the process. I would like to try this feature once I understood the process completely.