OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
Web Reporting
Installation
Local Settings
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
Reference
icCube Client Library
XMLA Client Library

XML Schema Definition: Database

The schema 'Sales (MSSQL - XML Definition)' defines the cube 'Sales' that is sourcing its data from a relational database using a JDBC driver. So, a new type of data source and data table is introduced: respectively jdbcDS and jdbcDatatable.

Once the specific DB data sources and data tables are defined, the XML schema definition is basically the same as previously described regarding the dimensions and facts definitions.

JBDC Driver Setup

The jdbcDS XML element specifies the JAVA class name of the JDBC driver. The JAR containing this driver has to be specified in the CLASSPATH of the icCube application. This can be done by copying this JAR into the lib directory of the installation directory. Then the [Classs Path] section of the icCube .ini file bin/icCube.ini has to be updated as follows: 

...
[Class Path]
Class Path=C:\Program Files\Crazy Development\icCube\lib\sqljdbc4.jar;...