Configuring Data Sources

In This Section:

About Data Source Configuration

Configuring Data Source Names on Windows Systems

Configuring Data Source Names on UNIX Systems

After Configuration of Data Source Names

Connecting to Server Components and Data Sources

Mapping JDBC Data Sources for Windows (Teradata Only)

Mapping JDBC Data Sources for UNIX (Teradata Users Only)

Manually Configuring the Environment for UNIX Systems

To create OLAP models or build metaoutlines, you must connect Integration Services to a database that contains metadata (the OLAP Metadata Catalog database) and to a database in which needed users’ data is stored (the Data Source database). To make these connections, you must configure a data source name for an OLAP Metadata Catalog database and a Data Source database. You do this by mapping a supported Open Database Connectivity (ODBC) driver to each database.

Note:

You are not required to use two different databases for your Data Source database and OLAP Metadata Catalog database. Additionally, you are not required to use two different data source names to connect to the Data Source database and OLAP Metadata Catalog database if the two databases reside in the same database.