Versions Compared

Old Version 16

changes.mady.by.user Former user

Saved on

compared with

New Version 17

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

The database connector is a web application and can be deployed under any Servlet container or run in a simply Standalone mode. The connector relies on the JDBC API. You can use any relational database as long as you have a JDBC driver for that database.

The Connector contains a working sample Derby database with BIRT and MyStore query sets and some test data. This makes it very easy to test if the connector is up and running when your installation is complete.

These instructions apply to Cloud and in-house customers.

Column
width240px

On this page:

Table of Contents
maxLevel1

Installation Steps

The Database Connector can be configured to run in:

  • Any servlet container such as the frevvo-tomcat in-house server. - Recommended for in-house customers.
  • Standalone mode - Recommended for cloud customers as no additional servlet container software is needed. This mode is also useful for in-house customers who want to run the connector on a different server than

...

  • the

...

  • installation

...

  • .

...

width240px

On this page:

...

Installation Steps

Follow these steps to install the Database Connectorinstructions:

  1. frevvo-tomcat bundle Instructions or Standalone Instructions

...

  1. JDBC driver

...

  1. Installation
  2. Connector Configuration Instructions - detailed steps to integrate the connector with your database.
Note

Cloud customers , running the database connector behind their firewall, should verify must verify connector connectivity to the frevvo Cloud

...

Server.

frevvo-tomcat bundle

...

Instructions

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

  1. Download the Database Connector warfile.
  2. Rename the file to database.war
  3. Copy database.war to <frevvo-home>\tomcat\webapps.
  4. Install the JDBC driver

  5. Start the Insight server. and then start Live Forms.

    Expand
    titleClick here for the instructions to start the Insight server and Live Forms

    Insert excerpt
    Planning for v7.3
    Planning for v7.3
    nopaneltrue

  6. Test the connector installation by copying this URL directly into your browser:

...

  1. Review the previous installation steps
  2. See starting and testing the connector installation for more detailed instructions and common problems.
  3. If you cannot get the database connector working please see Getting Help to contact  support.

...

Standalone

...

Instructions

  1. Verify that Java 8 is installed and the Java_Home environment variable has been configured .
  2. Download the Database Connector Standalone bundle.
  3. Unzip the database.zip file to a location of your choice. We will refer to this directory as <db-home>
  4. Install the JDBC driver
  5. You can start the connector using plain java command or execute one of the files in this directory to install the DB Connector as a Windows service or *nix console instance:
    1. Choose one of these methods to start the connector:
      1. Method 1: Using java in a command window
        1. Navigate to the <directory where you unzipped the database.zipfile>
        2. Type java -jar database.war
      2. Method 2: for Windows OS
        1. Install the DB Connector as a Windows service by double clicking the Install-Service.bat file. Click the Start DBConnector Service.bat to start the service.
      3. Method 2 for *nix OS
        1. Execute the  DB Connector.sh shell script for *nix operating systems.
  6. Test the connector installation by copying this URL directly into your browser:

...