Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Tags:
Former Member
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.

Regards,
Christian

3 View this answer in context
Not what you were looking for? View more on this topic or Ask a question