Connector Dialog
Enter values into the dialog box to connect and fetch data from your data source.
Options
Field |
Description |
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:
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:
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. |