The XML file is saved as “databasename.xml” for example, “sqlite.xml” or any name can be assigned. Using this file, user can modify database functions. This file contains the database functions in the XML format. Now, to view the database functions list following are the files needs to be configured : While creating Adhoc reports, there are database functions which can be applied on datatypes such as text, numeric, datetime, etc. In result, a sql query will be generated which may or may not support the selected database. Note : In case, dialect is not assigned then bydefault MySQL dialect is mapped with the selected database driver. Add the below present line at the end of the file in a new line.Ĭom.= Note: Here, Progress database is having Progress Dialect so it is mapped directly with the Progress database driver.Open “ sqlDialects.properties” file in edit mode using text-editor such as notepad, notepad++.In Helical Insight Application, following are the steps to configure dialect: Click here for more detailsĭialect is used for generating SQL query as per the database selected. Once you have downloaded the driver, you need to put that driver in a “Drivers” Folder of Helical Insight ApplicationĪnd then immediately it will start appearing in the drop down list of Datasource.Following are the steps to configure JDBC driver : JDBC driver configuration is required through which a database connection can be established with Helical Insight Application. Following are the steps to create report with Helical Insight using Progress Database: Post configuration process involves report creation. In this article we will cover in detail, how you can connect, analyze, share and use other features of Helical Insight with Progress Database.įollowing are the steps to be performed at file system of Helical Insight (hi-repository/System/Admin) when the database is configured for the first time : Helical Insight is an Open Source Business Intelligence (BI) tool which supports Progress database.

Progress 4gl download