What is DATPROF Runtime

Datprof Runtime is a Web-based tool to manage and deploy predifined SQL packages.  Additionally OS scripts can be added to run too.

The tool provides easy deployment and running of application packages in different database environments. 

It allows you to start applications and monitor its progress using a web-based interface or the API system.

The use of the permission system allows you to distinguish adminstrators from users.

How to use DATPROF Runtime

DATPROF Runtime is software that allows managing and executing DATPROF applications using a web browser. DATPROF Applications can be generated by these three DATPROF products:

-          DATPROF Integrate

-          DATPROF Subset

-          DATPROF Privacy

A DATPROF application generated by DATPROF Privacy or Subset  consist of Velocity templates, generated SQL scripts and/or OS scripts.

A DATPROF application generated by DATPROF Integrate consist of generated SQL scripts and/or OS scripts.

(info) SQL scripts and/or OS calls may also contain velocity elements, check  the chapter Using Velocity

Velocity is a Java Template engine internally used by DATPROF Runtime to parse code. It uses variables, methods  and basic control statements (foreach, if/else). 

For more info check http://velocity.apache.org/engine/devel/ The output of a DATPROF Velocity template is a SQL script.

DATPROF Runtime is capable of executing the application, run a specific scenario, maintain the status, and generate log files and reports . A scenario is a predefined named set of actions within an application package.

Applications can run in  either an Oracle or Microsoft SQL Server Database. For DATPROF Privacy and DATPROF Subset  we have support for PostgreSQL.


Important Terms 

It is important to understand some terms that are being used in DATPROF Runtime.

Project is an administrative unit holding the list of created environments and uploaded applications.

An Environment is an administrative unit created within a project. It holds only one installed application to execute. It stores the database connection details for this environment and the history of the different runs.

An Application is a generated package by DATPROF Integrate, Subset or Privacy. An application is uploaded into a DATPROF Runtime project. This uploaded application can be installed in an environment to get executed by an agent on either an Oracle or an MS SQL Server database. An Environment is always bound to one database. The application though may read from another database.

An Agent is an independent java process that can execute an Installed application. Multiple agents may exist and they can be used for different environments. An agent can only run one application at the time.

All DATPROF Runtime administration is stored in the DATPROF Runtime internal HSQLDB database. This database is saved in the Data folder of the project.
Existing installations using external 3rd party databases for DATPROF Runtime administration are supported.

Runtime Work process

To work with DATPROF Runtime you should follow this process:

  • Create a Project
  • Create one or more Envrionments within the Project. 
  • Upload an Application into your Project
  • Install an Application into your Enviroment.
  • Check and set the Environment parameters.
  • Start the application and monitor it.