Visual Rules DatabaseIntegrator

Visual Rules DatabaseIntegrator extends the graphical modeling of business logic with database operations and comprehensive transaction control. Direct access to metadata of the database facilitates rule modeling.

This significantly increases productivity when developing rule-based systems that use operational databases or data warehouses.

(Kopie 1)

Overview Example rule

Rule Editor with flow rule using database operations

Import of Metadata

  • Wizard for automated mapping of database to rule data
  • Simple generation of data types directly from tables or queries
  • Data objects can instantly be used for further modeling

Data Access and Transaction Control

  • Easy-to-use editor for direct database access from rule models
  • Actions for database operations (insert, select, update, delete, etc.)
  • Simultaneous access to multiple databases via JNDI and JDBC
  • Dynamic queries with parameterized SQL statements
  • Control of local transactions explicitly within the rule model
  • Global transactions via JTA on Java EE Application Servers

Quick Facts

  • Easy generation of executable programs for rule based analysis, enrichment and processing of any data, e.g. in the data warehouse
  • Extends Visual Rules Modeler with special actions, functions and wizards for efficient access to relational databases
  • Read and write access to records in the database including transaction control
  • Call stored procedures and functions
  • All established relational databases and application servers are supported
  • SQL access to the database via JDBC