Setting up the Cantara Databases

The Cantara Integration Platform utilises database storage for configuration and scheduling information.

Minimum Supported Database Editions

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 Integration Platform 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. If you want to create a single database for all the components you can use the script xxx51.sql, otherwise you can create a database for each component.

Database Upgrade to 5.1.11+

To upgrade and existing Cantara 5.1 database to the latest version please use the appropriate scripts below.

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.