Versions Compared

Old Version 7

changes.mady.by.user eric revollo

Saved on

compared with

New Version Current

changes.mady.by.user eric revollo

Saved on

Key

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

...

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.
  Image Removed Image Added 

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).

  • If the database or metadata repository is located on the same server as the RED instance, leave the (local) default option selected.
  • If the database or metadata repository is located on a different server select the relevant database type of SQL Server.

ODBC Data Source Name (DSN)

ODBC Data Source Name (DSN) as defined in the Windows 32-bit ODBC Data Source Administrator.

  • Select the relevant ODBC connection to the data warehouse database or metadata repository.
Note

The ODBC Source Name defined in RED must be the same on all machines that use the corresponding connection.


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.

Note

There must only be one data warehouse/metadata connection in a WhereScapeRED repository.


...