Page History

1. Before You Begin

1.1 Are You Migrating BellaDati to Another Server?

If you are migrating BellaDati to another server, create an export of your data as an XML backup. You will then be able to transfer data from your old database to your new database.

2. Create and Configure the PostgreSQL Database

1. Create a database user which BellaDati will connect as (e.g. belladati_dbuser). Remember this database user name, as it will be used to configure BellaDati's connection to this database in subsequent steps.
2. Create a database for BellaDati to be used as data warehouse (e.g. belladati_db) with Unicode collation.
   
   

   Code Block
   CREATE DATABASE belladati_db WITH ENCODING 'UNICODE';

   Or from the command-line:
   
   

   Code Block
   $ createdb -E UNICODE belladati_db

3. Ensure that the user has permissions to connect to the database, and to create and write to tables in the database.

3. Copy the PostgreSQL JDBC Driver to Your Application Server (BellaDati WAR Only)

Skip this step if you are using BellaDati virtual applicance distribution. BellaDati virtual appliance includes the PostgreSQL JDBC driver.

1. Download the PostgreSQL JDBC driver from http://jdbc.postgresql.org/download.html. (Obtain version 9.0 of the JDBC 4 driver.)
2. Add the PostgreSQL JDBC driver jar to the lib/ directory of your application server.

4. Next steps

Continue configuring BellaDati WAR for your application server as described on:

• Installing BellaDati on GlassFish 2.1
• Installing BellaDati on Tomcat 6.0
• Installing BellaDati on Jetty 1.6