Home / Highlights / Tech Tip: How to use System Configurations
InfoSol Blog Tech Tip

Tech Tip: How to use System Configurations

Tip : How to use System Configurations

A system configuration defines a set of datastore configurations that can be used at job runtime. System configurations are used to execute the same logic against different datastore environments. Migration is faster between environments.


Right click an existing data store and click Edit.

Click Advanced.

Click Edit to open the Configurations for the datastore.

Click Create new configuration icon on the toolbar.

Enter a unique configuration name and Click OK.

Select the default configuration and rename it to SC_DEV. Click OK twice.

Go to Tools -> System Configurations

For the Datastore “DS_DEMO”, select the “SC_PROD” configuration from the dropdown box. If required, multiple systems configurations can be created. Each system configuration can use 1 or more datastores.

Rename the System Configuration to SC_PROD

Right click the Job and Execute. In the execution properties window, if the System Configuration is not selected, the job executes by using the default configuration (in this example – SC_DEV). Data is sourced from the QA database SQL Server 2008.

To source the data from the new Production database (in this example, SQL Server 2014), click the System Configuration dropdown box and select SC_PROD and click ok.

About Srini Badia

Check Also

Hermes InfoBurst Case Study Blog

A BI Delivery Success Story that Just Keeps Growing

I never get tired of hearing Business Intelligence success stories and I always tell myself ...

Leave a Reply

Your email address will not be published. Required fields are marked *