To configure data source names on Windows systems, you must start ODBC Administrator and then map an ODBC driver to one or more relational databases or flat file data sources that you will use for creating and storing OLAP models and metaoutlines. Run the ODBC Administrator utility from the Windows Control Panel.
Integration Services does not support data source table names and column names that contain spaces or special characters, such as a period (.). See Integration Services Limits and Guidelines for a complete list of the unsupported characters. |
The procedures in the following sections show you how to configure data source names to create connections to databases. The examples in the procedures use a database named TBC as the sample Data Source database and a database named TBC_MD as the sample OLAP Metadata Catalog database.
For each site-specific data source name that you configure, obtain the following information from your database administrator:
The name of the relational database or flat file data source for which you want to configure a data source name
For example, in the sample application, TBC is the name of the Data Source database; TBC_MD is the name of the OLAP Metadata Catalog database.
IP address or name of the computer on which the database tables are stored
You can enter either an alphabetic computer name (for example, sequoia), or an IP address (for example, 172.0.0.125).
In the sample application, if you are configuring a data source name for the TBC database, use the IP address of the computer where the TBC database tables are stored. If you are configuring a data source name for the TBC_MD database (the sample OLAP Metadata Catalog database), use the IP address of the computer where the TBC_MD tables are stored.
Port number on which your database listens
For clarity in presenting the sample application in Integration Services Console, the sample Data Source database and sample OLAP Metadata Catalog database are two separate databases that use two different data source names.
If your data is stored in a relational 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 your Data Source database and OLAP Metadata Catalog database if all the tables reside in the same database.
If your data is stored in one or more flat files, you must still use a relational database when setting up your OLAP Metadata Catalog database.
If you plan to use flat files as data sources, you must configure their Data Source Name (DSN). See Configuring the DataDirect Text Driver on Windows for detailed instructions. |