Unable to Access Synonyms in external Oracle Database

Unable to Access Synonyms in external Oracle Database

  

I am connected to an external Oracle database. I have attempted to use Integration studio both with the wizard and creating manually a table that I should have access too but the Integration Studio seems to not be picking up the table. I believe this is because the table is a synonym. Has anyone noticed this issue or have any suggestions on how I can connect to a Synonym that I should have rights to?

Hi scott,

You can only see actual objects that are in the schema you connect to, e.g. tables and views. When there are no objects in the schema, that schema will not be shown in the list of "Available Databases" in Integration Studio. 

What you could do is create a view in your schema that selects the data via the available synonym.