Skip to Content
0
Former Member
Jan 08, 2008 at 12:49 AM

Using Synonyms in DI

135 Views

Post Author: HintonBR

CA Forum: Data Integration

Does anyone know of a good workaround to be able to use Oracle synonyms as data sources? I know that if the synonym and the underlying object (table or view) have the same name I can rename the owner of the object (if say the object was in one schema and the synonym was defined in the schema I was connecting with) and that will fact the system into accepting the synonym. I imagine that only works because DI was able to get the metadata first from the real object. In fact you can't reimport objects that have been renamed to use the synonym because it can't find the metadata now. Not to mention this workaround doesn't work for any object where the synonym and the underlying object don't have the same name. Synonyms are important to us to provide an abstraction between our ETL and the upstream data sources so that we aren't dependent on object names, schemas, etc... so has a fairly serious impact to our architecture not to be able to use them. Anyone have any ideas? Thanks,Bryan