Quella Cognitus   2.0.1000 Features
Quella Creator   2.0.1000 Features
Quella Business Intelligence Solution Tutorial

Feel free to download our Step-by-Step Tutorial. This tutorial shows you how to turn your data into decisions using Quella Business Intelligence Solution.
Quella Business Intelligence Solution Partner Programme

Participate in our Partner Programme and benefit from the possibility to offer to your customers a complete and cost effective Business Intelligence Solution.
Quella Business Intelligence Solution Order Today

Buy today and profit from our volume discounts.

Quella Creator: Implementation Features

Implementation features refer to the physical implementation of a Business Intelligence Solution. The implementation of a solution implies the physical creation of all the different tables and fields defined in the design phase. In addition, the defined relationships and processing logics behind tables and fields are translated into code and compiled. Then, all the implemented objects and code are organised into consecutive tasks or steps.

 

Finally, the implemented solution can be scheduled so that to automate data processing once the solution is deployed. Note that the physical implementation of a solution is carried out at a Meta Data level without the need of an on-line connection to the involved data sources.

 

The feature list displayed below is not exhaustive and is only intended to give an understanding of the core functionality available to the users of Quella Creator.

 

ETL-job Creation

Quella Creator ETL-job Creation

Once the design of a solution is finished, its tables, reports and corresponding logic have to be physically implemented. To do so, Quella Creator has to identify all the objects involved and needed by the given solution. These identified objects together with their logic are then physically created.

 

Once all objects are implemented, Quella Creator creates a task or ETL-job for the implemented solution. This ETL-job is composed by a series of steps which are responsible for executing the piece of data processing required by each object in a given solution. Depending on the complexity of the logic behind a given object, more than one step may be necessary.

 

ETL-job Execution (Synchronous)

Quella Creator ETL-job Execution (Synchronous)

ETL-jobs can be run synchronously so that the execution of a given job can be observed. A synchronous execution means that the job is started interactively from the user interface. This also means that Quella Creator is locked until the execution of the given job is completed.

 

The advantage of this type of execution is that it is possible to manually define the start step and the end step. Regardless of this, each step is executed one-by-one and according to its assigned processing order.

 

ETL-job Execution (Asynchronous)

Quella Creator ETL-job Execution (Asynchronous)

An ETL-job is run asynchronously every time its execution is triggered from the Schedule Window. An asynchronous execution means that the job is run in a background process so that Quella Creator is never locked and remains responsive during the whole period of execution. This also implies that several jobs can be run simultaneously.

 

There are two method of starting a job from the Schedule Window:

  • Manually using the Run command

    •  

  • Automatically using the Schedule command

 

ETL-job Schedule

Quella Creator ETL-job Schedule

Once all the objects and corresponding logic underlying a given solution have been physically implemented and packed into an ETL-job, the created ETL-job can then be scheduled to automatically run according to a pre-defined pattern. The idea behind the scheduling of an ETL-job is to minimise human intervention so that to make data processing more human resource independent and therefore more cost effective.

See also: