Hyperion(r) SQL Interface Guide | Information Map | ||
Show | Previous | Next |
Hyperion(r) SQL Interface Guide | Information Map | ||
Hide | Previous | Next |
Hyperion(r) SQL Interface Guide | Information Map |
Show | Previous | Next |
Hyperion(r) SQL Interface Guide | Information Map |
Hide | Previous | Next |
Before you can access data using SQL Interface, you must select a data source and the driver it requires. The procedure depends on your operating system:
Note: For detailed, driver-specific information on each of the MERANT drivers, see the MERANT DataDirect Connect ODBC Reference in the /odbc/merant40/docs directory of your Essbase installation ($ARBORPATH/odbcdocs for UNIX).
On Windows, use the ODBC Administrator to configure the data source.
To configure the ODBC Administrator, use this procedure :
C:\WINNT\SYSTEM32\ODBCAD32If you do not have the ODBC components, look for the installation program mdac_typ.exe in \odbc\merant40\mdac in your Essbase installation.
For detailed instructions, see the appropriate driver chapter in the MERANT DataDirect Connect ODBC Reference (for example, "Connect ODBC for dBASE," or "Connect ODBC for Oracle").
For an examples, see the example appropriate for your operating system:
To configure the dBASE data source, complete the following steps:
The Create New Data Source dialog box is displayed.
The User DSN tab of the ODBC Data Source Administrator dialog box is displayed with dBASEFiles listed in the User Data Sources list box:
If you need help during the procedure, use the online help. For example, clicking the Help button on the General tab of the ODBC dBASE Driver Setup dialog box (in Step 4) brings up a Help screen:
Different help topics are available from different dialog box Help buttons.
To configure the dBASE data source, complete the following steps:
The Create New Data Source dialog box is displayed.
The User DSN tab of the ODBC Data Source Administrator dialog box is displayed with dBASEFiles listed in the User Data Sources list box:
If you need help during the procedure, use the online help. For example, clicking the Help button on the General tab of the ODBC dBASE Driver Setup dialog box (in Step 4) brings up a Help screen:
Different help topics are available from different dialog box Help buttons.
The ODBC Administrator is not available on UNIX platforms. SQL Interface generates the.odbc.ini file upon installation, and you do not need to do any further configuration to use the budget.dbf file.
If you add data sources or drivers, you may need to edit the.odbc.ini file:
The .odbc.ini file contains the ODBC connection and configuration information, such as data source name and driver product name. Specific information varies among platforms. The file and format are defined by the Microsoft ODBC specification.
Because the .odbc.ini file maps data source names to driver products, you must edit the .odbc.ini file if you add a new driver product or data source or change driver products or data sources.
Here is the entry you make in the .odbc.ini file for the Oracle 8 driver (assuming you installed to home/hyperion/essbase):
[ODBC Data Sources]
Oracle8=MERANT 4.0 Oracle 8 Driver
[Oracle8]
Driver=/home/hyperion/essbase/dlls/ARor815.so
Description=Oracle8
ServerName=name
Substitute for name the Oracle server name appropriate for your site, and substitute 3.6 for 4.0 if you are on AIX.
For more information about the.odbc.ini file, see the MERANT DataDirect Connect ODBC Reference in the $ARBORPATH/odbcdocs directory.
![]() Copyright © 2002 Hyperion Solutions Corporation. All rights reserved. http://www.hyperion.com |