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