Data Validation Option Integration with Cloudera

Back Next

Step 3. Configure a Cloudera ODBC Driver for Impala Data Source on Windows

After you install the driver, configure the Data Source Name (DSN). You can use the Windows ODBC Data Source Administrator to create the ODBC data source. When you create the data source, the Windows ODBC Data Source Administrator stores the ODBC driver parameters in the Windows registry.

Select the correct version of

ODBC Data Source Administrator

On a Windows 32-bit system, open the

Control Panel

and click

Administrative Tools

. Then, double-click

Data Sources (ODBC)

On a Windows 64-bit system, enter the following command at the command prompt:

%windir%\SysWOW64\odbcad32.exe

The

ODBC Data Source Administrator

dialog box appears.

In the ODBC Data Source Administrator for the System DSN, click

Add

Select

Cloudera ODBC Driver for Impala

Click

Finish

The

Cloudera ODBC driver for Impala DSN Setup

window appears.

For the Data Source Name, enter a name.

For the Host, enter the IP address or host name of the Impala server.

For the Port, enter the listening port for the service.

To connect to the database, enter

default

for the database.

If you require authentication, configure the authentication settings based on the Cloudera documentation.

Click

Test

to verify that the connection is valid, and click

Rename Saved Search

Table of Contents

Data Validation Option Integration with Cloudera

Data Validation Option Integration with Cloudera

Step 3. Configure a Cloudera ODBC Driver for Impala Data Source on Windows

Step 3. Configure a Cloudera ODBC Driver for Impala Data Source on Windows