I work on a Data warehouse(Oracle database 10g) that uses Oracle ODI 10g as an ETL tool. As part of digital transformation, we are migrating all applications and databases to cloud. This is will cause all the source & target tables in the ODI interfaces to change. The tables will remain same but their connection strings will be changed as the entire data warehouse will move to cloud.
I want to know how to update the connection details of all source and target tables in ODI without impacting existing ODI interfaces and packages in any way.
Is there a easy way to just update/change the connection details for all tables from topology manager of oracle ODI? I do not want to re-create all interfaces as it wont be a feasible approach.
Changing the connection details can be done on the JDBC tab of the Data Servers in the Topology manager.
Each datastore belongs to a Model. A Logical Schema is set for each model in the Model Definition. Logical Schemas are tied to Physical Schemas through Contexts. When executing a mapping we have to specify which context is used. That way at runtime the Logical Schema is translated to the Physical Schema.