Page Comparison

...

1. Download the Database Connector.
2. Unzip the database.zip file to a temporary location of your choice: e.g. c:\tmp. This will create a folder c:\tmp\database-connector-2.5.x. We'll refer to this directory as <db-tmp>
3. Copy <db-tmp>\database-connector-2.5.x\database.war to <frevvo-home>\tomcat\webapps.
4. Install the JDBC driver, if required

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

   Expand
   title Click here for the instructions to start the Insight server and Live Forms
   Insert excerpt Planning for v7.3 Planning for v7.3 nopanel true

   Note
   The database.war does not extract after startup. You will not see a database subfolder in the <frevvo-home>\tomcat\webapps directory.

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

...

1. Verify that Java 8 is installed and the Java_Home environment variable has been configured .
2. Download the Standalone connector zipfile herezipfile here.
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, if required.
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:

...

• <frevvo-home>/tomcat/lib if you are deploying the connector in the tomcat bundle
• <directory where you unzipped the database zip file>\database-connector-2.5.0x\lib

It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another location would be <CATALINA_HOME>/lib.

...

The In-house tomcat bundle:

1. Download the v7.2.1 Verify that Java 8 is installed and the Java_Home environment variable has been configured .
2. Download the latest tomcat bundle from the frevvo website.
3. Download the Database Connector from here.
4. Extract the files to a location of your choice. We will refer to this directory as <frevvo-home>.Navigate to the <frevvo-home>\ext\connectors directory.
5. Unzip the database.zip file to a temporary location of your choice: e.g. c:\tmp. This will create a folder c:\tmp\database-connecotr-2.5.x. We'll refer to this directory below as <db-tmp>
6. Copy <db-tmp>\database.war to <frevvo-home>\tomcat\webapps.

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

   Expand
   title Click here for the instructions to start the Insight Server and Live Forms
   Insert excerpt Planning for v7.3 Planning for v7.3 nopanel true

8. Test the connector installation by copying this URL directly into your browser:
   
   http://localhost:8082/database/status
   

   After performing these steps you will have:

   • Successfully installed the  database connector and retrieved data from the built-in test database
9. Create a tenant.
10. Create a designer user in the tenant
11. Download the Database Connector Application and upload it to the designer user for some example forms that demonstrate the power of the Database Connector using built-in databases.