Hi Experts,

I have changed the connection in data foundation layer.However, the business layer is not pointing to the new connection.

Explanation:

Initially, the connection was pointing to the Dev system(NonSAP system) for the testing purpose, I have changed the connection to point the Production system.

The table names remain same however the libraries are different.

I have manually changed the Owner to production library in the Data foundation(Right click on table->change Qualifier/Owner). I have done the same for all 20 tables in DF and saved it.

However, the objects/fields in the business layer are still pointing the development system's library.

ie, field1=dev_library.table_name.field1

I manually edited the SQL to field1=prod_library.table_name.field1.

Which works fine and the object shows the production data.

It is very tedious to do this manually for all fields/objects in each of the 20 tables.

Could you please let me know how to automatically refresh the business layer so it points the new production connection by itself.