Page History
...
Apart from the Data Warehouse or Repository connection to SQL Server, there must be at least one other connection to the Target Data warehouse database, such as Greenplum, Netezza, or PDW.
General
Options | Description | ||
---|---|---|---|
Connection Name | Name used to label the connection within WhereScape RED. For target databases like Snowflake, Redshift, Greenplum, Netezza, or PDW, the Data Warehouse connection can be renamed to Repository. | ||
Connection Type | Indicates the connection source type or the connection method, such as Database, ODBC, Windows, or Unix. Select the Database connection type. | ||
Database Type | The default is (local).
| ||
ODBC Data Source Name (DSN) | ODBC Data Source Name (DSN) as defined in the Windows 32-bit ODBC Data Source Administrator.
| ||
WhereScape RED Metadata Connection Indicator | Distinguishes the special connection that identifies the WhereScape RED datawarehouse/metadata repository. This option must be enabled for Data Warehouse/Metadata Repository type connections.
|
...
Options | Description |
---|---|
Extract User ID | Database User that has access to SELECT from the source system tables to extract data. For SQL Server, this field can be left blank if using a trusted login, or the server login password. |
Extract User Password | The password of the data warehouse user. For SQL Server, this field can be left blank if using a trusted login, or the server login password. |
Administrator User ID | Database User ID to log in when using WhereScape SQL Admin via the 'Connect using SQL Admin (as SQL Admin User)' context menu item (optional). |
Administrator User Password | Optional Database User Password to log in when using WhereScape SQL Admin via the 'Connect using SQL Admin (as SQL Admin User)' context menu item. |
JDBC User ID | User ID to log in when using JDBC via WhereScape Big Data Adapter (optional). |
JDBC Password | Password to login when using JDBC via WhereScape Big Data Adapter (optional). |
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 |
---|---|
Session User ID | Session User ID used for Advanced Connect. |
Session Password | Session Password used for Advanced Connect. |
Connection String | Used when establishing a connection, accepts automatic replacements of RED Tokens. |
Other
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. | ||
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. |
...