...

dbconnector.queryset@TEST.resource-def.url=jdbc:jtds:sqlserver://dbhost;databaseName=TEST;
dbconnector.queryset@TEST.resource-def.validationQuery=SELECT 1
dbconnector.queryset@TEST.resource-def.user=dbconnector
dbconnector.queryset@TEST.resource-def.password=*******

DB Connector Quick Demo

The database connector contains working sample databases with some test data. The BIRT (ClassicModels) and myStore querySets are preloaded with in-memory Derby databases and test data.  This make it very easy to try out the connector.  No configuration is necessary.

Follow the steps below to deploy the connector in Standalone mode or the the tomcat bundle and you can get started very quickly.

The In-house tomcat bundle:

...

1. Review Supported Platforms. Verify that the certified version of Java 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 warfile. Rename the file to database.war

4. Extract the tomcat bundle zipfile to a location of your choice. We will refer to this directory as <frevvo-home>.

5. Copy database.war to <frevvo-home>\tomcat\webapps.

6. 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

7. 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
8. Create a tenant.
9. Create a designer user in the tenant
10. 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.
    
    

...