The Relational Database Management System (RDBMS) Integration

The RDBMS Integration Connector allows organizations to synchronize data between their RDBMS (Relational Database Management Systems) and other enterprise databases.

The Geonexus Integration Platform RDBMS Connector leverages JDBC for communicating with target systems. Through a full-compare approach and reporting, the RDBMS Integration Connector ensures integrity of enterprise data, allowing it to be viewed in either database without requiring viewing at the source. Its no-code approach reduces time and money spent on integrating systems.

Features & Benefits:

  • Ensures the integrity of enterprise data through full compare approach 
  • Facilitates scheduled and on-demand synchronization 
  • Provides multi-system capability across enterprise databases 
  • Capable of transforming data (value lists, calculated fields, geotransform) 
  • Offers comprehensive reporting 
  • Supports read, create, link, orphan, update, and delete for Oracle and Microsoft SQL Server views and tables 

Connection configuration

An example configuration of a connection to an Oracle database.

Enlarge Image
Enlarge Image

Connection configuration

An example configuration of a connection to a Microsoft SQL Server database.

Contact Us