Progress Software Corporation · NASDAQ:PRGS

Progress Software — Technical Presentation (2019)

45 slides from Progress Software's technical presentation, Sep 29, 2019

  1. Slide 1: High-Performing Salesforce Connectors

    Slide 1: High-Performing Salesforce Connectors

    High-Performing Salesforce Connectors Nishanth Kadiyala Avadhoot Kulkarni Product Marketing Product Engineering, Manager Product Owner

  2. Slide 2: Audio Bridge Options & Question Submission

    Slide 2: Audio Bridge Options & Question Submission

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

  3. Slide 3: Agenda

    Slide 3: Agenda

    Agenda  Overview of Salesforce Connector  SQL vs SOQL vs SAQL  Anatomy of a Salesforce Connector  Build vs Buy  Demo © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 3

  4. Slide 4: Overview of Salesforce Connector

    Slide 4: Overview of Salesforce Connector

    Overview of Salesforce Connector © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 4

  5. Slide 5: Salesforce is the #1 CRM

    Slide 5: Salesforce is the #1 CRM

    Salesforce is the #1 CRM  FY18 Stats: 2 1 • 150,000+ Customer • FY18 Revenue: $10.5B (25% YoY)  Projections: 3 • FY19 Revenue: $13B+ • FY 22 Revenue: $20B+ Source 1: https://www.salesforce.com/campaign/worlds-number-one-CRM/ Source 2: https://expandedramblings.com/index.php/salesforce-statistics/

  6. Slide 6: Sample Salesforce Workflow

    Slide 6: Sample Salesforce Workflow

    Sample Salesforce Workflow Source: https://www.crmevangelist.com/2017-05-30_11-55-32/ © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 6

  7. Slide 7: Source: http://www.cubiccompass.com/blog

    Slide 7: Source: http://www.cubiccompass.com/blog

    © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 7 Source: http://www.cubiccompass.com/blog

  8. Slide 8: Built-in Reporting and Analytics

    Slide 8: Built-in Reporting and Analytics

    Built-in Reporting and Analytics  Capabilities: • Reporting on sales pipeline • Providing a snapshot of sales and operational data • Quantifying customer inquiry requests  Challenges: • Display limitations of rows of data in reports • Limited cross-object reporting capabilities • Difficulties in p

  9. Slide 9: Why Salesforce Data Connector?

    Slide 9: Why Salesforce Data Connector?

    Why Salesforce Data Connector? Enterprise Analytics ETL Big Data Complex Queries Data Integration App Integration © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 9

  10. Slide 10: Source: Ice Age

    Slide 10: Source: Ice Age

    Source: Ice Age © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 10

  11. Slide 11: Source: Ice Age

    Slide 11: Source: Ice Age

    Source: Ice Age © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 11

  12. Slide 12: SQL vs SOQL / SAQL

    Slide 12: SQL vs SOQL / SAQL

    SQL vs SOQL / SAQL © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 12

  13. Slide 13: SQL vs SOQL vs SAQL

    Slide 13: SQL vs SOQL vs SAQL

    SQL SOQL SAQL • SQL is a universal • SOQL is Salesforce’s • SAQL works only within language proprietary query language Wave / Einstein analytics platform • Supported by all popular • Supported only in the analytics tools Salesforce ecosystem: • Supported through Apex, SFDC REST API, Analytics REST A

  14. Slide 14: SOQL capabilities

    Slide 14: SOQL capabilities

    SOQL capabilities  SOQL is a SELECT-like query language for accessing objects  Field selection  Filters  Limited joins  Limited Group Bys  Aggregates  Order By © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 14

  15. Slide 15: Filters

    Slide 15: Filters

    Filters SQL SOQL Multi-select picklists Use equivalent string functions …FROM Account WHERE MenuItem = ‘AAA’ …FROM Account WHERE MenuItem != ‘AAA’ …FROM Account WHERE MenuItem includes ‘AAA’ …FROM Account WHERE MenuItem excludes ‘AAA’ …FROM Account WHERE MenuItem = ‘AAA;BBB’ Allows specifying timest

  16. Slide 16: Joins

    Slide 16: Joins

    Joins SQL SOQL Joins across any tables or objects SQL allows JOINs of all kinds SOQL only allows joins on foreign These examples use a foreign key keys through relationship queries SELECT * FROM Account A This is achieved through either dot INNER JOIN Contacts C on A.ID notation following child-to-p

  17. Slide 17: Aggregates, Group By, Order By

    Slide 17: Aggregates, Group By, Order By

    Aggregates, Group By, Order By SQL SOQL Supports Aggregates, Group By, SELECT SUM(Amount), Order By FiscalQuarter, Probability Similar to SQL FROM Opportunity GROUP BY FiscalQuarter, Probability Unlimited Aggregation SELECT SUM(Amount), SOQL does not allow a query FiscalQuarter, Probability containi

  18. Slide 18: Inserts, Updates, Deletes

    Slide 18: Inserts, Updates, Deletes

    Inserts, Updates, Deletes SQL SOQL Syntax for DML operations Full CRUD support In Salesforce, Insert, Update and Delete operations are performed through APIs Writes in single operation SQL simplifies the process as For updates and deletes, a a single query can modify the SOQL query must be used to d

  19. Slide 19: Source: Ice Age

    Slide 19: Source: Ice Age

    Source: Ice Age © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 19

  20. Slide 20: Anatomy of a Salesforce SQL Connector

    Slide 20: Anatomy of a Salesforce SQL Connector

    Anatomy of a Salesforce SQL Connector © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 20

  21. Slide 21: Why SQL – Go Generic

    Slide 21: Why SQL – Go Generic

    Why SQL – Go Generic  If you have app which need to connect to multiple sources • Flexibility • Scale  Providing Salesforce connectivity to your customers • The kind of operations and queries scale very fast • No two use cases are exactly same © 2019 Progress Software Corporation and/or its subsid

  22. Slide 22: Popular options for SQL access to Salesforce

    Slide 22: Popular options for SQL access to Salesforce

    Popular options for SQL access to Salesforce Direct SQL Access Indirect SQL Access  Progress DataDirect ODBC  Extract data using Salesforce and JDBC drivers for direct data loader, or other third- SQL connectivity party tools, into an  [Download] bit.ly/SQL2SF intermediate RDBMS app © 2019 Progre

  23. Slide 23: DataDirect architecture for direct SQL access to Salesforce

    Slide 23: DataDirect architecture for direct SQL access to Salesforce

    DataDirect architecture for direct SQL access to Salesforce Your Application User Defined Schema Driver uses Progress DataDirect ODBC/JDBC  SOAP API Connectors Salesforce.com  Bulk API Schema Manager Schema  Metadata API © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.

  24. Slide 24: Components of SQL Connector to Salesforce

    Slide 24: Components of SQL Connector to Salesforce

    Components of SQL Connector to Salesforce Schema SQL Engine Limits Security Performance Manager • SQL Translation • Normalization • Paging • Encryptions • Bulk vs Non- Bulk • Resultset • Metadata • Throttling • Authentications Shaping Information • Result Caching • Idle Session • Proxy • Local • Loc

  25. Slide 25: Building Contextual Relational Mapping

    Slide 25: Building Contextual Relational Mapping

    Building Contextual Relational Mapping Winding • All Complex field become child objects Unwinding • Complex field get promoted to become parent fields Flattening • Convert to Comma separated values string JSONify • Too complex to normalize, map as JSON type © 2019 Progress Software Corporation and/o

  26. Slide 26: Exposing Metadata & Connector Capabilities

    Slide 26: Exposing Metadata & Connector Capabilities

    Exposing Metadata & Connector Capabilities ODBC JDBC • SQLTables • getTables • SQLColumns • getColumns • SQLProcedure • getProcedures s (reports) • Database • GetInfo Metadata • ... • ... © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 26

  27. Slide 27: Supporting Local Objects

    Slide 27: Supporting Local Objects

    Supporting Local Objects • Stores temp results for transformation • Fast performance Memory Tables • Accessible for the same connection scope • Persisted Temp tables Disk • Can be accessed across connections (same schema map) Tables • Cache Information • Usage Information (Sessions, API Calls) Syste

  28. Slide 28: Adding SQL Engine Capabilities

    Slide 28: Adding SQL Engine Capabilities

    Adding SQL Engine Capabilities SQL Local Optimizations Translation Processing © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 28

  29. Slide 29: Handling Limits & Exceptions

    Slide 29: Handling Limits & Exceptions

    Handling Limits & Exceptions Result Paging Session Re-auth API Throttling Error Code Mapping © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 29

  30. Slide 30: Security Considerations

    Slide 30: Security Considerations

    Security Considerations Encryptions • TLS 1.2 Authentication Proxy • User ID • HTTP Forward • OAuth 2.0 Proxy • SSO © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 30

  31. Slide 31: Performance

    Slide 31: Performance

    Performance  Bulk vs Non-Bulk • Bulk is not always performant. As its name suggests its only for bulk job.  Intelligence should be in the connector to decide what is the most optimal way to complete the user request.  Result Caching • Cache results whenever required and fetch incrementally to fur

  32. Slide 32: Build vs Buy

    Slide 32: Build vs Buy

    Build vs Buy © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 32

  33. Slide 33: Faster time to Market

    Slide 33: Faster time to Market

    Faster time to Market © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 33

  34. Slide 34: Day-1 Support Policy

    Slide 34: Day-1 Support Policy

    Day-1 Support Policy © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 34

  35. Slide 35: Enterprise-ready Connectors Built by Experts

    Slide 35: Enterprise-ready Connectors Built by Experts

    Enterprise-ready Connectors Built by Experts © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 35

  36. Slide 36: Security Vulnerability Policy

    Slide 36: Security Vulnerability Policy

    Security Vulnerability Policy PRIORITY* TIME GUIDELINE VERSION(S) High Risk Active (i.e. latest (CVSS 8+ or industry 30 days shipping version) and equivalent) all Supported versions Medium Risk Active (i.e. latest (CVSS 5-to-8 or 180 days shipping version) industry equivalent) Low Risk Next major re

  37. Slide 37: Trusted Partner for All Connectivity Challenges

    Slide 37: Trusted Partner for All Connectivity Challenges

    Trusted Partner for All Connectivity Challenges © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 37

  38. Slide 38: Mission

    Slide 38: Mission

    8 of the 9 Leading BI vendors embed DataDirect drivers. Mission: To give Enterprises and ISVs 96 of Fortune 100 frictionless access to the information Enterprises leverage our connectivity solutions they need by harmonizing access to the world’s disparate data. 350+ ISVs distribute DataDirect driver

  39. Slide 39: Expansive List of DataDirect Connectors

    Slide 39: Expansive List of DataDirect Connectors

    Expansive List of DataDirect Connectors Big Data/NoSQL Relational SaaS/Cloud EDI/XML/Text • Apache Hadoop Hive • Aurora • Google Analytics • EDIFACT • Cloudera • Clipper • IBM DashDB • EDIG@S • Hortonworks • dBase • IBM DB2 Hosted • EANCOM • MapR • EnterpriseDB • Salesforce.com • X12 • EMR • IBM DB2

  40. Slide 40: Source: Ice Age

    Slide 40: Source: Ice Age

    Source: Ice Age © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 40

  41. Slide 41: Demo

    Slide 41: Demo

    Demo © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 41

  42. Slide 42: Bulk Fetch: Throughput Comparison

    Slide 42: Bulk Fetch: Throughput Comparison

    Bulk Fetch : Throughput Comparision  8.0 is 300% faster compared to 7.1 for 400K records.  Scales better with large data.  Better optimized for multi-threaded applications. © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 42

  43. Slide 43: Resources

    Slide 43: Resources

    Resources  Downloads: https://www.progress.com/connectors/salesforce  Tutorials: • ODBC – https://www.progress.com/blogs/sas-odbc-access-to-salesforce-sql-server-and-marketo – https://www.progress.com/blogs/python-connectivity-to-salesforce-eloqua-or-google • JDBC – https://www.progress.com/tutori

  44. Slide 44: QnA

    Slide 44: QnA

    QnA © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 44

  45. Slide 45: Progress

    Slide 45: Progress

    Dv Progress’

Source: Internet Archive copy of progress.com

More decks from Progress Software Corporation

All 69 Progress Software decks