Progress Software Corporation · NASDAQ:PRGS
Progress Software — Technical Presentation (2017)
30 slides from Progress Software's technical presentation, Nov 2, 2017

Slide 1: Deliver Secure SQL Access for Enterprise APIs
Deliver Secure SQL Access for Enterprise APIs Dipak Patel, Principal Product Manager and Co-founder of OpenAccess, Progress Dennis Bennett, Principal Sales Engineer, Progress

Slide 2: Audio Bridge Options & Question Submission
Audio Bridge Options & Question Submission 2 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 3: Deliver Secure SQL Access for Enterprise APIs
Deliver Secure SQL Access for Enterprise APIs Dipak Patel, Principal Product Manager and Co-founder of OpenAccess, Progress Dennis Bennett, Principal Sales Engineer, Progress

Slide 4: Agenda
Agenda ▪ Background and Use cases for SQL Access ▪ How to deliver SQL Access for REST APIs? ▪ Demo ▪ Best Practices 4 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 5: How Have BI Solutions Evolved?
How Have BI Solutions Evolved? 5 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 6: SQL Is a Common Approach
SQL Is a Common Approach 6 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 7: SQL Is a Common Approach
SQL Is a Common Approach 7 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 8: How Do We Get Back to 3rd Wave?
How Do We Get Back to 3rd Wave? 8 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 9: OpenAccess Gets You Back to 3rd Wave
OpenAccess Gets You Back to 3rd Wave 9 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 10: Survey Question 1: Which Enterprise BI tools are you using?
Survey Question 1: Which Enterprise BI tools are you using in your organization today? • Oracle Business Intelligence (OBIEE) • Microsoft Business Intelligence (SSIS, SSAS, SSRS) • SAP Business Objects • IBM Cognos • Other (Please share through comments) 10 © 2017 Progress Software Corporation and/o

Slide 11: Survey Question 2: What solutions are you leveraging for your Enterprise API layer?
Survey Question 2: What solutions are you leveraging to develop your Enterprise API layer? • CA API Management • IBM API Management • Oracle API Manager • Mulesoft • Other (Please share through comments) 11 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserv

Slide 12: SQL Standards remain popular for access data
SQL Standards remain popular for access data API Landscape 1000 900 206 800 700 281 176 184 600 500 137 400 728 300 569 571 551 200 412 100 0 ODBC REST SOAP JDBC ADO.NET Currently Use Plan to use in the next 2 years Source: 2017 Data Connectivity Outlook Survey 12 © 2017 Progress Software Corporatio

Slide 13: Other popular use cases for virtual SQL access
Other popular use cases we see need for virtual SQL access Application / Business Logic Abstraction Support Multi-Tenancy • Business Logic Layer: CRM, • Expose single interface • Enterprises offer multi-tenant Finance and other distributed across large architecture applications are integrated object

Slide 14: Survey Question 3: Which of the following do you need SQL Access to?
Survey Question 3: Which of the following do you need SQL Access to? • Enterprise API Layer / Data Access Layer • Business Logic Layer • Single/Multiple Data Stores • Multi-Tenant Architecture • Other (Please share through comments) 14 © 2017 Progress Software Corporation and/or its subsidiaries or

Slide 15: Agenda
Agenda ▪ Background and Use cases for SQL Access ▪ How to deliver SQL Access for REST APIs? ▪ Demo ▪ Best Practices 15 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 16: Customized SQL Connectivity
Customized SQL Connectivity It is the same code whether you are supporting ODBC, OLE DB, JDBC or .NET. OpenAccess SDK provides the majority of the code needed to SQL enable a data source. You generate the small amount of code (IP) residing between the SQL engine and your data store. This code proces

Slide 17: Steps to Implement a Driver
Steps to Implement a Driver Design Setup Test • Define the • Determine • Test sample view of API features you queries data – will support – through schema CRUD? provided ODBCISQL • Determine • Implement application how API will the IP API interact with functions by • Package for SQL engine starting

