Introduction

OpenEdge applications are often deployed alongside other business systems that are responsible for key pieces of the overall business process. In these scenarios it is imperative that OE also connect (or integrate) with these other applications in order to execute the business process. DataDirect Cloud and Easyl are both Progress Pacific tools that facilitate this integration with SaaS applications like Salesforce, Microsoft Dynamics CRM, Oracle RightNow, and other sources in the development pipeline. More information about DataDirect Cloud is available here. More information about Easyl is available here.

The ABL samples show how you can interact with the DataDirect Cloud (DDC or D2C) server or business objects in an Easyl data set, using a set of OOABL classes. These classes provide a simplified wrapper around a series of DLL calls to the D2C Driver via the ODBC Driver Manager. This simplification is primarily around removing the need to work directly with the ODBC API via memptrs and the like. The classes simplify the calls a consumer of the API must make in order to execute a SQL statement, gather corresponding metaschema and data results. By encapsulating the process, the ABL programmer needs only to formulate a SQL query and designate a target for its results while the classes process all the handle allocations, state transitions and cleanup.

The API returns the data from the query executed (the result set) as either a JSON Object, or a dynamically-created temp-table. This temp-table is created from the column information of the query. The sample code allows you to connect to any D2C data source, and to query it in any way you see fit.

Setup & environment

Download the attached abl_d2c_easyl.zip archive, and create a new project in Progress Developer Studio, via the File > Import > General > Existing Projects into Workspace functionality, and select the downloaded archive. The project is named DataDirectCloud_EASYL_ABL_API.

There are a number of prerequisite steps in order to access data via the DataDirect Cloud. These steps are detailed in the Integrating DataDirect Cloud and Progress Easyl into OpenEdge using the ODBC Bridge Sample Applications PDF in the doc folder of the project (and attached to this page). If you are an OpenEdge customer performing your first time access to Easyl, it is also recommended that you take a look at the Including data from your on-premise OpenEdge database into an Easyl Data Set PDF in the doc folder of the project to help get started with EASYL by incorporating familiar processes.  If you are using DataDirect Cloud, you will need an account on a Cloud data provider, an account on DataDirect Cloud, and some D2C drivers installed on your local machine. If you are using EASYL, you will need your Progress ID to gain access to the Progress Pacific EASYL web interface. Once there, select the pull down menu on your profile at the top, right corner of your EASYL page and select. "Install EASYL for Windows" to download your copy of the Easyl Client Application. NOTE: This client only runs on Windows platforms at this time.

Running the sample

The project has been set up so that you can run the samples via a Run Configuration. The D2C sample run configuration is called Run D2C Sample and the EASYL sample is called Run EASYL Sample. More information about the types of operations supported are in the Integrating DataDirect Cloud and Progress Easyl into OpenEdge using the ODBC Bridge Sample Applications PDF document.

Feedback and comments

Please feel free to provide comments and feedback, and questions you might have on this page and its parent community.

This project is licensed under the Apache 2.0 license. See the LICENSE and NOTICE file in the project root for details.