Tool Permissions Prerequisites

Download and Install Impala ODBC Driver

Download the ODBC driver for Impala from your vendor’s website: Impala ODBC Driver Download
Ensure that you choose the correct driver version ( 32-bit or 64-bit ) based on your environment and client tool.

Open the ODBC Data Source Administrator
- Search for "ODBC Data Source" in the Start menu.
- Select either 32-bit or 64-bit , depending on the installed driver.
Create a New System DSN
- Name: Provide a friendly name (e.g., Impala_ODBC ).
- Description: (Optional) Add details (e.g., “Impala ODBC connection”).
- Host: Enter the hostname (or IP address ) of the Impala service.
- Port: Default port is 21050 for Impala (confirm in your cluster setup).
- Database: Specify a default database to connect to (e.g., default ).
- Authentication Mechanism: Use User Name and Password authentication.
- SSL/TLS: If required, configure SSL settings for a secure connection.

Test the connection and ensure the setup is successful.
If the connection fails, verify the host, port, database, and authentication settings .

Access the Cloudera Octopai Target Folder (TGT)

Navigate to the TGT Folder on the server where the Octopai Client is installed.
- Default location: C:\Program Files (x86)\Octopai\Service\TGT
Locate the ZIP file with the Impala Connector Name .
- Example: Impala_Metadata_Export.zip
Verify its content:
- Check the quantity and quality of inner files.

⚠ Error during extraction? Try the following steps:

Check permissions on the Impala server and ODBC connection.
Verify the DSN configuration (correct hostname, port, authentication).
Ensure that the Impala service is running and accessible.
Send the log file with the connector name and number to Cloudera Support:
- C:\Program Files (x86)\Octopai\Service\log