Install DG Solution Builder Server

Important

These steps do not install DG Solution Builder for Distributed Services Architecture (DSA). To install DG Solution Builder for DSA, go here.

DG Solution Builder Server is an enterprise-ready, fully-integrated DG Solution Builder web server packaged with Apache Tomcat 7.0.55. Security and web hosting is handled by Tomcat, which makes it easy to customize for your specific needs and preferred user authentication mechanism (including LDAP).

DG Solution Builder Server supports passthrough querying of JDBC connected data-sources, which enables DG Solution Builder to be used to read from and write to any database and to communicate with any web services required for your visualization data feeds.

OS Compatibility

This version has been tested on Windows, OS X and Linux. Install Java JRE 7+ on the target server prior to installing DG Solution Builder.

Browser Compatibility

DG Solution Builder is a 100% HTML5 application that does not require any special browser plugins. For the best user experience, use the latest version of Google Chrome.

The following web browsers are supported:

  • Microsoft Edge 27+
  • Google Chrome 48+
  • Mozilla Firefox 40+
  • Opera 27+
  • Apple Safari 8.0.8+

Installing and Starting DG Solution Builder

To install DG Solution Builder, download the zip file from our web site, unzip it in the desired installation directory, and run the startup script:

On Windows: Double-click the (bin/startup.bat) file.

On OSX / Linux:

  1. Open Terminal.app
  2. cd to the bin subdirectory in the installation directory,
  3. Issue the "sh ./startup.sh" command.

To shut DG Solution Builder down, run the shutdown.bat or shutdown.sh script.

Connecting to DG Solution Builder

By default, Tomcat uses port 8080. To connect, launch a web browser and browse to http://127.0.0.1:8080 (assuming you are on the server machine). Log in using the following credentials:

  • username: dgSuper
  • password: dglux1234

When prompted, request a license for your installation and install it as instructed.

Updating DG Solution Builder

Registered users are notified when updates to DG Solution Builder become available. To install an update:

  1. Download DGSB_xxxx.zip.
  2. In your browser, navigate to http://127.0.0.1:8080/update.html.
  3. Browse to the DGSB_xxxx.zip file.
  4. Click the "Upload" button.

After the upload, the browser refreshes and you are running the updated version of DG Solution Builder.

Customizing DG Solution Builder Installation

DG Solution Builder runs on standard J2EE servers, which means you can use web servers other than Tomcat, such as Jetty and IBM Websphere.

Configuring Users

To administer users in DG Solution Builder, edit "conf/tomcat-users.xml".

For details about using an external directory server or database for user management, see Apache Tomcat Website.

Configuring JDBC

To modify the JDBC configuration, edit "webapps/ROOT/WEB-INF/dgsb/example_db.json". The file format is as follows:

{
  "databases": 
  [
    {
      "name" : "jdbcDemoDB",
      "driver" : "org.apache.derby.jdbc.ClientDriver",
      "url" : "jdbc:derby://localhost:1527/jdbcDemoDB",
      "user" : "optional",
      "pass" : "optional",
      "passthrough" : true
      "queries" : 
      [ 
        { 
          "name" : "getWishes",
          "query" : "select ENTRY_DATE, {$WHAT} from WISH_LIST order by ENTRY_DATE",
          "cacheSecs" : 360
        }
      ]
    }
  ]
}

To use this feature, rename "example_db.json" to "_db.json". Changes to this file take effect immediately and do not require you to restart the server.

In this file you can define multiple databases that are displayed as query data sources in DG Solution Builder.

Ensure that an appropriate database driver JAR file is present in "webapps/ROOT/WEB-INF/lib". You can download popular database driver JAR files from these sources:

You must restart Tomcat after adding a new JAR.

If the passthrough setting is enabled, you can execute arbitrary queries against the database from DG Solution Builder. Note that there is a security risk in doing so, and d=administer security accordingly. Typically this feature is used in a controlled environment or when testing the queries required for your DG Solution Builder application.

A more secure approach is to disable passthrough and define query templates under queries. Predefined queries are cached, which reduces server workload in highly concurrent settings.

The important parts of a query template are the "name" and the parameters in the query string, which enclosed in "{$ }".

After your query templates are configured, you can invoke them from DG Solution Builder. For example, if your query is defined in "_db.json" as:

"getWishes": "select {$WHEN}, {$WHAT} from {$WHERE} order by {$WHEN}"

You invoke the query in DG Solution Builder as follows:

<queryName> where <key>=<val> and <another_key>=<another_val>

For example:

getWishes where WHEN=ENTRY_DATE and WHERE=WISH_LIST AND WHAT=WISH_ITEM

"where", "and" and variable names are case-insensitive. The query name and values are case-sensitive. The "where" and "and" clauses must be delimited by white space.

If a key or value has the quote ( " ) or equal ( = ) character, escape them using double quotes. For example "this has ""quotes"" in it".

Executing Queries from DG Solution Builder

  1. Click on "Data" tab in the upper left panel.
  2. To display configured database connections, click the hamburger icon.
  3. Select the desired database connection.
  4. Type your query and press ENTER.
  5. To create a block that returns the query's result set, drag "Query" label onto your dataflow.