How to Create System Configuration in Data Services
Why do we need to have system configuration at first place? Well, the advantage of having system configuration is that you can use it for the lifetime in a project. In general all projects have multiple environments to load the data when project progresses over the period of time. Examples are DEV, Quality and Production Environments.
There are two ways to execute your Jobs in multiple environments:
- Edit the Datastore’s configuration manually for executing Jobs in different environment and default it to latest environment
- Create the system configuration one time and select the appropriate environment while executing of the Job from the ‘Execution Properties’ window. We are going to discuss this option in this blog.
Followings are the steps to create system configuration in Data Services.
Prerequisite to setup the System Configuration:
- You need to have at least two configurations ready in any of your datastores pointing to two different databases. For example, one for staged data and another for target data. This can be done easily by editing the datastore. Right click the datastore and select ‘Edit’.
Step 1: Execute any of the existing Job to check if your repository does not have any system configuration already created. Below dialog box shall appear once you execute any Job. Do not click on the OK Button to execute. This is just to check the execution properties.
If you look at the below dialog box, there is no system configuration to select.
Cancel the above Job execution and Click on the Tool menu bar as shown below and select System Configurations.
Step 3: You can see the below dialog box now. Click on the icon (red circle) as shown in the below dialog box to ‘Create New Configuration’. This dialog box will show all the data stores available in your repository.
Step 4: Once clicked on the above button it will show the below dialog box with default config details for all datastores. Now you can rename the system config name (by default it is System_Config_1, System_Config_1 etc. ).
Select an appropriate configuration Name against each data stores for your system config. I have taken the DEV and History DB as an example for configuration. Note that these configs should be available in your datastores.
See the below dialog box how it is selected. You can create more than one configuration (Say it one for DEV, another for History).
Once done, click the OK Button. Now your system configuration is ready to use.
Step 5: Now execute the any of the existing Job again. You can see System Configuration added to the ‘Execution Properties’ Window which was not available before. From the drop down list you can select appropriate environment to execute your Job.
Do let me know if you find it useful. Feel free to revert in case you face any issue while configuring. Hope this helps.
Its really a great post for the beginner to understand the importance of changing the configuration or environment at the run time of the job when we play with the data under different environment (Development , Quality and Production )
thanks, Subbarao !
I am new to sap bods. Can i know the uses of System configuration and what it do when we execute a job by selecting a System configuration i.e quality or production and what is the use..
please let me know.
It will change the data store connection accordingly...
ex. if you select quality it will point it to quality.. environment.. see the prerequisite section above..
Thanks for your response.
What is the difference between executing a job in development or quality. I created three environments dev,qa and prod. While executing i am selecting each one each time but i did'nt noticed any change in execution process.
Can you please elaborate the use. with example
QTY--->QTY Data bse
now you have to check the data accordingly..
Thanks know i got it.
I did the same approach for my ETL job and I selected the required profile while executing the jib but it is not working for me.
what ever the profile I select it is pointing to old one which I given at the time of development.
please help me
Thanks in advance,
We use the data store configurations in the system configurations . If you are using the same data store and different data store configurations ,you should use alias in the data store configurations to avoid the table owner problem.
Please tell me how you configured the system configs, data store configs. Do you use the different data stores for different system configs or single data store with multiple data store configs. If single data store what are owners of the data store config.
Thanks & Regards,
Could any one please let me know how and why to create Datastore configuration ?
Thanks in advance,
In the Data store advance option you can create the datastore configurations.
Thanks & Regards,
Quick Q:- If we have a different default profile setup in Data-store to that mentioned in the System Configuration against the same data-store which one takes precedence ?
Hi Siddharth Krishna,
If I understood your question correctly, higher precedence is always given to the profile which is set as default in your Datastore configuration file in case you have selected 'Default Configuration' in your system configuration. Datastore configuration can't have more than one default profiles at a time.
Is there any function to return system configuration and use it for validation.?
I have a doubt can you please clarify?
I've created data store config's. PFB screenshot.
Here default configuration is PROD_CLOUD. so my understanding is it is pulling the data from PROD_CLOUD.
Now have a look at system configurations.
My question is
If I run a job using Data store DS_SAP_BWSOURCE (highlighted), which configuration will it be using ?? PROD or PROD_CLOUD??
Many Thanks Pravi Nellikkal 🙂