OpenEdge offers an open, standards-based interface for SQL. The OpenEdge database and its SQL interface provide an environment that enables efficient integration with third-party tools, such as development software, reporting, and Online Analytical Processing (OLAP) tools.

Featuring a state-of-the-art, cost-based query optimizer, the OpenEdge SQL Engine incorporates APIs for ODBC and JDBC. OpenEdge SQL includes the following components:

  • OpenEdge SQL Engine — The OpenEdge SQL Engine is installed as part of the OpenEdge Relational Database Management System. To support the OpenEdge Service Oriented Architecture, the SQL engine offers robust data type support, enables online schema changes, and provides for query optimization. These features are designed to maximize database scalability and performance.
  • JDBC Driver for OpenEdge by DataDirect — The JDBC Driver for OpenEdge is provided by DataDirect Technologies. The JDBC driver enables Java-based applications to access the OpenEdge RDBMS. The JDBC driver is installed as part of the OpenEdge SQL Client Access product.
  • ODBC Driver for OpenEdge by DataDirect — The ODBC Driver for OpenEdge is provided by DataDirect Technologies. The ODBC driver provides access to the OpenEdge database from applications that support the ODBC interface. The ODBC driver is installed as part of the OpenEdge SQL Client Access product.

Explore SQL for data access to OpenEdge databases

SQL developers outside of the ABL developer community are the primary users SQL. The following content offers more details on SQL.
  • An overview of OpenEdge SQL – For developers new to SQL, explore basic SQL concepts, manipulate data, work with database objects, maintain a database, extend the SQL engine and troubleshoot.
  • OpenEdge SQL statements – For experienced SQL developers, explore the reference guide which lists all of the available statements and provides some sample code for getting started with OpenEdge SQL.