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 or file loads using SSIS. Refer to Loading Data into RED Load Tables using SSIS for details about SSIS 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, Unix. Select the Windows connection type. |
Windows Host
Options | Description |
---|---|
Windows Host Name | IP address or host name 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. The database name of the Data Warehouse. The Oracle SID or TNS Name. |
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 own 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 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. Note The available options in this drop-down list is configured from Tools > 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. |
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.
To 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.