Use SharedProperties property in QueryTemplate

[jurgen_de_jong]

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?

[former_member185280 · Accepted solution]

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

[jurgen_de_jong · Accepted solution]

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