In a couple of previous recipes, you have already become familiar with data sources, importing tables, and using imported tables inside dataflows as source and target objects. In this recipe, we will create the rest of the datastore objects linking all our existing databases to a Data Services repository and will spend more time explaining this process.
In the Understanding the Designer tool recipe in Chapter 2, Configuring the Data Services Environment, we already created our first datastore object,
STAGE, for the "Hello World" example.
So, why do you need a datastore object and what is it exactly? Datastore objects are containers representing the connections to specific databases and storing imported ...