topkapi - Main functions -

DBMS & Topkapi interface

In order to meet the needs of openness and interoperability, Topkapi has an SQL connector that can be interfaced with most of the database management systems on the market.

Interfacing your databases with Topkapi monitoring solution

The openness and interoperability of supervision solutions is a criterion of choice. In order to meet this need, Topkapi SCADA software has a SQL connector - "Topkapi DB" version required. The latter allows data sharing between IT applications, storage of historical data in an open format, and also allows functional enhancements within Topkapi.

PDF

Download the technical sheet

More details on DBMS interfacing with Topkapi

Technical characteristics
Use case

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, etc.
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

Use case

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
Etc.

Business sectors

Topkapi: multi-sector software platform

Find out how our SCADA solution meets the needs of your business sector: challenges, functional advantages, business applications, concrete cases of use.

Building management

More economical, more comfortable, more environmentally aware... the building management sector continues to evolve. The Topkapi software platform helps you to meet these challenges.

Energy

The energy transition is impacting all players in the energy sector and must meet the challenge of reconciling a growing demand for energy with the preservation of our planet.

Environment

Preservation of the planet's resources, new consumer demands, stricter regulations... the environmental sector is receiving a great deal of attention and is looking for innovative solutions.

Industry

The concept of Industry 4.0 lays the foundations for the factory of the future, which is more flexible and efficient because it is more intelligent and communicative.

Smart city

How can the potential of new information technologies be used to respond to current urban issues related to the smart city: energy management, mobility and transportation, environmental considerations, etc.?

Transport & infrastructure

Water network, electricity network, rail transport, waterways... the actors of the transport & infrastructure sector need a reliable, secure and long-lasting supervision solution to provide an efficient and effective service.

Want to learn more about Topkapi?

Our teams are at your disposal to introduce you to our solution.