This connection is for the PC that you are working on, or to a host Windows PC. From Windows, you can only do flat file loads.
Sample SQL Server Windows Connection screen:
General
Options | Description |
|---|---|
Connection Name | Name used to label the connection within WhereScape RED. |
Connection Type | Indicates the connection source type or the connection method, such as Database, ODBC, Windows, or Unix. Select the Windows connection type. |
Windows Host
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. The available options in this drop-down list is configured from Home > Options > Available Load Types. |
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. |
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.
Test the connection
- Select Browse | Source Tables from the menu strip.
- In the right pane, you should be able to drill down to the area required.