Advanced ways to select data with SQL from OpenEdge We covered Select data with SQL from OpenEdge in a previous post. In this post we will review how JOINs, EXISTSs etc. are available to us when extracting data from OpenEdge with SQL. Let’s assume that you have a client such as DBeaver set up. Connect to your OpenEdge […]
Files to set up Setting up of ODBC connection to OpenEdge requires /etc/odbcinst.ini to be update with the right drivers. Once that is done, OpenEdge can be accessed by either using a DSN or DSN-less connection string. It is assumed that you have set up and tested your SQL ODBC connection drivers. If not, Installing OpenEdge […]
Progress OpenEdge SQL ODBC drivers You can obtain and install OpenEdge SQL Client Access drivers ODBC drivers (aka SQL ODBC drivers) from Progress’s Electronic Software Delivery (ESD) website. Contact Progress support or your account manager for details. SQL ODBC drivers for OpenEdge are available for Windows and Linux. This article focuses on installing SQL driver […]
Progress OpenEdge Applications SQL engine in OpenEdge is a modern tool to expose OpenEdge data via ODBC and JDBC directly to API and web applications. SQL engine is fast, mature and requires minimal setup. To me, it seems like SQL is a very viable alternative to ABL in building web applications. Character (CHUI) or desktop-based […]