For anything other than basic connections you need a tnsnames.ora file on your Tableau Server in a directory specified by the system environmental variable TNS_ADMIN, e.g. C:\oracle\product\11.2.0\client_1\network\admin. This directory is part of the Oracle client installation which you get from Oracle. The Oracle client is not the same as the Oracle driver for Tableau which gets installed by default for Tableau Server and gets installed separately for Tableau Desktop.
Your best way to troubleshoot is to remote into the Tableau Server computer and run Tableau Desktop from there.
thanks for your response,in my server there are many projects which running hence they may have TNS_ADMIN available.
i reached out to admin people they said use IP address FQDN ,but my DB admin team saying they dont allow me to access through Ip address .
do you think i am missing somethink ?
when i am login in desktop with ABC as server and passwrod and user name can able to connect.
if i change server name:Abc and host name :abc and port no:1111 its throwing me error not able to recognize.
TNS_ADMIN sets the path for the tnsnames.ora file which can contain all the Oracle databases. That's what we do.
You are able to connect to Oracle from your Tableau Desktop computer but how do you know your Tableau Server computer can connect to it? Most Oracle instances are inside firewalls and many Servers are outside.
Where is your Tableau Server located? Can you logon to the computer that is hosting it and run Tableau Desktop?
Thanks for your prompt response,
we have restricted environment where we dont even have site admin rights., was contacted admin and he confirmed that with oracle server ABC is already configured with in server and assigend an IP for that and he shared with IP with me,using this IP address also i am not able to connect in desktop on my machine.
but he mentioned that he tried connecting desktop in the server with this IP and service name he got user id/password invalid error and said which means he can able to connect but i am not sure untill we key in user id and pssword and check.
for testing purpose i tried connection check in tableau site editing data source connection but no luck ,idle i should able to connect if he says he can able to connect with in the server through desktop.
if aam not able to connect in my desktop using provided IP which enables in server thinking may be firewal issue.but i should connect in tableau site right because its directly hosted by tableau server.
any thoughts what we are missing
You're probably going to need to significantly change both your desktop and server Oracle configurations to match each other or you will not have a sustainable connect, publish, and refresh environment. It sounds like you need to find better local admin help.
If you could go to the desk of the server admin and connect to Oracle using Tableau Desktop you could immediately publish that Data Source to Tableau Server with embedded credentials. Then you could go back to your desk and use that published connection to build all your reports. But a published data source has to connect to a specific table so if you have lots of tables you want to join in different ways that won't work.
You can publish joined data but you can't join published data.