Versions Compared

Key

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

This topic describes the details of the connection Properties as they apply to the Database type connections. 
When coming to the Data Warehouse from an OLTP source system, the connection defines the path to get to those source tables. A connection object must be defined for each source system.
The fields presented in the Connection Properties screen below, depend on the connection and database types selected.  See below for a description of all possible fields.
Image Modified
SQL Server: when running a SQL Server data warehouse it is possible to create database links (linked server) to other SQL Server instances and most of the other major databases, such as DB2, etc.

...