Skip to Content
0

how to implement separate staging database for devepment and production in BODS Designer?

Oct 26, 2016 at 12:54 PM

110

avatar image

currently in BODS we share common staging database(oracle) for both quality and production and because of this we are not able to schedule the jobs both in production and quality together as same tables are used in staging.

To solve this issue we have created two users(one for quality and another for production) in oracle DB as each users will have separate space and we did the configuration to decide its quality or production.

but when we create tables in quality it will create with user name (ex: table name("data store name'.username). but when we run same job for production it will not work as user is different). how to fix this?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Aasavari Bhave
Oct 26, 2016 at 02:40 PM
1

You can create multiple configuration in a datastore - 1 for QA and another for prod. You can choose the configuration you want to use when running the job so use qa config when running the job in QA , similarly prod configuration when running job in prod.

Read Refeence Guide -

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_reference_en.pdf

Section 2.3 > 2.3.7.1.4 - Configurations for Datastore options

Share
10 |10000 characters needed characters left characters exceeded