1 Reply Latest reply on May 22, 2018 2:16 AM by Ciaran Bource

    Tableau connectivity with Hortonworks Hive hosted in AWS

    Tarun Goud Neelameediga

      Hi,

       

      I'm able to connect to the on premise Hortonworks Hive database but now I got a requirement to connect hortonworks Hive hosted in AWS.

       

           1. How to connect to cloud based databases? I mean is that the same way how we connect to on premise Hortonworks Hive database by installing drivers or is it different?

       

           2. If it is the same way just like on premise then I'm getting the following error.

        • Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.
        • [Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10060.
        • Unable to connect to the server "XYZ". Check that the server is running and that you have access privileges to the requested database.

      Note : I do have the access to database.

       

      Thanks,

      Tarun