IBM Support

Configuring ODBC access to Impala data sources

Question & Answer


Question

How to configure the ODBC wrapper to access Impala data sources

Answer

The ODBC wrapper is optimized to access Impala data sources. The ODBC wrapper detects the ODBC driver and automatically configures the performance options.

Before you begin

The Impala ODBC driver must be configured on your federated server.

For prerequisites that apply to all ODBC data sources, see Configuring access to ODBC data sources.

Restrictions:

  • nnstat method 1 is not supported for Impala. There is no error when using method 1, but no data will be returned.
  • Transparent DDL is not supported for Impala.
  • IUD is not supported for Impala

Additional restrictions apply to all ODBC data sources. See Configuring access to ODBC data sources.

Procedure

1. Use one of the following methods to prepare the federated server and federated database depending on your operating system:


2. You might need to add ODBC library directory to the DB2LIBPATH environment variable so that the client libraries load properly. Run the db2set command to set the DB2LIBPATH environment variable and specify the installation directory of the ODBC library:

db2set DB2LIBPATH="odbc_library_directory"

Where odbc_library_directory is the directory of the ODBC library.

3. For Linux, and UNIX operating systems, the following items must be configured on your federated server:

  • Add the data source client library directory to DB2LIBPATH in db2dj.ini:
DB2LIBPATH=/<odbc_library_directory>
You need to restart the DB2® instance to make the changes effective.
  • Create a symbolic link for odbc.ini:
ln -s $ODBCINI $HOME/.odbc.ini

4. Register the ODBC wrapper.

5. Register the server definitions for an ODBC data source.

6. Create a user mapping for an ODBC data source.

7. Test the connection to the ODBC data source server.

8. Register nicknames for ODBC data source tables and views.

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"11.1","Edition":"Bundled with DB2 LUW","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21984910