Progress Software Corporation · NASDAQ:PRGS

Progress Software — Conference Presentation (2018)

30 slides from Progress Software's conference presentation, 2018

  1. Slide 1: Journey to SAS Analytics Grid with SAS, R, Python

    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

  2. Slide 2: Agenda

    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

  3. Slide 3: Differences between traditional and Grid deployments for SAS

    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

  4. Slide 4: The Evolution of Analytics

    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

  5. Slide 5: Analytics Today

    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

  6. Slide 6: Example of Traditional Deployment

    Slide 6: Example of Traditional Deployment

    Example of Traditional Deployment

  7. Slide 7: What benefits do grid deployments provide?

    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

  8. Slide 8: Example of Grid Deployment

    Slide 8: Example of Grid Deployment

    Example of Grid Deployment Grid Analytical Platform

  9. Slide 9: Signs your organization is ready to consider an HPC or Grid solution

    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

  10. Slide 10: Top Considerations for Modernization

    Slide 10: Top Considerations for Modernization

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

  11. Slide 11: Best practices and lessons learned in deploying an Analytics Grid

    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

  12. Slide 12: Best Practices

    Slide 12: Best Practices

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

  13. Slide 13: Lessons Learned

    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

  14. Slide 14: How to deliver an open analytics strategy for SAS, R, Python and others

    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

  15. Slide 15: SAS and Open Analytics across …

    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

  16. Slide 16: SAS Grid Manager

    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

  17. Slide 17: SAS with Open Data Access (ODBC)

    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

  18. Slide 18: SAS and Open Analytics | SAS Grid (Open Data Access via ODBC)

    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

  19. Slide 19: R ODBC Example

    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

  20. Slide 20: Python ODBC Example

    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

  21. Slide 21: DataDirect ODBC is engineered for GRID and Cloud

    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

  22. Slide 22: Popular data sources for advanced analytics

    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.

  23. Slide 23: Popular Relational/Analytics Data Sources

    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

  24. Slide 24: Popular Big Data Sources

    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

  25. Slide 25: Popular NoSQL Sources

    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

  26. Slide 26: What about SaaS?

    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 ©©

  27. Slide 27: Supported ODBC Data Sources for SAS/Access

    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

  28. Slide 28: NEW cross data center access for SAS/Access interface to ODBC (over https)

    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.

  29. Slide 29: Wrap Up with Q&A

    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.

  30. Slide 30: Dv Progress’

    Slide 30: Dv Progress’

    Dv Progress’

Source: Internet Archive copy of progress.com

More decks from Progress Software Corporation

All 69 Progress Software decks