Connector Dialog

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.

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.

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 manually selecting from a list.

To load tables and views via search and select:

1. Select the Tables and Views tab.

2. Click Load Tables to load a list of predefined tables or views.
   This list can be filtered by entering an appropriate string in the Search Tables search box.

3. Select a table.
   The columns in the table are displayed in the Available Column list.

4. If you wish to add a duplicate column, select this column from the Add a duplicate column drop-down list provided.

5. Select the columns to add to your data table.
   If the data returned is to be aggregated, check the Aggregate check box. The following aggregation methods are possible:

• Text Columns: Group By

• Date Columns: Count, Minimum, Maximum, Group By

• Numeric Columns: Sum, Count, Minimum, Maximum, Group By.

To load tables and views using an SQL Query, select the Query tab.

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 and/or EXEC statements to execute.

Note:

Currently, only Select and Exec statements are allowed. To minimize security risks and prevent SQL Injection attacks, the following are currently not allowed:

• Comment characters ( -- )

• Semi-colons ( ; )

 In cases 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.

Preview Data

Click to fetch data using the credentials and criteria you have specified. 10 records are displayed to allow you to verify that you are selecting the correct data.