DBMS INTERFACING

Database Management System

To meet increasing openness and interoperability needs, Topkapi features since version 5.0 ("Topkapi DB" product required) a SQL connector allowing interfacing with most Database Management Systems (DBMS) in the market. It allows sharing data between computer applications, storage of historical data in an open format, but also benefit from functional enhancements within Topkapi.

TECHNICAL CHARACTERISTICS

  • Compatible with the main DBMS in the market: ORACLE, SQL Server, MySQL, PostgreSQL, MariaDB, etc.
  • Simultaneous reading/writing of several thousand events per second
  • Flexible and effective link with several DBMS simultaneously
  • Data directed identically or differentiated to one or several DBMS …
  • Load balancing in parallel database systems
  • Link status monitoring
  • Solution based on the SQL language in ADO.net
  • Use possible without writing SQL queries (pre-formatted query sets supplied)
  • Simplified query editor
  • SQL query customization for advanced use
  • Compatible with Topkapi hot standby
  • Customizable automatic purging
  • Data bufferization in case a connection link is broken

 

CASE OF USE

  • Store and use Topkapi’s history data in an open format
  • Provide Topkapi’s history data to third party software
  • Use in Topkapi data produced by third party software
  • Interface Topkapi’s real-time core with a DBMS (OWSQL module) to:
    • Read the data in the base
    • Write Topkapi data to the base
  • Benefit from functional enhancements in Tokapi’s alarm views:
    • Customization of the views via the JavaScript language
    • Annotations
    • Actions (display of a mimic diagram view, e.g. by clicking an event line)
    • Inserting additional columns

 

EXAMPLES OF USE

Availability of data logged by Topkapi to third party applications and use of data in Topkapi regardless of the source:

  • CMMS
  • Reporting tools
  • ERP / MES
  • Log book for users comments
  • Data validation
  • Network modelization
  • Custom development
  • ...

 

 


A FEW REFERENCES

> REIMS MÉTROPOLE: Topkapi interfacing with CARL Software CMMS
> TOPKAPI EMS applications (Emission Monitoring Software): Long-term storage (5 years), on-the-fly report generation, etc...
> Ets LUCIEN: interfacing with the ERP, reading of MOs in ORACLE DBMS, traceability of operations (PostgreSQL DB)
> COMMUNAUTE D’AGGLOMERATION D’AURILLAC: interfacing via ORACLE with the WISKI software (RHEA, KISTERS group) – water data information system
> …
> Detailed references:
          - UNEAL
          - Etablissements LUCIEN
          - CONSEIL GENERAL 92