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
|
Product |
Release |
Version |
|---|---|---|
|
Oracle RDBMS |
10G R1 + |
Standard + |
|
MySQL |
5.1.3 + |
Community + |
|
Microsoft SQL Server |
2008 + |
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.
|
Database |
Script 4.1.0 |
|---|---|
|
Oracle RDBMS |
oracle41.sql |
|
MySQL |
mysql41.sql |
|
Microsoft SQL Server |
sqlsvr41.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.