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.123.9.91 to allow bipp to connect to your database. Use Direct Secure 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.
        • 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.
      • 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.