Page History
...
Options | Description |
---|---|
Database Host/Server | Used by scripts to pass to native tools. |
Database Port | Used by script to pass to native tools. |
Database ID | Database Identifier or Database Name. |
Database Link Name | Optional name of a Database Link that is used to access the database. Only required for Database type connections where the database is not on the same server as the data warehouse. If the server is on the same database, the link doesn't need to be defined and the field can be left blank. For connections to databases located in different servers where a database link load is required:
Enter the defined SQL LINK name that points to the correct server, the link name does not need to be the same as the server name. |
Provider Name | Name of the connection provider/driver used to connect to the database. |
Full Database Path Name | This field is used when you enter Microsoft.Jet.OLEDB.4.0 as the Provider Name, e.g. when the source database is from MS Access or Excel. Enter the full database path name. |
ODBC
Options | Description |
---|---|
Database Host/Server | The host or server that is used by scripts to pass to native tools. |
Database Port | The port that is used by scripts to pass to native tools. |
Database ID | The database ID. |
Work Directory | Used by RED to create temporary files for Native-ODBC extracts. The directory must exist and allow write access. |
Advanced Connect Parameters
...
Options | Description | ||
---|---|---|---|
Default Schema for Browsing | Optional comma-delimited list of schemas for the browser pane filter. Enter the schema(s) you want the connection to browse by default on the right 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 Connection | The default Script Connection to used when a Script-based load type is defined for a Load table object that is sourced from this connection. | ||
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. | ||
SSIS Connection String (OLEDB) | The connection string that is used by Microsoft SQL Server Integration Services (SSIS) to connect to the data source using the OLE DB connection manager. | ||
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. | ||
Default Transform Function Set | Function Set that is selected by default in the Transformation dialogs. | ||
When Connection is an OLAP Data Source | This section of fields is only relevant and will only be visible from a Data warehouse connection (where the Data warehouse field is enabled). These fields are required so that the data warehouse can be used as a source for the Analysis Services cubes. | ||
Connection Provider/Driver | Name of the Connection Provider/Driver to use to connect to the data warehouse database, when it is used as the data source for OLAP cubes. | ||
Data Warehouse Server | Data Warehouse Server Name. | ||
Data Warehouse Database ID | Data Warehouse Database Identifier or Database Name, which is used when the data warehouse is used as the data source for OLAP cubes. |
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. |
...