Setup

Demobox: This step is not necessary when using the datasqill Client within the Demobox; the client is preconfigured.

Prerequisites: datasqill Server is installed and active, datasqill Admin has authorized the user for access to one or more transformation environments, credentials for repository access, and the license key (or a datasqill-local-config.json file)

Download and install the latest datasqill Client for Windows, Mac OS or Linux. The connection configuration to the datasqill repository can be done either via the GUI or via a JSON file.

Setting up connection via JSON file

The connection is controlled by a JSON file datasqill-local-settings.json, which is distributed by the datasqill Admin.

{
  "configurationDB" : {
    "url" : "jdbc:h2:tcp://your_datasqill_host:9094/datasqill;AUTOCOMMIT=false;SCHEMA=DATASQILL_REPOSITORY",
    "usr" : "DATASQILL_REPOSITORY",
    "pwd" : "encrypted_password"
  },
  "license" : {
    "licenseKey" : "YOUR LICENSE KEY"
  },
  "logging" : {
    "logPath" : "/Users/username",
    "logLevel" : "FINE"
  }
}
~

The logPath variable in the JSON contains the path where the datasqill Client log files are stored; the path must exist (Important: Use Unix-style slashes in the path on Windows).

Place the JSON file under /User/username or C:/Users/username respectively.

Setting up connection via the GUI

If the datasqill-local-settings.json file is not found, the connection information must be entered via the GUI when starting for the first time. The fields in the GUI correspond to the JSON (see above).