Creating New Impala Connections

The following steps demonstrate how to create new Impala data connections.

Create New Data Connection Modal Window: Impala
Create a New Impala Data Connection
  1. On the main navigation bar, click Data.

    The Data view appears, open on the Datasets tab.

  2. In the side bar, click New Connection.

    The Create New Data Connection modal window appears.

  3. In the Create New Data Connection modal window, under Connection type, select Impala.
  4. Under Connection name, specify the name of the new connection. Here, we use ImpalaConnection.
  5. Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost when the data source is local.

  6. Under Port #, enter the port number. The default port # for Impala connections is 21050.
  7. Under Credentials, complete the following entries.

    • Under Username, enter the username for establishing the connection.

    • Under Password, enter the password for establishing the connection.

  8. Click the Advanced tab.

    advanced connection options
    Advanced Connection Options
  9. Choose Socket type.

    Note: Windows platforms support only normal sockets; therefore, socket options do not appear on the modal window.

    • Normal [default]

    • SSL

    • SSL with certificate

      If you select this option, you can Allow Common Name - Host Name Mismatch, which means that the issued SSL certificate name does not have to match the host name of the server. By default, the names must match.

      sdupport for common name/host mismatch
      Support for Common Name and Host Name Mismatch
  10. Choose Authentication mode.

    Note: Windows platforms support only NoSasl authentication; therefore, authentication options do not appear on the modal window.

    • NoSasl

    • Plain

    • LDAP

    • Kerberos

      Note: Kerberos authentication is only available on Linux platforms.

  11. Specify Timeout interval. The default value is 60 seconds.

  12. Check Impersonation if using this feature to control individual table-level access for a user or a user group.

  13. Click Parameters tab.

    Parameter tabs, specifying parameter name/value
    Specifying Connection Parameters
  14. Click the first row to add a Parameter name/value pair. Type in the parameters and their values.

  15. If you want to remove a parameter, click (trash can) icon to remove existing parameters.

  16. At the bottom of the modal, click Test.

    testing connection.
    Testing the New Connection
  17. If the connection is valid, the system returns a 'Connection Verified' message.

    connection verified.
    New Connection Verified
  18. Click Connect.

After this operation succeeds, the new connection name appears on the side navigation bar.