Skip to Content
Author's profile photo Mohammad Shahanshah Ansari

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.

/wp-content/uploads/2014/03/1_410746.png

Step 2:

Cancel the above Job execution and Click on the Tool menu bar as shown below and select System Configurations.

/wp-content/uploads/2014/03/2_410786.png

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.

/wp-content/uploads/2014/03/3_410787.png

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.

/wp-content/uploads/2014/03/4_410788.png

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.

/wp-content/uploads/2014/03/5_410789.png

Do let me know if you find it useful. Feel free to revert in case you face any issue while configuring. Hope this helps.

Assigned Tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ravi Kashyap
      Ravi Kashyap

      Hi

      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 )

      Author's profile photo Former Member
      Former Member

      Hi,

      Very useful..

      Author's profile photo Mohammad Shahanshah Ansari
      Mohammad Shahanshah Ansari
      Blog Post Author

      thanks, Subbarao !

      Author's profile photo Former Member
      Former Member

      Hi,

      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.

      Thanks..

      Author's profile photo Former Member
      Former Member

      Hello Arun,

      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..

      Author's profile photo Former Member
      Former Member

      Hi Subbarao,

      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

      Author's profile photo Former Member
      Former Member

      DEv--->DEv Database

      QTY--->QTY Data bse

      now you have to check the data accordingly..

      Author's profile photo Former Member
      Former Member

      Thanks know i got it.

      Thank you.

      Author's profile photo sreenivas tadicherla
      sreenivas tadicherla

      Hi Ansari,

      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,

      Sreenivas

      sreenivas.t@live.in

      Author's profile photo Venkata Ramana Paidi
      Venkata Ramana Paidi

      Hi Sreenivas,

      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,

      Ramana.

      Author's profile photo bheem rao
      bheem rao

      Hello,

      Could any one please let me know how and why to create Datastore configuration ?

      Thanks in advance,

      Bheem

      Author's profile photo Venkata Ramana Paidi
      Venkata Ramana Paidi

      Hi Bheem,

      In the Data store advance option  you can create the datastore configurations.

      Thanks & Regards,

      Ramana.

      Author's profile photo Former Member
      Former Member

      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 ?

      Author's profile photo Mohammad Shahanshah Ansari
      Mohammad Shahanshah Ansari
      Blog Post Author

      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.

      Author's profile photo Samatha Mallarapu
      Samatha Mallarapu

      Is there any function to return system configuration and use it for validation.?

      Author's profile photo Debasree Inde
      Debasree Inde
      Author's profile photo anurag suram
      anurag suram

      Hi,

      I have a doubt can you please clarify?

      I've created data store config's. PFB screenshot.

      ds_config.PNG

      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.

      DS_system_config.PNG

      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??

      Please help..!!

      Author's profile photo Pravi Nellikkal
      Pravi Nellikkal

      PROD_CLOUD

      Author's profile photo anurag suram
      anurag suram

      Many Thanks Pravi Nellikkal 🙂