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