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 to the production environment.
Data Services provides a very convenient way of storing multiple datastore configurations in the same datastore object, so you do not need to edit datastore object options each time you want to extract from either...