Connecting a Impala Database

CONTENTS

Home

Connect to Impala

Impala is only supported for bipp Enterprise Edition.

Here is what you need to connect:

  • Whitelist the bipp IP address
  • Database connection information
  • Credentials

Whitelist the bipp IP address

If your Impala instance is behind the firewall, you need to whitelist the bipp IP Address 34.121.142.220 to allow bipp to connect to your database. Use Direct Connection as the Connection type when you create the datasource.

Create a Impala Datasource in bipp

  1. Select Datasources from the Home Navigation pane to open the Datasources page.

    Datasource Page

  2. Click New Datasource on the Datasources page.

    New Datasource

  3. Enter a Name. For example, TestImpala.

  4. Select Impala for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.

    Datasource-New_Impala_1

  5. Enter the information for your Impala database instance:

    • Host: name or IP address of the database host.
    • Port: port on the host for the connection.
    • AuthMech: authentication mechanism to use for the connection:
      • Plain: enter your plain Username and Password.
      • LDAP: enter your LDAP Username and Password if your organization has set up LDAP directory authentication.
    • Connection: connection type
      • Direct Connection: database directly available over internet or your bipp platform is deployed on-premise in a private subnet. If your database is behind a firewall. Whitelist the bipp IP address 34.121.142.220.
        • UseTLS: enable Transport Layer Security for the connection. bipp recommends you select yes to use TLS.
        • SslCert: browse to the location of the PEM format file containing your X509 certificate. This certification identifies the Impala daemon to clients during TLS/SSL connections.
      • Direct Secure Connection: secured encrypted TCP connection if your database is behind a firewall. Whitelist the bipp IP address 34.123.9.91. TLS is not supported in this mode. The encrypted data is transmitted to prevent in-transit eavesdropping. Direct Secure Connection will be deprecated soon.
      • SSH Tunnel: encrypted connection using Datasource Impala SSH Port Forwarding. bipp supports both forward and reverse SSH tunnels. Here are the additional SSH fields:
        • SshTunnelHost: name or IP address of the SSH tunnel authentication host.
        • SshTunnelPort: port on the SSH tunnel authentication host for the connection.
        • SshTunnelUser: user name for SSH tunnel authentication.
        • Ssh TunnelAuth: select Key to use an SSH Private Key and optional SSH Passphrase, or select Password to use your SSH Password.
  6. Click Test to verify the datasource connectivity. If you have an error, fix the connection or credentials problem and click Test again.

  7. Click Create to add the datasource.

Congratulations! You have successfully created a Impala datasource in bipp.