Connect to lab using ETL Tool

Hi,

I am trying to connect Talend to the hadoop on the lab and perform ETL operations.

Can you please let me know if I can connect to Hadoop?

If so please share me the URL which can be used to connect.

Thanks,

[Asked by a user]

Hi,

We have not connected the Talend to lab but we have used Tableau and Excel with Hive Server.
You can connect to the hive server.
Please use the c.cloudxlab.com as host and 10000 as the port and use your CloudxLab credentials.

Hope it helps.

Hi Sandeep,

Not able to connect tableau, getting below error

An error occurred while communicating with Hortonworks Hadoop Hive.

Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.
[Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10061.
Unable to connect to the Hortonworks Hadoop Hive server “c.cloudxlab.com”. Check that the server is running and that you have access privileges to the requested database.