Progress Software Corporation · NASDAQ:PRGS

Progress Software — Technical Presentation (2017)

30 slides from Progress Software's technical presentation, Nov 2, 2017

  1. Slide 1: Deliver Secure SQL Access for Enterprise APIs

    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

  2. Slide 2: Audio Bridge Options & Question Submission

    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.

  3. Slide 3: Deliver Secure SQL Access for Enterprise APIs

    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

  4. Slide 4: Agenda

    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.

  5. Slide 5: How Have BI Solutions Evolved?

    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.

  6. Slide 6: SQL Is a Common Approach

    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.

  7. Slide 7: SQL Is a Common Approach

    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.

  8. Slide 8: How Do We Get Back to 3rd Wave?

    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.

  9. Slide 9: OpenAccess Gets You Back to 3rd Wave

    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.

  10. Slide 10: Survey Question 1: Which Enterprise BI tools are you using?

    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

  11. Slide 11: Survey Question 2: What solutions are you leveraging for your Enterprise API layer?

    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

  12. Slide 12: SQL Standards remain popular for access data

    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

  13. Slide 13: Other popular use cases for virtual SQL access

    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

  14. Slide 14: Survey Question 3: Which of the following do you need SQL Access to?

    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

  15. Slide 15: Agenda

    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.

  16. Slide 16: Customized SQL Connectivity

    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

  17. Slide 17: Steps to Implement a Driver

    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

  18. Slide 18: OpenAccess can plug in to your enterprise security

    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.

  19. Slide 19: Translating between SQL and REST

    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.

  20. Slide 20: SQL Support

    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

  21. Slide 21: A large Financial Company is using OpenAccess for ODBC, JDBC Access

    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

  22. Slide 22: Agenda

    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.

  23. Slide 23: Demo

    Slide 23: Demo

    Demo

  24. Slide 24: Agenda

    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.

  25. Slide 25: Best Practices: Support Multiple APIs – ODBC, JDBC, ADO.NET

    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

  26. Slide 26: Best Practices: Authentication

    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

  27. Slide 27: Best Practices: How to create data model from APIs

    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

  28. Slide 28: Best Practices: Optimize Query Performance

    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

  29. Slide 29: Next Steps

    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

  30. Slide 30: Progress

    Slide 30: Progress

    Dv Progress’

Source: Internet Archive copy of progress.com

More decks from Progress Software Corporation

All 69 Progress Software decks