Reliable data is central to business applications. The OpenEdge database is a Relational Database Management System (RDBMS) which is capable of handling thousands of users and high-traffic loads with sub-second response times. It ensures users are productive and customers are satisfied while protecting the data security and reliability.

Key benefits of the OpenEdge RDBMS include cost-effectiveness, easy to administer, scalable, and easy to manage. Applications may take advantage of one or all the following database features.

  • Security – To authenticate and authorize users of the application. Database Administrators can lock the database schema and data forcing all request to provide authentication and authorization credentials using the OpenEdge Authentication Gateway that can be integrated with external identity providers to offer single-sign on for application users.
  • Transparent Data Encryption (TDE) – To secure access to the data. OpenEdge TDE balances both security and performance needs in a complete out-of-the-box solution, using standard encryption libraries and encryption key management for secure, encrypted data. Protect as much as you want, down to a single table, index or field. Execute at full speed with less than 2% degradation while encrypting/decrypting. TDE includes both policy tools and a secure encryption keystore.
  • Replication – To improve uptime and protect against data loss due to a breach or disaster. Replication is the process of duplicating a source database to one or more target databases that are running on a separate machine. This duplication keeps an identical copy while also providing a hot standby in case a database fails. If a database does fail, a replica becomes active, ensuring that mission-critical data is available to your users 24 hours a day, seven days a week.
  • Multi-tenancy – To ensure privacy between tenant data. Multi-tenancy is a database architecture principle where a single instance of database runs on a server that serves multiple client organizations (tenants). Database administrators centralize database management tasks on a single database rather than separately for multiple tenants.
  • Table partitioning – To ease maintenance and increase performance. By partitioning database tables into smaller, more manageable units, database administrators use a "divide and conquer" approach to data management and improve access times.
  • Auditing – To support compliance regulations, auditing provides nonrepudiation of audit data. You can see who did what, where, when, and how. Auditing is a means of securely tracking and recording a trail of events that occur during execution of an application.
  • Change Data Capture – To ensure data accuracy across the enterprise CDC allows you to define change data capture policies that are created and activated at the table and field level to scale with your business needs. The process is driven by CDC triggers which execute on Create, Update and Delete (CUD) operations.
  • OpenEdge Pro2 - To provide real-time data replication for reporting and analytics purposes, Pro2 provides easy, fast data replication from an OpenEdge database into a separate OpenEdge, SQL Server or Oracle database. Gain quick and easy access to mission-critical data from your OpenEdge system, without disrupting normal business operations or risking transactional database stability.