Progress Software Corporation · NASDAQ:PRGS
Progress Software — Conference Presentation (2018)
30 slides from Progress Software's conference presentation, 2018

Slide 1: Journey to SAS Analytics Grid with SAS, R, Python
Journey to SAS Analytics Grid with SAS, R, Python Benjamin Zenick Chief Operating Officer Zencos Sumit Sarkar Chief Data Evangelist Progress DataDirect

Slide 2: Agenda
Agenda ▪ Differences between traditional and Grid deployments for SAS ▪ Best practices and lessons learned in deploying an Analytics Grid ▪ How to deliver an open analytics strategy for SAS, R, Python and others ▪ Popular data sources for advanced analytics © 2018 Progress Software Corporation and/o

Slide 3: Differences between traditional and Grid deployments for SAS
Differences between traditional and Grid deployments for SAS © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 3

Slide 4: The Evolution of Analytics
The Evolution of Analytics Businesses started with large and expensive central mainframes – Mainframes were limited by early storage and processing technology – Connectivity and user interfaces to data were limited by “dumb” terminals – Expansion was limited by proprietary chassis design – Connectin

Slide 5: Analytics Today
Analytics Today • Modernization moved away from Mainframes • Moved toward server / client solutions, workstations, storage appliances, and networking • Shortcoming of centralized datacenters: Administrative and Performance Bottlenecks

Slide 6: Example of Traditional Deployment
Example of Traditional Deployment

Slide 7: What benefits do grid deployments provide?
What benefits do grid deployments provide? • Standardization supporting multiple ecosystems • Streamline Administrative support • Better tools for analytics and administration • Centralizing and improving management • Size & Scalability

Slide 8: Example of Grid Deployment
Example of Grid Deployment Grid Analytical Platform

Slide 9: Signs your organization is ready to consider an HPC or Grid solution
Signs your organization is ready to consider an HPC or Grid solution… • Decrease in cost benefits • Current model doesn’t scale well • Massively Parallelized Processing • Administrative needs continue to grow and grow • High(er) Availability is possible • Faster (Disaster) Recovery Zencos capabiliti

Slide 10: Top Considerations for Modernization
Top Considerations for “Modernization” • Why? • Who? • What? • Where? • When?

Slide 11: Best practices and lessons learned in deploying an Analytics Grid
Best practices and lessons learned in deploying an Analytics Grid © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 11

Slide 12: Best Practices
Best Practices • Preparation • Technologies • Plan • Time • Expectations • Team • Transition • Users • Support • Goal Alignment

Slide 13: Lessons Learned
Lessons Learned • Invest in a meaningful assessment • Plan to purchase and build Test and Disaster Recovery environments • Understand the applications and use cases • Outline support model for legacy projects • Consider your post-implementation needs • Expect the unexpected

Slide 14: How to deliver an open analytics strategy for SAS, R, Python and others
How to deliver an open analytics strategy for SAS, R, Python and others © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 14

Slide 15: SAS and Open Analytics across …
SAS and Open Analytics across … SAS (open data access and grid SAS Viya SAS Grid Manager management for native language support) 15 ©© 2018 Progress 2016 Software Progress Corporation Software Corporationand/or and/oritsitssubsidiaries subsidiariesororaffiliates. affiliates.AllAllrights rightsreserv

Slide 16: SAS Grid Manager
SAS Grid Manager Image from SAS webinar: https://www.evensi.us/webinar-taking-r-and-python-from-good-to- great-with-sas-/204358443 16 ©© 2018 Progress 2016 Software Progress Corporation Software Corporationand/or and/oritsitssubsidiaries subsidiariesororaffiliates. affiliates.AllAllrights rightsrese

Slide 17: SAS with Open Data Access (ODBC)
SAS with Open Data Access (ODBC) ▪ Access external data using supported access modes using data source specific SAS/Access interfaces. ▪ Leverage generic SAS/Access interface to ODBC with an open ODBC driver for direct access from Python and R. 17 ©© 2018 Progress 2016 Software Progress Corporation

Slide 18: SAS and Open Analytics | SAS Grid (Open Data Access via ODBC)
SAS and Open Analytics | SAS Grid (Open Data Access via ODBC) Open Grid Manager Analytics Grid Controller Workers RDBMS, Big Data, NoSQL, Cloud Access data sources over TCP or HTTPS ODBC Open Data Access 18 ©© 2018 Progress 2016 Software Progress Corporation Software Corporationand/or and/oritsitssu

