Page History
...
| Anchor | ||||
|---|---|---|---|---|
|
Options | Description |
|---|---|
Windows Host Name | IP address or hostname that identifies the Windows machine. Leave blank to connect to the local machine. |
Work Directory | Windows directory used by WhereScape RED to create temporary files for minimal logged extracts. The directory must exist and allow write access. There must be a different work directory for each WhereScape RED Scheduler running on the same machine to avoid file conflicts. Typically C:\Temp or a sub-directory of C:\Temp is used. |
Database ID | The Source Database Identifier. |
Database Server/Home Directory | Optional to specify the Database Home Directory if it is different from the standard home directory. |
Credentials
Options | Description |
|---|---|
Windows User ID and Password | Leave this blank if you are connecting to your PC. Enter details if you are connecting remotely to another Windows system. |
Dss User ID and Password | Enter the relevant details for connecting to the Data Warehouse. |
Other
Options | Description | ||
|---|---|---|---|
Default Path for Browsing | Optional default Path for browser pane filter. When a path has been selected in this field, it becomes the initial point for browsing and it is also expanded on open in the right-hand browser pane. | ||
New Table Default Load Type | The default Load Type for new Load tables is created using this connection as a source. Select the desired default load type from the list, e.g. Database Link Load, Script-based load, Integration Services Load or Externally Loaded.
| ||
New Table Default Load Script Template | The default Script Template to use when a Script-based load type is defined for a Load table object that is sourced from this connection. | ||
Data Type Mapping Set | Mapping Set to use when converting from a source database data type to a destination database data type. Setting this field to (Default) makes RED automatically select the relevant mapping set, otherwise, you can choose one of the standard mapping sets from the drop-down list or create a new set. |
| Tip |
|---|
Once the connection has been set up, you can right-click the connection in the middle pane or double-click the connection name from the left pane to view or edit the connection's Properties. |
...