Query Object Enhancements

Workflow based Query objects

Intellicus 6 now provides a Canvas to design the Query objects. Designer just needs to drag and drop the available steps and prepare the required query by filling in the necessary details. Query objects designed in previous versions of Intellicus will work in this version but will be shown as per the new User interface.

When you add a new Query Object the designer gives you two steps - Data Source and Format. You can have multiple Data Source steps in a Query Object. Designer can also use existing Query Object as a data source in the new query object.

Extraction and Transformation Steps

There are some Primary steps and a few Advanced steps which designers can use to extract data and further transform it into desired form.

Primary Steps

Data Source

This Step helps you to fetch data from a RDBMS, File, Web Service or another Query Object. There can be any number of such steps in a Query Object.

SQL Data Source

File Data Source

Web Service Data Source

Format

Format step generally is the last step, captures captions etc. and acts as business view of the Query Object.

Filter

Filter Step is used to apply pre-defined filters and set Lookup values. Filter step can take input from any step and provide output to any step in the flow of Query Object.

Sort

Data passing through a Sort step gets sorted based on the properties set in the step.

Formula Fields

Formula Fields step allows you to add calculated fields that are populated at run time. These calculated fields are generally based on existing fields.

Advanced Steps

Join

This step takes two inputs. When the data is passing through this step, the data of both inputs will be joined based on properties set for this step.

Union

Union step takes two or more inputs. The data passing through this step appends to one another and forms a single output. During the union process you can decide to get sorted or unsorted output.

Dynamic Fields

Dynamic Fields step allows you get flexibility of adding or removing fields to a Query Object at run time based on your meta information. This step has capacity to

1. Add dynamic fields by Pivoting data from input Data Source
2. Dynamically fetch meta data for field properties

This step takes one input Data Source

External Task

External task step allows you to call standard and custom 3^rd party processes from within Intellicus Query Object. Some may be in-proc and some tasks may be sent to remote execution by appropriate bridge components. There are few pre-configured external tasks. More external tasks types can also be configured.

Creating Staging Database

Intellicus 6 now provides an option to use a database as a staging database. Using staging makes certain data operations efficient.

Currently only in-memory H2 database is supported as staging database.