Use SharedProperties property in QueryTemplate
For a customer we have three environments:
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.
- 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?
christian libich replied
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.