Installation Steps

We recommend:

• In-house Customers - Follow the frevvo-tomcat Bundle Instructions.

• Cloud Customers - Follow the Standalone Bundle Instructions.

frevvo-tomcat Bundle Instructions

These instructions assume that your frevvo-tomcat bundle is already installed and running successfully.

1. Stop your

   

   server.

2. Download Database Connector war file that is compatible with the version of

   

   that you are running to <frevvo-home>\tomcat\webapps.

3. Rename the downloaded file to database.war

4. Install the JDBC driver

5. Start your

   server

6. Browse http://<host>:<port>/database/status

7. If the status returns failures or disabled:

   1. Review the previous installation steps.

   2. See starting and testing the connector installation for troubleshooting.

8. When the status returns Passed for each queryset, your installation is complete

9. Follow the Connector Configuration Instructions with the detailed steps to integrate the connector with your database.

Open

Standalone Bundle Instructions

1. Download the Database Connector Standalone bundle.

2. Unzip the database.zip file to a location of your choice. We will refer to this directory as <db-home>

3. Install the JDBC Driver

4. Choose one of these methods to start the connector:
   
   
   

   • Method 1: Using java in a command window

     1. Navigate to <db-home>\database-connector-2.5.x .Type java -jar database.war

   • Method 2: for Windows OS
     
     

     1. Double click the <db-home>\database-connector-2.5.x\Install-Service.bat file to install the connector as a Windows service. Click the Start-DBConnector-Service.bat to start it

   • Method 3 for *nix OS

     1. Execute the  DB Connector.sh shell script for Unix/Linux operating systems.

   • Method 4 for Linux

     1. The Database Connector can also run as a service under Linux systemd
        
        
        

5. Browse http://<host>:<port>/database/status - Note the standalone connector defaults to port 8081.

6. If the status returns failures or disabled Connector Test failed then:

   1. Review the previous installation steps

   2. See starting and testing the connector installation for more detailed instructions and common problems.
      
      

   Open

   

7. When the status returns Passed for each queryset, your installation is complete

8. Cloud customers must also verify connector connectivity to the frevvo Cloud Server.

9. Follow the Connector Configuration Instructions with the detailed steps to integrate the connector with your database.

Install a JDBC Driver

The connector relies on the JDBC API. You must have a JDBC driver for your database. Refer to Supported Platforms for the list of databases certified by frevvo.

The preinstalled drivers are listed below.

• MS SQL driver - This is embedded in the database.war file with standalone bundle, however it is not embedded in the frevvo-tomcat bundle.

• DERBY driver

If your database driver is not pre-installed, you will have to locate a compatible driver from the internet. Try these locations.

• Oracle

• MySQL

Copy your driver to

• <frevvo-home>/tomcat/lib in the frevvo-tomcat bundle

• <db-home>\database-connector-2.5.x\lib Standalone bundle