If you have integrated the  with Hive, you can integrate it with Alation to simplify finding datasets within Hive for import. The Alation integration supports the following methods:

  1. Read directly from Alation through an Alation Navigator integrated into the Import Data page. 
  2. Locate tables through Alation and then open them with the .

Alation is a data catalog service for Hive. For more information, see www.alation.com.

Limitations of Alation Integration

Pre-requisites

Enable Alation Navigation Integration

Steps:

NOTE: Although the integration to Alation appears as a connection in the application, the connection cannot be created through the GUI or through the CLI. Please complete the following steps.

  1. Login to the platform as an administrator.
  2. From the menu, select Settings menu > Admin Settings.
  3. Search for alation.
  4. Update the values for the following properties accordingly:

     

    PropertyDescription
    alation.sdkPath
    This value identifies the path on the Alation server to where their integration SDK is stored. Do not modify this value.
    alation.enabled
    Set this value true to enable the integration.
    alation.catalogHost
    Set this value to the URL of the web interface for the Alation deployment.
  5. Save your changes. 

Testing Alation browsing integration

  1. Restart services. See Start and Stop the Platform.
  2. When the platform has restarted, login. 
  3. Click Datasets. Then, click Import Data.
  4. In the Import Data page, the Alation connection should appear in the left nav bar. Select it. 
  5. Click Launch Alation Catalog.
  6. If prompted, enter your Alation credentials. 
  7. Navigate to select a Hive table. For more information, see https://alationhelp.zendesk.com/hc/en-us.
  8. Click Select.
  9. The table is added to the Import Data page. 
  10. Import as normal.

Try running a simple job. For more information, see Verify Operations.

If ad-hoc publishing to Hive has been enabled, you can export the generated results to Hive and then attempt to re-import through Alation.

NOTE: There may be a delay before the  appear in Alation. If necessary, you can manually refresh the catalog from inside Alation.

Enable Open With Integration

Optionally, you can enable Alation users to open Hive tables from Alation in the 

NOTE: To support this integration, end users must disable popup blockers in Google Chrome. For more information, please see the Google Chrome documentation.

NOTE: If Kerberos is enabled, you must be authenticated into the and Alation at the same time.

NOTE: HTTPS is not supported.

Steps:

  1. Acquire an Alation API token. 
    1. Visit the following URL:

      http://<alation_host>/admin/misc
    2. Click Get API token.
    3. Copy the generated API token to the clipboard.
  2. Paste the API token into the following cURL command and execute it.

    1. HTTP: 

      curl -X POST 'http://<alation_host>/integration/catalog_chooser/register_opener/' -H "Content-Type: application/json" -H "Token: <token_key>" -d '{"endpoint":"http://<platform_host>:<platform_port_num>/import/data?uri=${dataSource.jdbcUri}&table=${qualifiedName}","endpoint_type":"NAVIGATE","name":"Trifacta","accept_object_types":["table"],"accept_data_source_types":["hive", "hive2"]}'
    2. HTTPS: Change the protocol identifier for both URLs to https and remove the platform port number.

      curl -X POST 'https://<alation_host>/integration/catalog_chooser/register_opener/' -H "Content-Type: application/json" -H "Token: <token_key>" -d '{"endpoint":"https://<platform_host>/import/data?uri=${dataSource.jdbcUri}&table=${qualifiedName}","endpoint_type":"NAVIGATE","name":"Trifacta","accept_object_types":["table"],"accept_data_source_types":["hive", "hive2"]}'


      where:

      ParameterDescription
      <alation_host>Hostname of the Alation server
      <token_key>The token value that was generated in Alation
      <platform_host>

      Hostname of the

      <platform_port_num>

      Port number of the . Default is 3005.

  3. A successful execution of the above command logs the following JSON message: 

    {"id":1,"name":"Trifacta","endpoint":"http://<platform_host>:<platform_port_num>/import/data","accept_object_types":["table"],"accept_data_source_types":["hive",
    "hive2"]}

Testing open with integration

Steps:

  1. Login to Alation. 
  2. Search for or navigate to a database table. Click the Open With... button. From the drop-down, select .
  3. The table appears as an imported dataset in the Imported Dataset page. 
  4. You can import the dataset into a new or existing flow. 

For more information, see Import Data Page.