Question Re: Using a global variable in Technology Q&A

Using a global variable

Joseph_BERTHE1 — Thu, 14 May 2009 07:54:39 GMT

Hi,

In my development environment I have two database schemas one call AAA and the second call BBB.

We have only one scenraio which use BBB. It means that all my SQL queries are set with : select * from BBB.mytable

The problem is in qualification and production environment the schema is AAA.

My question, How can i use a global variable which is set to BBB for developement and AAA otherwise ?

Thanks

Shabarish_Nair — Thu, 14 May 2009 08:02:48 GMT

Note that parameters in the Communication channel are editable when transported to QA or PRD.

So ideally it is a practice to edit the table name to accommodate QA and PRD requirement.

prateek — Thu, 14 May 2009 08:08:29 GMT

There is no such concept of global varibale in Integration Directory. Thats why I raised this

Regards,

Prateek

Joseph_BERTHE1 — Thu, 14 May 2009 09:54:27 GMT

Thanks Prateek,

If I understand there is no solution for the moemnt ?!

prateek — Thu, 14 May 2009 09:59:29 GMT

Unfortunately no. As in the thread, some configurations could be done using ID APIs. There doesn't seem to be any other way.

Regards,

Prateek

Joseph_BERTHE1 — Thu, 14 May 2009 12:18:55 GMT

Ok,

I think for the mapping I will use a file properties as it is explain in the following blog. Like this I willl centrelize the data.

/people/sap.user72/blog/2006/06/07/property-file-a-smart-use-in-xi-context

prateek — Thu, 14 May 2009 12:33:13 GMT

If I am not mistaken, the problem was with the ID related issue. Only for Design part, this seems proper.

Regards,

Prateek

Joseph_BERTHE1 — Wed, 12 Jan 2011 16:01:40 GMT

solved

Former Member — Wed, 12 Jan 2011 16:27:05 GMT

If you need to change the database schema in your mapping you can use value mapping and an udf to get the SID of your PI system.