Connector Dialog for Hive

Host Name

The name of the machine or domain containing the data source. This host must be accessible from the box where Monarch Data Prep Studio is installed.

Port

Port Number required to access the data source. A list of default connector ports is available here.

User ID

A valid User ID required to log-on to the data source.

Password

A valid Password required to log-on to the data source. This password must match the User ID above.

Hive Server Type

Select the server type from this list. You can select Autodetect or select the server type manually.

Other Connection Options

Connection options required to connect to the data source.

If you need multiple string connection options, separate these by a semi-colon. However, you can only enter up to a maximum of 512  characters into this text box.

Available options and valid values are discussed here.

Database

The name of the database which you want to connect.

You need to click Fetch Databases to select and then make existing databases available on the database drop-down list.

Tables and Views Section

Allows you to load, and then select, the tables from your database by entering a SQL Statement.

If you already selected Tables and Views, this box is updated to show the corresponding  SELECT * FROM TABLE query.

If you want to define the query, enter the SELECT, EXEC, and/or WITH statements to execute.

Notes

• To minimize security risks and prevent SQL Injection attacks:

• Only Select, Exec, and/or With statements are allowed.

• The following are NOT allowed:

• • Comment characters ( -- )

  • Semi-colons ( ; )

•  In cases where you need to use a series of SQL statements with or without comments, we recommend you use stored procedures to contain these statements. The stored procedure can then be executed from the form.

• The Preview Data and OK buttons are only enabled if the connection is active and the query is correct. Check your connection or your query if one of the buttons is disabled.

Query

Allows you to load, and then select, the tables from your database by entering a SQL Statement.

If you already selected Tables and Views, this box is updated to show the corresponding  SELECT * FROM TABLE query.

If you want to define the query, enter the SELECT, EXEC, and/or WITH statements to execute.

Notes

• To minimize security risks and prevent SQL Injection attacks:

• Only Select, Exec, and/or With statements are allowed.

• The following are NOT allowed:

• • Comment characters ( -- )

  • Semi-colons ( ; )

•  In cases where you need to use a series of SQL statements with or without comments, we recommend you use stored procedures to contain these statements. The stored procedure can then be executed from the form.

• The Preview Data and OK buttons are only enabled if the connection is active and the query is correct. Check your connection or your query if one of the buttons is disabled.

Preview Data

Click to fetch data using the credentials and criteria you have specified. This allows you to confirm your connection, ensure you have connected to the correct table, check your query, and verify the information that will be loaded.

Notes:

• Only 10 records are displayed to allow you to verify that you are selecting the correct data. This limit prevents system slow down.

• The button is only enabled if the connection is active and the query is correct. Check your connection or your query if one of the buttons is disabled.