1 Reply Latest reply on Sep 14, 2018 10:14 AM by Zach Leber

    oracle connection fail on tableau server

    R w

      I am creating tableau workbook form oracle data source which is working fine on my desktop; tableau desktop. however when i publish the workbook on tableau server with the intended refresh rate it fails.

      error on server:

      published it again but it didn't work.

      on seeing the connection details and testing the connection this is the error:

      can anyone guide me what is the problem?

        • 1. Re: oracle connection fail on tableau server
          Zach Leber

          If you have access to the Tableau Server computer and can run Tableau Desktop on it that will help debug this.

           

          If your Server is inside your firewall, it may be missing the TNS file that contains the connection settings for Oracle. Or your Oracle database may be configured to only accept connections from certain IP addresses.

           

          If your Server is outside your firewall it will not be able to connect to your Oracle database, you'll have to publish a pass-through data source from Tableau Desktop to Tableau Server that is supported by using Tableau Bridge.

           

          I can help more once we figure out your setup.