Create and Share a New Business Analytics Repository

Business Analytics Administration : Business Analytics Server Administration : Deploying Business Analytics Instances, Clusters or Artifacts : Sharing the Business Analytics Repository in Clustered Environments : Create and Share a New Business Analytics Repository

To create a new shared repository

1. Create a new Business Analytics Repository in the appropriate database for your environment.

Using the SQL tool for the database that will be host, add Business Analytics Repository tables with the scripts shown below from the corresponding folder in MashZoneNG-install/prestorepository:

Database	Folder	SQL Scripts
Microsoft SQL Server	mssqldb	createDBTables.txt for MetaData and the default User Repository createSnapsTables.txt for Snapshots createSchedulerTables.txt for Scheduler
MySQL	mysqldb
Oracle	oracledb
PostgreSQL	postgresdb

There are also scripts to drop the corresponding Business Analytics Repository tables in these folders, if needed.

2. Copy the JAR file for the JDBC driver for your database to the MashZoneNG-install/apache-tomee-jaxrs/lib folder on all cluster nodes.

3. If this is a new cluster, update configuration information for the MetaData, User and Snapshot repositories for one Business Analytics Server in the cluster. See steps 3 onward in Move the Business Analytics repository to a robust database solution for instructions.

4. Copy the rdsJdbc.properties file to the MashZoneNG-config folder for the entire cluster or to each Business Analytics Server in the cluster.

If you are using a shared external Business Analytics configuration folder, both of these files are already in the list of property files that you place in this folder. See Setting Up an External Business Analytics Configuration Folder for more information.

5. Enable distributed caching for artifacts (required) and optionally distributed caching for mashable/mashup responses. See Configure BigMemory Servers for Business Analytics Caching and In-Memory Stores for more information and instructions.

6. If the Business Analytics Repository is hosted in Microsoft SQL Server, MySQL or Oracle, change the repository JAR in the Business Analytics Server.

7. Restart each Business Analytics Server in the cluster.

Contact Support | Community | Feedback