How to use a Datastore with several Databases

An SAP Data Services developer can face a challenge when the database of one of the Datastores is updated or if you occasionally want to run your jobs over another database with the same datastore configuration.

This tutorial is meant to help you with this topic. This configuration is not a replacement for job transport or architecture layering (Dev, Test, Prod), but support for development or test in several environments or support in case of a structure upgrade.

Prerequisites

• Same configuration among the databases
• Same tables/procedures/objects configuration among the databases to be used in the same datastore

Step by Step

If you want to use a different database underneath your job, you can do the following steps:

1. Add the new database information to your datastore
2. Change the system configuration

1. Add the new database information to your datastore

Start editing the datastore you are using with several Databases:

You can see in the screenshot that we already have two configurations for this Datastore. We will create a third one. Click the “Edit…” button.

You will always need to have a default configuration (only one is allowed).

2. Change the system configuration

After changing the datastore you will need to reconfigure the Systems to be used:

Go to the menu “Tools” –> “System Configurations”

Add the new configuration using the first icon of this window

Select the new database configuration you added in the Datastore you changed.

At the time to run you need to choose the new configuration defined in the datastore.

Write in the comments if you have any questions.