Slide 19: R ODBC Example
R ODBC Example library(RODBC) # Make a connection using your DSN name conn <- odbcConnect("Spark Next") # Execute a SQL Tables call sqlTables(conn) # Execute a SQL columns call on the table with our energy data sqlColumns(conn, "energyconsumption") # Bind the results of a SQL query for plotting data

Slide 20: Python ODBC Example
Python ODBC Example import pyodbc import getpass import sys def show_odbc(): sources = pyodbc.dataSources() dsns = sources.keys() sl = [] i=1 for dsn in dsns: sl.append( str(i) + '. %s' % (dsn)) i= i+1 print('\n'.join(sl)) return dsns def listTables(cursor): for row in cursor.tables(): print row.tab

Slide 21: DataDirect ODBC is engineered for GRID and Cloud
DataDirect ODBC is engineered for GRID and Cloud ▪ Deliver advanced functionality over OSS to become SAS OEM Partner ▪ Run 85+ million QA tests on our suite of connectors ▪ Performance labs measure throughput and resource utilization (CPU and memory) ▪ Focus on security features for customers to ach

Slide 22: Popular data sources for advanced analytics
Popular data sources for advanced analytics 22 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 23: Popular Relational/Analytics Data Sources
SQL Server 18.70% Popular Relational/Analytics Oracle 12.89% Data Sources MySQL 12.77% Progress OpenEdge 7.93% PostgreSQL 5.65% Microsoft SQL Azure 5.27% IBM DB2 4.76% SQLite 3.68% Teradata 2.61% SAP HANA 2.30% MariaDB 2.25% Sybase ASE 1.92% Amazon Redshift 1.79% Informix 1.64% Sybase IQ 1.30% Netez

Slide 24: Popular Big Data Sources
Popular Big Data Sources Hadoop Hive 18.53% Spark SQL 8.17% Hortonworks 7.97% Cloudera CDH 7.87% Cloudera Impala 7.47% Apache Solr 7.37% Oracle BDA 6.67% Amazon EMR 5.98% Apache Sqoop 5.48% MapR 5.38% IBM BigInsights 4.68% Apache Storm 4.08% Apache Drill 2.39% Apache Phoenix 2.39% SAP Altiscale 2.19

Slide 25: Popular NoSQL Sources
Popular NoSQL Sources MongoDB 35.60% Cassandra 14.57% HBase 10.34% Oracle NoSQL 9.01% Redis 8.45% Other (please specify): 6.01% Couchbase 5.78% DynamoDB 2.78% DataStax Enterprise 2.22% SimpleDB 2.22% MarkLogic 1.67% Aerospike 0.78% Riak 0.56% 25 ©© 2018 Progress 2016 Software Progress Corporation So

Slide 26: What about SaaS?
What about SaaS? Data Source API Eloqua Web Services API (REST/SOAP) Bulk and non-Bulk APIs No query language Oracle Service Cloud Web Services APIs (REST/SOAP) ROQL Google Analytics Hypercube (query limits of 10 metrics grouped by max of 7 dimensions) Veeva CRM SOAP, BULK, Metadata APIs SOQL 26 ©©

Slide 27: Supported ODBC Data Sources for SAS/Access
Blue text indicates cloud hosted Blue text* indicates cloud hosted with on-premises option Supported ODBC Data Sources for SAS/Access Apache Hadoop Hive 0.8.0 and higher Microsoft SQL Server 2012 Amazon EMR 2.1.4 and higher Microsoft SQL Server 2008 R1, R2 Amazon Redshift Microsoft SQL Server 2005 A

Slide 28: NEW cross data center access for SAS/Access interface to ODBC (over https)
NEW cross data center access for SAS/Access interface to ODBC (over https) SAS/Access interface to ODBC 28 ©© 2018 Progress 2016 Software Progress Corporation Software Corporationand/or and/oritsitssubsidiaries subsidiariesororaffiliates. affiliates.AllAllrights rightsreserved reserved.

Slide 29: Wrap Up with Q&A
Wrap Up with Q&A Slides and recording will be made available to each attendee Visit www.datadirect.com to learn more about ODBC drivers engineered for analytics Please enter your questions in the chat... © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

Slide 30: Dv 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