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.