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  



Introducing SQL Interface

Use this chapter to understand SQL Interface and prepare for data loading with it:

New Features

Use this section to identify new features or changes since Release 5:

New for Release 6.5

Release 6.5 provides these improvements:

New for Release 6.2

Release 6.2 includes these improvements:

New for Release 6.1

Release 6.1 includes this improvement:

As of Release 6.1, the SQL Interface installation program on Windows no longer installs the ODBC Data Source components in the /bin directory. You will need these components to configure your data sources.

To verify whether you have these components installed, and if not, how to install them, use this procedure:

  1. Open your Windows control panel, and perform either of these steps:
  2. If you do not have the ODBC components, you can download Microsoft Data Access Components (MDAC) from the following Web site:
  3. http://www.microsoft.com/data/MDAC21info/manifest_intro.htm 
    

New for Release 6.0

Release 6.0 includes these improvements:

For information on the data sources qualified for use with Essbase on Windows NT and UNIX platforms, see the Essbase Installation Guide, file essinst.pdf in the /docs/pdf directory of your Essbase installation.

Note: You can also load data from spreadsheets and text files directly, using Application Manager. See the Essbase Database Administrator's Guide.

Understanding SQL Interface

Use SQL Interface to load data directly from a number of popular SQL, relational, and flat-file database servers. SQL Interface provides the connection you need to accomplish these tasks:

Note: You can load data from spreadsheets or text files using Application Manager without the use of SQL Interface. See the Essbase Database Administrator's Guide.

SQL Interface works with Application Manager to retrieve data:

  1. You write a SELECT statement in SQL using Application Manager.
  2. SQL Interface passes it to the SQL or relational database server. For non-SQL data sources, SQL Interface converts SQL statements to requests for data that the source understands.
  3. SQL Interface interprets the records received from the SQL, relational, or flat-file database server using the rules defined in the data load rules file. (For more information on data load rules files, see Loading SQL Data.)
  4. SQL Interface loads the interpreted, summary-level data into the database.

Preparing for Data Loading

To prepare to load SQL, relational, or flat-file data use this procedure:

  1. SQL Interface is installed during your OLAP Server installation. See the Essbase Installation Guide for information about initial configuration tasks.
  2. Choose your ODBC driver and point it to its data source. See Configuring a Data Source.
  3. If your data is in multiple tables, prepare the data for loading by doing either of these actions:
  4. Check that you can connect to the data source by using the Data Prep Editor in Application Manager to open the SQL source file. See Loading SQL Data.
  5. Create a data load rules file to tell SQL Interface how to interpret and load the SQL data into your Hyperion Essbase database. See Loading SQL Data.

After these steps are complete, you can load your data. See Loading SQL Data for instructions.




Copyright © 2002 Hyperion Solutions Corporation. All rights reserved.
http://www.hyperion.com