...
To create a new Data Hub profile configuration, click the the New Configuration in the Build view and select Data Hub Profile from the Configurations browser.
The contents of the menus in the menu bar may change depending on which configuration type that has been opened in the currently active tab. The Data Hub profile uses the standard menu items and buttons that are visible for all configurations, and these are described in Configuration [hide]mz9[/hide]Build View.
Impala Tab
The impala tab contains connections settings for the Impala database.
...
| Setting | Description | |||||
|---|---|---|---|---|---|---|
| Host | Enter the hostname or the IP address of the Impala database. | |||||
| Port | Enter the port number that is configured for the connection into the Impala database. | |||||
| Enable TLS | Allows the user to enable the TLS functionality for the connection to the Impala database. | |||||
| Allow Self Signed Cert | Checkbox to enable the usage of Self Signed Certificates. If this checkbox is selected, both Trust Store File Path and Trust Store Password will be disabled. | |||||
| Trust Store File Path | Enter the location of the trust store file. This path is used to store certificates from other Certified Authorities. The setup is required to establish a successful connection at the client side.
| |||||
| Trust Store Password | Enter the passphrase of the trust store file. This password is used to access the certificates stored in the trust store.
| |||||
| Key Store File Path | Enter the location of the key store file. This path is used to store your credential. This is required when setting up the server side on the SSL.
| |||||
| Key Store Password | Enter the passphrase of the key store file. This password is used to access the credentials stored in the key store.
| |||||
| Database Name | Click the Refresh button next to Database Name to retrieve a list of available database and then select a database from the drop-down menu. The Tables Mapping tab will appear. | |||||
| Refresh | Click this to retrieve a list of available databases. | |||||
| Test Connection | Click to test the JDBC connection to the Impala database. |
...
| Setting | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Select a database table from the drop-down list. The name of the table columns and their data type will appear.
| ||||||||||
| UDR Type | Click the Browse button and then select a UDR type that will be routed to a Data Hub agent. For information about Ultra types that can be mapped to Impala types, see Compatible Types below. | ||||||||||
| Auto Map | Click this button to automatically map UDR fields and database columns with identical names. The automatic mapping is not case-sensitive. If a field cannot be mapped, the current value in the UDR Field column remains unchanged. | ||||||||||
| Column | The name of the columns in the selected table. | ||||||||||
| Type | Clicking the cell, This displays a list of valid Impala types based on the Column in the selected table. Each column must be mapped against a type. For information about Ultra types that can be mapped to Impala types, see Compatible Types below. | ||||||||||
| UDR Field | Select a UDR field from the drop-down list. This represents selectable fields available based on the selected UDR Type above. | ||||||||||
| Date Hint | Select the date format to be stored in the table. This is required for a partition column. A date in the Ultra format can be stored as INT, BIGINT and SMALLINT types. When the column is a partition, you must select the corresponding date format from this drop-down list:
The selected format determines the granularity of date pickers in the Web UI. When you change the Date Hint value of a partition column for an existing profile, make sure to review the settings of Data Hub task workflows that depend on the updated profile and table.
|
...