Skip to main content

Setting up the Cantara Database

The Cantara Access Server utilises file storage for the Standard Edition. In the case of the Enterprise Edition the recommended method is to utilise database storage.

You must define database storage if you wish to utilise the Cantara Scheduler as part of your installation.

Minimum Supported Database Editions

ProductReleaseVersion
Oracle RDBMS10G R1 +Standard +
MySQL5.1.3 +Community +
Microsoft SQL Server2008 +Standard +

Database Installation

Please refer to your database administrator and vendor documentation with regards to installation and set up of your preferred database platform. With the exception of the Cantara Scheduler, all Cantara Access Server operations are handled in memory and thus database performance requirements are generally very low.

Once you have installed the required database instance and schema you can utilise the appropriate script below to set up all of the necessary tables and indexes for you selected database platform.

DatabaseScript 4.2.0
Oracle RDBMSoracle42.sql
MySQLmysql42.sql
Microsoft SQL Serversqlsvr42.sql

 

JNDI Configuration

The Cantara Access Platform utilises your selected application server to handle data source management and accesses those configured data sources using the Java Naming and Directory Interface (JNDI) API. The user that connects to the Cantara database must have read/write permission to all of the tables within the schema.

 

On This Page

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.