Use this subtask to enter source and target information for the selected interface instance ID. This subtask is required.
Use this group box to define the file (if the Type is FILE) or database (if the Type is DB) source settings for the selected interface instance ID.
This non-editable field defaults from the Interface Master table.
If the Source Definition Type is FILE, the FTP Site check box, Directory, and File Prefix fields will be enabled.
Select this check box to enable the source FTP site field (the unlabeled field to the right), where you can enter the appropriate FTP information in addition to the Directory and File Name. Selecting this check box enables the User and Password fields in the Source Definition group box.
Enter the Source file directory in this required field.
Enter the source prefix directory in this required field.
If the Source Definition Type is DB, the fields in the Database and Login group boxes will be enabled.
Select the Source database platform from this drop-down list. The system-defined values are
ORA (Oracle)
MSS (Microsoft SQL Server)
SQLB (Gupta SQL Base)
This is a required field.
Enter the source integration database connectivity information (that is, server and database name for MSS in the "server\\database" format; or the TNSNAME of your database for Oracle) in this required field.
Enter the user ID and password in this group box for connectivity to the Source integration database or FTP site. These fields will be enabled if the Source Definition Type is DB or if the Source Definition Type is FILE and you selected the Source Definition FTP Site check box.
Enter the user ID that the user must use to connect to the source integration database or FTP site. This field is required.
Enter the password that the user must use to connect to the Source Definition integration database or FTP site. This field is required.
For verification, re-enter the password you supplied in the Password field. This field is required.
Use this group box to define the file (if the Type is FILE) or database (if the Type is DB) target settings for the selected interface instance ID.
This non-editable field defaults from the interface master table.
If the Target Definition Type is FILE, the FTP Site check box, Directory, and File Prefix fields will be enabled. The interface will generate a target text file using the settings in these fields.
Select this check box to enable the target FTP site field (the unlabeled field to the right), where you can enter the appropriate FTP information in addition to the Directory and File Name. Selecting this check box enables the Target Definition Login User and Password fields.
Enter the target file directory in this required field.
Enter the target prefix directory in this required field.
If the Target Definition Type is DB, the fields in the Database and Login group boxes will be enabled.
Select the Target database platform from this drop-down list. Valid options are:
ORA (Oracle)
MSS (Microsoft SQL Server)
SQLB (Gupta SQL Base)
This is a required field.
Enter the target integration database connectivity information (that is, server and database name for MSS in the format server\\database; "TNSNAME" for Oracle) in this required field.
Enter the user ID and password in this group box for connectivity to the target integration database or FTP site. These fields will be enabled if the Target Definition Type is DB or if the Target Definition Type is FILE and you selected the target FTP Site check box.
Enter the user ID that the user must use to connect to the target integration database or FTP site. This field is required.
Enter the password that the user must use to connect to the target integration database or FTP site. This field is required.
For verification, re-enter the password you supplied in the Password field. This field is required.