Connecting to Data (ComparePro)
The Connector dialog box is used throughout Workbench for Eclipse to connect to data. The fields on the dialog box vary depending on the task being performed. The procedure below outlines the general use of the dialog box and describes the fields that may be encountered.
To create a new data connector
- From the Connector Name list, select <new> to create a new connector.
Complete the fields by referring to the following field descriptions. Not all fields below will appear on the dialog box.
Field
Description
Connector Type
Select the type of data to which to connect. The list of available connector types can vary by Workbench for Eclipse application and can vary by context (such as Source or Target modes in Converter Pro).
Connector Name
Type a name for this Connector. Connector names must begin with a letter and contain only alphanumeric characters and underscores. If left blank, a name is automatically generated but can be modified. After the connection is created, this name will appear in the Connector Name list and also in the Project Tree view.
File Name
Type the complete path and file name or click Browse to navigate to the directory where the file resides.
Host or Server
Host name or IP address of the host machine where the DBMS resides.
Alias Name
The DB2 database alias defined in the DB2 Client Configuration Utility.
Database Name
The name of your database or instance.
SID/Instance Name/Service Name
Security Identifier for an Oracle database. This is a unique name serving as a security feature that is used to identify a group of users on the network. See the database administrator for the actual name. The SID/Instance Name/Service Name determines if you are part of the group and are allowed access.
Port Number
Address or port that the database server is listening on. Valid port numbers include 1 through 65,535.
User ID
User ID for the DBMS.
Password
Password for the DBMS.
JDBC Driver
Select the JDBC driver. All valid drivers in the genericjdbc folder appear in this list.
Refresh
Searches the genericjdbc folder, and updates the JDBC Driver list.
Connect String
Enter the JDBC connection string used to access this database instance. The drop-down list contains common templates that can be modified to match the data. Click the ellipsis in this field to open a larger text box to enter values.
Use Service Name
Select or clear this check box depending on whether you want to use the service name to connect to Oracle databases. Then enter the service name in the Service Name field.
Use Trusted Connection (or Use OS Authentication)
Select or clear depending on whether you want to use a trusted connection to authenticate the data connection against the requesting user's user ID> If the user ID is valid, the connection will be allowed. Then you select this check box and you are using a remove server, you need to include ;DOMAIN=<domain_name> at the end of the Database Name/Alias field.
Schema Name
Enter the name of the schema designated for the database.
Show all tables/views
In ComparePro and ConverterPro: Select to view all database tables and views in the database..
Show table filter
In ComparePro and ConverterPro: Select to filter out some of the tables or views and select only specific database tables or views for viewing. Opens the Selection List Filter dialog box where desired tables/views can be selected.
SQL Query
In ConverterPro: Click this radio button to specify that you want to create an SQL Query. When you click Next, the SQL Query Entry window will appear where you can create your SQL query. Workbench for Eclipse does not validate your SQL Query syntax. You must be sure that you enter a valid SQL query. Refer to the ConverterPro online help for information on SQL query entry.
PSB Name Filter
In ConverterPro: You can type a specific PSB name, such as INVSTOCK, or you can specify a filter for the list of PSB names, such as INV*.
Access Profile Dataset Name
In ConverterPro: Type the dataset name that was created on the mainframe by the Workbench for Eclipse Enterprise installation. This dataset contains allocation profiles that allow Workbench for Eclipse client users to connect to predefined IMS environments. This dataset, called the "LOAD LIBRARY FOR EPARMS" is created during the mainframe setup in the Install Manager. For more information, see Task 4, Create a LOADMBR for Direct IMS Access (Optional) in the "InstallingWorkbench for Eclipse Enterprise Edition" chapter of the Workbench for Eclipse Installation Guide.
Profile Member
In ConverterPro: Type the member name as defined by the Enterprise installer. This member gives ConverterPro clients access to IMS PSB and DBD entries in a user-controlled manner. This name is assigned by the mainframe installer as the "EPARM member" in the Install Manager. For more information, see Task 4, Create a LOADMBR for Direct IMS Access (Optional) in the "Installing Workbench for Eclipse Enterprise Edition" chapter of the Workbench for Eclipse Installation Guide.
Symbolic Substitutions
In ConverterPro: (Only available for IMS DLI.) Type the dataset name symbolic values as defined by the mainframe installation.
Target Action (Exist/Not Exist)
(ConverterPro Target connectors only). This list displays actions that will be executed if a target exists or does not exist while running a conversion. Target actions are based on the target connector type. Refer to the ConverterPro online help for a description of all of the Target actions. Not every target action is available for every connector type, and they are only available for data targets.
- Click Connect to validate the connection. A connection validation message appears stating that the connection was either successful or unsuccessful. If the information is invalid, an error message appears.
- If the connection was successful, click OK to continue.
- If the connection was successful, click Details to find out why the connection was unsuccessful, then click Close to close the message box.
Optionally, click Save As Template to save the connection as a template for later use.
- Click Next to continue with the task that invoked the Connector dialog box.
To create a new data connector template
- From the Connector Name list, select <new> to create a new connector.
- Complete the fields by referring to the field descriptions above. Not all fields below will appear on the dialog box.
- Click Connect to validate the connection. A connection validation message appears stating that the connection was either successful or unsuccessful. If the information is invalid, an error message appears.
- If the connection was successful, click OK to continue.
- If the connection was successful, click Details to find out why the connection was unsuccessful, then click Close to close the message box.
Click Save As Template to save the connection as a template for later use. In the Save Connection As Template dialog box that appears, type a name for the connection, optionally add a description, designate a repository from the repository list, and decide whether to save a user ID and password as part of the connector template.
- Click Next to continue with the task that invoked the Connector dialog box.
To connect to data using an existing connector template
From the Connector Name list, select <connector templates> to open a previously saved connector template. The Open Connection Template dialog box appears.
- Double-click a previously defined connector. The dialog box reappears and displays connection fields that are autopopulated based on the connector chosen.
- Click Connect to validate the connection. A connection validation message appears stating that the connection was either successful or unsuccessful. If the information is invalid, an error message appears.
- If the connection was successful, click OK to continue.
- If the connection was unsuccessful, click Details to find out why the connection was unsuccessful, then click Close to close the message box.
- Optionally, change the connector name or any other field.
- Click Next to continue with the task that invoked the Connector dialog box.