Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Connect to a synonym table in an Oracle database?

I am sure the answer is that this is not possible but here goes. The data I want to use is set up as a synonym table instead of a normal table by our Oracel DBAs so it is not listed in the Navigator ...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi MJMcbride, 

    It seems that this is not supported  currently, you could vote on Connect to Oracle Views and Synonyms. Or you could try to use ODBC connection to see whether it works or not.

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi MJMcbride, 

It seems that this is not supported  currently, you could vote on Connect to Oracle Views and Synonyms. Or you could try to use ODBC connection to see whether it works or not.

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you for confirming what I suspected Zoe Zhi. Also, thanks for the link to that vote, I just added mine to the total.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I followed your suggestion to try ODBC. Unfortunately it has the same problem, it only shows the tables, not the views or synonyms.