Connection to Impala Database in Server
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello!
I am a newby to Alteryx. Has anyone ever created a connection to an Impala database in server? Or created the connection string in the Manage In-DB Connections and made it work?
So far I have only been able to create a connection on my local computer by using that node and passing the ODBC connection created in ODBC Data Sources like the picture attached.
But I'm pretty sure this will not work on the server because it is not the whole connection string.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RubenCastr ,
You are correct, this connection was created in your ODBC admin settings and to use it, you need to guarantee there is a connection configured on the server with the same DSN (connection name).
My suggestion is for you to create a DSN-less connection. If you are using the simba ODBC, please take a look at this document, at page 60
If you have an user and password, your connection string will look similar to this:
Driver=Simba Impala ODBC Driver;Host=[Server];
Port=[PortNumber];AuthMech=3;UID=[UserName];
PWD=[Password];
Best,
Fernando Vizcaino
