Skip to Content
0

Automate the renaming of Table Owner of database table within Information Design Tool

Feb 07, 2017 at 06:59 AM

48

avatar image

Hello,

We are working on Business Objects(BO) 4.x environment with datasource as Teradata database.

Within Teradata there are two environments Development and Production where the schema name for the tables turns out to be different. For instance, if in Teradata the schema for Development is S_DEV and Production is S_PROD and further there is a table TAB_BILLING then the table name in Development becomes T_DEV.TAB_BILLING and Production becomes T_PROD.TAB_BILLING.

So in this case when we are promoting the universe from BO Development to BO Production, within the Information Design Tool - Data Foundation layer, we need to manually rename the Table Owner for the datasource tables in BO Production from S_DEV to S_PROD.

We are trying to search for automation of the above activity so that each time we promote the universe, whether the aforesaid manual activity can be eliminated. Kindly provide the required assistance.

Regards,

Amogh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers