Creating a source data object
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.
How to do it…
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 database structures that can be used in your Data Services ETL code. In reality, datastore objects do not store the database objects themselves but rather the metadata for the objects belonging to the application system or database...