Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2016 at 02:40 PM

    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 -

    Section 2.3 > - Configurations for Datastore options

    Add comment
    10|10000 characters needed characters exceeded