Installation
ROLAP report provides access to following databases:
- Sql Server 2000
- Sql Server 2005
- Microsoft Access
- MySql
- Oracle
- IBM DB2
SQL Server 2000
- Setup connection to the database in ReportPortal (Admin-Connections)
- Download Pubs.xml file and import it (Admin-ROLAP)
- Download Northwind.xml file and import it (Admin-ROLAP)
SQL Server 2005+
- Setup connection to the database in ReportPortal (Admin-Connections)
- Download AdvWorks.xml file and import it (Admin-ROLAP)
Microsoft Access
- Copy foodmart 2000.mdb (C:\Program Files\Microsoft Analysis Services\Samples\foodmart 2000.mdb)
to a folder that Anonymous user (IUSR_COMPUTERNAME) has write access to.
- Download Foodmart.xml file and import it (Admin-ROLAP)
- Setup connection to the database in ReportPortal (Admin-Connections)
- Read this article to Troubleshoot
MySql
IBM DB2
- Download DB2 Express-C
- Setup connection to the database in ReportPortal (Admin-Connections)
- Download DB2-Sample.xml file and import it (Admin-ROLAP)
Oracle