In Integration Services, a data source name must be configured for the source database or flat files that contains users’ data (the Data Source database). A data source must also be configured for the relational database that contains the OLAP Metadata Catalog. Databases, including an OLAP Metadata Catalog, can run on any supported platform, provided that you have the ODBC driver and, in some cases, the database client software needed to access them.
The Integration Services installation program installs DataDirect ODBC driver files that you use to configure data source names for both the Data Source database and OLAP Metadata Catalog database.
If database client software is required, the relational database management system (RDBMS) should include one of the database clients listed in the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html)>. If your configuration requires database client software, ensure that the versions of the database client and the RDBMS are compatible.
This chapter provides information on how to configure ODBC drivers. For information on how to install and configure database client software, see the RDBMS documentation.
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 listing of the unsupported characters. |
On Windows, use the ODBC Administrator to configure ODBC data sources. All ODBC data source names are configured only on the computer that runs Essbase Integration Server.