Configuring ODBC access to Impala data sources

To configure the federated server to access Impala data sources, you must provide the federated server with information about the data sources and objects that you want to access. 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 .

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 .

Procedure

  1. Register the ODBC wrapper.
  2. Register the server definitions for an ODBC data source.
  3. Create a user mapping for an ODBC data source.
  4. Test the connection to the ODBC data source server.
  5. Register nicknames for ODBC data source tables and views.