Versions Compared

Old Version 2

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 3

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

  • If the database link already exists in this source database, then enter that link name in this field.
  • If the link doesn't exist then enter a link name.

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.

...

Options

Description

JDBC Connection String (JDBC URL)

Connection string used by the WhereScape Big Data Adapter to access this database.

JDBC Driver Class Name

JDBC driver class to be used by the WhereScape Big Data Adapter. This field must be set if the JDBC URL is set.

  • Select the appropriate JDBC Driver class name from the drop-down list. If this is left empty, this is not specified in generated commands.

Omit Sqoop Driver Option

  • If set, the --driver option to Sqoop is omitted. This is required for certain connection types.
  • If you select the Omit Sqoop Driver Option check-box, the driver parameter is not used in Sqoop command line.

Sqoop Connection Manager Class

Custom Sqoop connection manager class. Corresponds to the --connection-manager command line argument. Leave blank if this is not required.

Include Database/Schema Name in Sqoop Table Option

  • If set, the --table option to Sqoop includes the database/schema name of the destination table when performing Apache Sqoop loads into this connection.
  • If this is not set, users must ensure that the database/schema is otherwise communicated to Sqoop, for example by using the $OBJECT_DATABASE$ token in the in the JDBC Connection String.

Include Sqoop Columns Option

  • If set, the --columns option to Sqoop is included when performing Apache Sqoop loads into this connection.
  • If this is not set, users must ensure that the order of columns in the loads matches the order in the metadata.

...

Options

Description

Extract User ID

Database User that has access to SELECT from the source system tables to extract data.

Image RemovedFor 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.

Image RemovedFor 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.

Note

The available options in this drop-down list are configured from Home > Options > Available Load Types.


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.

...