Skip to Content

Dynamic Data Connection

Jan 10 at 11:39 AM


avatar image
Former Member


I have a Business View based on a Data Connection. During the migration from test into production I noticed that the tables are not found because the database user names are different. The tables in my Data Foundation are carrying the Qualified Table Names such as test.tablex that have no hits in the production system. Modifying the Qualified Table Names manually let it run.

Could a Dynamic Data Connection help in this case? OK, It requires same schema, but is user name included? If yes, would user name synonym in the DB help?

Thanks in advance!

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

0 Answers