Editing Data Connections

The following steps demonstrate how to edit existing data connections. Here, we will change an Impala connection to a Hive connection.

  1. On the main navigation bar, click Data.

    Click DATA on main navigation bar

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the side bar, click (Edit) to the right of ImpalaConnection.

    The Edit Data Connection modal window appears.

    Edit Data Connection Modal Window for an Impala connection: initial
    Editing a Data Connection
  3. In the Edit Data Connection modal window, make the following changes:

    Edit Data Connection Modal Window: final
    Edited Data Connection Information
    1. Choose Connection type Arcadia.
    2. Under Connection name, specify the new name of the connection. Here, use NewArcadiaConnection.
    3. Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost when the data source is local.

    4. Under Port #, enter the port number. Here, we used 31050, the default port # for Arcadia Engine connections.
    5. Under Credentials, complete the following entries.

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

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

    6. Click the Advanced tab.

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

      • 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.

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

      Note: Kerberos authentication is only available on Linux platforms.

      • NoSasl

      • Plain

      • LDAP

      • Kerberos

    9. Specify Query Timeout. The default value is 60 seconds.

    10. Specify Session Timeout. The default value is 0, meaning that sessions do not time out.

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

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

    testing connection
    Testing a Connection

    If the connection is valid, the system returns a 'Connection Verified' message.

  5. Click Save.

    connection verified, connecting
    Saving a Verified Connection

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