Overview of the Connection Process

When an application accesses data through the OLAP API, it uses a connection provided by the Oracle implementation of Java Database Connectivity (JDBC) from Sun Microsystems. For information about using this JDBC implementation, see the Oracle9i JDBC Developer's Guide and Reference.

Connection Steps

The procedure for connecting involves loading an Oracle JDBC driver, getting a connection through that driver, and creating two OLAP API objects that handle transactions and data transfer.

These steps are described in the topic "Establishing a Connection" .

Prerequisites for Connecting

Before attempting to make an OLAP API connection to an Oracle database, ensure that the following requirements are met:

• The Oracle database instance is running and was installed with the OLAP option.
• Your Oracle database user ID has access to the relational schemas on which the data store is based.
• The Oracle client installation of the JDBC drivers is complete. For information about installing JDBC drivers, see the Oracle9i JDBC Developer's Guide and Reference.
• The OLAP API jar files are on the application development computer and are accessible to the application code. For information about setting up the OLAP API jar files, see Appendix A, "Setting Up the Development Environment"