Slide 18: OpenAccess can plug in to your enterprise security
OpenAccess can plug in to your enterprise security Image source: https://docs.oracle.com/cd/E55956_01/doc.11123/administrator_guide/content/admin_existing.html 18 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 19: Translating between SQL and REST
Translating between SQL and REST {JSON} ipExecute REST Call IP CODE 19 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 20: SQL Support
SQL Support Broad SQL92 and SQL99 support • DDL – Create / Alter / Drop Tables, Views and Indexes • DML – Select, Insert, Update, Delete • Stored procedures – Call • Joins, unions, nested queries • Order By, Group By, Scalar Functions Join options • Push down to the server • SQL Engine performs Join

Slide 21: A large Financial Company is using OpenAccess for ODBC, JDBC Access
A large Financial Company is using OpenAccess for ODBC, JDBC Access ▪ Technology Needs: • BI team needed access to the data access layer from Microstrategy and IBM Cognos. • New applications need to be authorized by internal authentication and security layer. ▪ Challenge: • They developed an in-hous

Slide 22: Agenda
Agenda ▪ Background and Use cases for SQL Access ▪ How to deliver SQL Access for REST APIs? ▪ Demo ▪ Best Practices 22 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 23: Demo
Demo

Slide 24: Agenda
Agenda ▪ Background and Use cases for SQL Access ▪ How to deliver SQL Access for REST APIs? ▪ Demo ▪ Best Practices 24 © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 25: Best Practices: Support Multiple APIs – ODBC, JDBC, ADO.NET
Best Practices: Support Multiple APIs – ODBC, JDBC, ADO.NET ▪ Some BI/Data Integration tools are Java and JDBC Client ODBC Client ADO.NET Client use JDBC, others are Native and use ODBC ▪ Having to implement and test single interface layer saves in cost of ownership ▪ Compatibility with enterprise B

Slide 26: Best Practices: Authentication
Best Practices: Authentication ▪ Where to include code to integrate with IAM JDBC Client ODBC Client ADO.NET Client provider ▪ How to handle OAuth flows and UI? ▪ Authentication happens at execution time with REST APIs SQL OpenAccess SDK Interface Provider in Java Authentication? API Data Access Ser

Slide 27: Best Practices: How to create data model from APIs
Best Practices: How to create data model from APIs ▪ How to handle dynamic vs static metadata in JDBC Client ODBC Client ADO.NET Client API ▪ Map API and fields to relational schema ▪ Handling metadata for semi structured JSON responses SQL OpenAccess SDK Interface Provider in Java Mapping API metad

Slide 28: Best Practices: Optimize Query Performance
Best Practices: Optimize Query Performance ▪ Design enterprise API to allow search push- JDBC Client ODBC Client ADO.NET Client down, paging results, meta-data access ▪ Push down filtering and other operations, possibly joins ▪ Perform iterative design – simple to more SQL complex OpenAccess SDK ▪ I

Slide 29: Next Steps
Next Steps 1. Schedule a meeting with our Product team [www.progress.com/company/contact] 2. Or Learn More: • OpenAccess Overview Guide • Download 30-day trial of OpenAccess • Tutorial to Build a Custom Driver over a REST API under 2 hours 29 © 2017 Progress Software Corporation and/or its subsidiar

Slide 30: Progress
Dv Progress’
Source: Internet Archive copy of progress.com
More decks from Progress Software Corporation
Q3 2026 Earnings Presentation26 slides · Sep 30, 2026
Merger or Acquisition (July 2026)9 slides · Jul 22, 2026
Q2 2026 Earnings Presentation21 slides · Jun 30, 2026
Q1 2026 Earnings Presentation23 slides · Mar 30, 2026
Q4 2025 Earnings Presentation21 slides · Jan 20, 2026
Q3 2025 Earnings Presentation21 slides · Sep 29, 2025