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  



Configuring a Data Source

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

Configuring a Data Source on Windows

On Windows, use the ODBC Administrator to configure the data source.

To configure the ODBC Administrator, use this procedure :

  1. Start ODBC Administrator, using either of these methods:
  2. Choose a data source, or add one, and then enter the required information about the driver.
  3. 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:

Example: Creating a Data Source on Windows NT

To configure the dBASE data source, complete the following steps:

  1. Start the ODBC Administrator, using the instructions in Step 1 in Configuring a Data Source on Windows.
  2. Click the User DSN tab in the ODBC Data Source Administrator dialog box.
  3. Click Add on the User DSN page.
  4. The Create New Data Source dialog box is displayed.

  5. From the list box, select MERANT OEM 4.0 32-bit dBASEFile (*.dbf) and click the Finish button to display the General tab of the ODBC dBASE Driver Setup dialog box.
  6. Type the following information on the General tab:
    1. In the Data Source Name text box, type dBASEFiles.
    2. In the Description text box, type Load Files.
    3. In the Database Directory text box, type c:\hyperion\essbase\app\SQL_Samp. If you installed Essbase in the default directory, c:\hyperion\essbase, budget.dbf is stored in this subdirectory. If you installed it elsewhere, substitute your site's value for c:\hyperion\essbase.
    4. Click OK.
    5. The User DSN tab of the ODBC Data Source Administrator dialog box is displayed with dBASEFiles listed in the User Data Sources list box:

  7. Click OK to close the ODBC Data Source Administrator.

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.

Example: Creating a Data Source on Windows 2000

To configure the dBASE data source, complete the following steps:

  1. Start the ODBC Administrator, using the instructions in Step 1 in Configuring a Data Source on Windows.
  2. Click the User DSN tab in the ODBC Data Source Administrator dialog box:
  3. Click Add on the User DSN page.
  4. The Create New Data Source dialog box is displayed.

  5. From the list box, select MERANT OEM 4.0 32-BIT dBASEFile (*.dbf) and click the Finish button to display the General tab of the ODBC dBASE Driver Setup dialog box:
  6. Type the following information on the General tab:
    1. In the Data Source Name text box, type dBASEFiles.
    2. In the Description text box, type Load Files.
    3. In the Database Directory text box, type c:\hyperion\essbase\app\SQL_Samp. If you installed Essbase in the default directory, c:\hyperion\essbase, budget.dbf is stored in this subdirectory. If you installed it elsewhere, substitute your site's value for c:\hyperion\essbase.
    4. Click OK.
    5. The User DSN tab of the ODBC Data Source Administrator dialog box is displayed with dBASEFiles listed in the User Data Sources list box:

  7. Click OK to close the ODBC Data Source Administrator.

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.

Configuring a Data Source on UNIX

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:

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

Editing the .odbc.ini File for Changes

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.

Example: Editing .odbc.ini for Oracle 8

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