accessing source schema via synonyms
431626Nov 18 2004 — edited Nov 30 2004Hi,
We are using oracle 10g for source and target and OWB 10.1 for our ETLs.
The DBA is not ready to give password to connect(register) to the production source schema. so how can we register the source module in OWB?
We have thought of these 2 approaches -
1. create a schema with no tables but having synonyms to the source schema. register this schema in OWB and use accordingly
2. Hard code the schema name in the mapping(right click configuration, for each source table we can set the schema name). but if i change my source schema name then i will have to re-visit all the mappings and change here, or is it there any other method?
Pls let me know which is better approach or if there is any other way to handle this
Thanks
Sagar