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.

To report this post you need to login first.

19 Comments

You must be Logged on to comment or reply to a post.

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

    (0) 
  2. Arun kumar A

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

    (0) 
    1. SUBBARAO MUCHERLA

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

      (0) 
  3. Arun kumar A

    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

    (0) 
  4. 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

    (0) 
    1. Venkata Ramana

      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.

      (0) 
  5. Siddharth Krishna

    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 ?

    (0) 
    1. Mohammad Ansari 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.

      (0) 
  6. 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..!!

    (0) 

Leave a Reply