Skip to Content
avatar image
Former Member

Use SharedProperties property in QueryTemplate

For a customer we have three environments:

- Development

- QA

- Production

In the workbench we use a lot of QueryTemplates with SQL queries to the specific database (D,QA or P). The prefix of the tables in the databases are depending on the environment.

e.g.

- for Development the prefix of each table is SAPMIDDB,

- for Production the prefix is SAPMIPDB

If I export a Workbench project from Development to Production I have to change the prefix of the tables in all QueryTemplates manually.

My question: Is there a way to use some kind of parameter (maybe in the SharedProperties.mem) so I only have to change this parameter once?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 23, 2014 at 04:33 PM

    Implementing your db architecture this way will create a lot of development complexity and maintenance pain. If by prefix you mean schema ( schema.table_name ) then you may be able to assign this to the db connection user and not need to include it in your sql statements. If the prefix for the different environments is part of your actual table names ( prefix_table_name ) this is not a good practice and I strongly recomend addressing this.

    Regards,
    Christian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Christian.

      It indeed is the schema what I meant. I assigned the specific user to this schema and it works perfect!

      Regards,

      Jurgen