Database Module PDF Print E-mail
Kapow SolutionThe Kapow Database Module extends the Kapow Web Data Server to include direct support for storing and accessing data into any major SQL database, like Oracle, Microsoft SQLServer, IBM DB2, MYSQL and more. It also includes logic to combine multiple record types by relational keys as well as automatic data “re-find” logic for history, removal of duplicates and partial record change detection.
no codingData can be imported directly from major Enterprise Search systems like Microsoft Fast and Autonomy, as well as major BI systems like SAP Business Objects, IBM Cognos, Oracle Hyperion, Corda, Temis and ClaraBridge.
The Kapow Web Data Server allows you to service enable ANY web based legacy asset AS-IS… in hours and days with no coding or rewriting! With Kapow Technologies you can automate access to all your legacy web assets. You don’t have to waste time and resources:
  • Writing connectors & APIs
  • Patching old code
  • Old Data formats
  • Ongoing Maintenance
Database Module

Database Storage Environment

Key Product Features

  • JDBC interface
  • Native Support (input/ ouput) for SQL datatypes e.g. binary, timestamp, varchar, etc.

Key Product Benefits

  • Seamless integration to BI reporting and dashboard tools

Point and Click Database Modeling

Key Product Features

  • Create database tables
  • Custom foreign key definitions

Key Product Benefits

  • Rapid database design and creation
  • Automatic linking of multiple database tables

Advanced Robot Features for Data Transformation

Key Product Features

  • Data converters for sortable data structures
  • Rich regular expressions

Key Product Benefits

  • Visual data enrichment for data normalization and advanced metadata extraction.

Database Integration

Key Product Features

  • SQL Execution within a robot
  • Query database from a robot
  • Database object updates

Key Product Benefits

  • Direct access to SQL databases for data validation, comparison, history, etc.

Refind Object step (object optimization)

Key Product Features

  • Automatic History Logic to detect new change/ removed objects on data sources

Key Product Benefits

  • Optimize extraction process based on historic data i.e. shorter run-time and fewer web page loads
  • Data cleansing and duplicate data removal

Tier 1 Database Vendor Support

Key Product Features

  • Oracle
  • IBM DB2
  • Microsoft SQL Server
  • MySQL
  • Sybase
  • For other Database formats contact Kapow Sales

Key Product Benefits

  • Full Database compliance for standard IT support