In Windows environments, you use the ODBC Administrator to configure ODBC connections to data sources. ODBC Administrator is not available on UNIX systems, so you must perform manual configuration. Configuring ODBC on AIX, HP-UX, Solaris, and Linux requires that you complete these procedures:
Creating a Symbolic Link to .odbc.ini
For all databases that will be used as data sources in Essbase Studio, you create the symbolic link to .odbc.ini.
Adding Driver Descriptors to odbcinst.ini
If you are using MySQL Enterprise, Netezza, or Teradata as data sources on UNIX, you must install the ODBC driver and add an entry for the driver to odbcinst.ini. For the other supported data sources, the ODBC drivers are installed and configured in odbcinst.ini.
Adding DSNs to the odbc.ini File
For all databases that will be used as data sources in Essbase Studio, you must configure the ODBC connection in odbc.ini.
Note: | Oracle BI EE users: Instructions for ODBC configuration for UNIX and Linux are included in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. |
Note: | MySQL users: Oracle supports MySQL Enterprise version. Oracle does not support MySQL Community version. |
Note: | Essbase Studio does not support data source table names and column names that contain spaces or special characters, such as a period (.). See Naming Restrictions for Essbase Studio for a complete listing of unsupported characters. |
Flat File Data Sources: In Essbase Studio, ODBC configuration is not required for flat file data sources.