Progress Software Corporation · NASDAQ:PRGS

Progress Software — Progress DataDirect + Google BigQuery webinar (November 2019)

32 slides from Progress Software's conference presentation, Nov 21, 2019

  1. Slide 1: Progress DataDirect + Google BigQuery: Accelerate Your Data Warehousing and BI Initiatives

    Slide 1: Progress DataDirect + Google BigQuery: Accelerate Your Data Warehousing and BI Initiatives

    Progress DataDirect + Google BigQuery: Accelerate Your Data Warehousing and BI Initiatives November 21, 2019 Dipak James Patel Goodfellow Dir of Product Product Marketing Management Manager

  2. Slide 2: GoToWebinar: Q&A

    Slide 2: GoToWebinar: Q&A

    GoToWebinar: Q&A ▪ Submit your questions & comments using the Questions panel at any time during the webinar © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 2

  3. Slide 3: The Evolution of Data Warehousing

    Slide 3: The Evolution of Data Warehousing

    The Evolution of Data Warehousing • Limited sphere of applications, tools and data marts • On-premises, appliance-based warehouse architecture • Connectivity generally wire- based using ODBC and JDBC. © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 3

  4. Slide 4: A Traditional Data Warehouse Approach

    Slide 4: A Traditional Data Warehouse Approach

    A Traditional Data Warehouse Approach *courtesy of SQLHammer.com © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 4

  5. Slide 5: Emergence of the Cloud Data Warehouse

    Slide 5: Emergence of the Cloud Data Warehouse

    Emergence of the Cloud Data Warehouse • Modernize • Scalable • Cost-Effective • Require Far Less Time & Effort © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 5

  6. Slide 6: The Cloud Approach to Data Warehousing

    Slide 6: The Cloud Approach to Data Warehousing

    The Cloud Approach to Data Warehousing *courtesy of SQLHammer.com © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 6

  7. Slide 7: Cloud Data Warehouse Challenges

    Slide 7: Cloud Data Warehouse Challenges

    Cloud Data Warehouse Challenges • Speed of Data Access • Query and Reporting Functionality • Security © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 7

  8. Slide 8: Progress DataDirect Driver for Google BigQuery

    Slide 8: Progress DataDirect Driver for Google BigQuery

    Progress DataDirect Driver for Google BigQuery • Greater Connectivity and Functionality • Faster Speed of Access • Enhanced Security © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 8

  9. Slide 9: Google BigQuery Driver in Action

    Slide 9: Google BigQuery Driver in Action

    Google BigQuery Driver in Action © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 9

  10. Slide 10: Use Cases for Google BigQuery JDBC and ODBC Drivers

    Slide 10: Use Cases for Google BigQuery JDBC and ODBC Drivers

    Use Cases for Google BigQuery JDBC and ODBC Drivers

  11. Slide 11: Definition of JDBC

    Slide 11: Definition of JDBC

    Definition of JDBC Java™ database connectivity (JDBC) is the JavaSoft specification of a standard application programming interface (API) that allows Java programs to access database management systems. The JDBC API consists of a set of interfaces and classes written in the Java programming language

  12. Slide 12: Definition of ODBC

    Slide 12: Definition of ODBC

    Definition of ODBC The Microsoft Open Database Connectivity (ODBC) interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). ODBC is a low-level, high-performance interface to connect to databases, se

  13. Slide 13: Batch Data With Apache NiFi

    Slide 13: Batch Data With Apache NiFi

    Batch Data With Apache NiFi JDBC © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 13

  14. Slide 14: © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

    Slide 14: © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.

    © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 14

  15. Slide 15: Configure Controller for GBQ

    Slide 15: Configure Controller for GBQ

    Configure Controller for GBQ © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 15

  16. Slide 16: Configure Processor

    Slide 16: Configure Processor

    Configure Processor © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 16

  17. Slide 17: AWS Glue – Similar to nifi

    Slide 17: AWS Glue – Similar to nifi

    AWS Glue – Similar to nifi JDBC JDBC JDBC © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 17

  18. Slide 18: Progress Corticon Digital Decisioning: Read/Write Facts and Data

    Slide 18: Progress Corticon Digital Decisioning: Read/Write Facts and Data

    Progress® Corticon® Digital Decisioning: Read/Write Facts and Data JDBC REST/JSON API using Business Rules ARC connector (read only) MS DYNAMICS CRM using REST/OData JDBC connector (full CRUD) JDBC ANY DATABASE via DCI JDBC connectors (full CRUD) © 2018 Progress Software Corporation and/or its subsi

  19. Slide 19: Easily Access Public and Commercial Datasets

    Slide 19: Easily Access Public and Commercial Datasets

    Easily Access Public and Commercial Datasets © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 19

  20. Slide 20: Accessing American Community Survey Data

    Slide 20: Accessing American Community Survey Data

    Accessing American Community Survey Data What is the difference in median income in Brooklyn by Census tract from 2010 to 2017? WITH acs_2017 AS ( SELECT geo_id, median_income AS median_income_2017 FROM `bigquery -public- `bigquery-public- data.census_bureau_acs.censustract_2017_5yr` data.census_bur

  21. Slide 21: Google BigQuery Console

    Slide 21: Google BigQuery Console

    Google BigQuery Console © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 21

  22. Slide 22: Progress Corticon Architecture

    Slide 22: Progress Corticon Architecture

    Progress Corticon Architecture JDBC © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 22

  23. Slide 23: Interesting Questions Your Apps Can Ask

    Slide 23: Interesting Questions Your Apps Can Ask

    Interesting Questions Your Apps Can Ask ▪ What countries have the longest life expectancy? ▪ Which countries have the largest proportion of their population under 25? Over 40% of the world’s population is under 25 and greater than 50% of the world’s population is under 30! ▪ Which countries are seei

  24. Slide 24: Commercial Datasets

    Slide 24: Commercial Datasets

    Commercial Datasets © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 24

  25. Slide 25: Streaming Data Ingestion

    Slide 25: Streaming Data Ingestion

    Streaming Data Ingestion User Events IOT © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 25

  26. Slide 26: Key Features of Kafka

    Slide 26: Key Features of Kafka

    Key Features of Kafka ▪ Scalability ▪ High-Volume ▪ Data Transformations ▪ Fault Tolerance ▪ Reliability ▪ Durability ▪ Performance ▪ Zero Downtime ▪ Extensibility • There are many ways by which applications can plug in and make use of Kafka. In addition, Kafka offers ways to write new connectors as

  27. Slide 27: Kafka Connect for JDBC

    Slide 27: Kafka Connect for JDBC

    Kafka Connect for JDBC JDBC JDBC © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 27

  28. Slide 28: Configuring Kafka Connect

    Slide 28: Configuring Kafka Connect

    Configuring Kafka Connect It is driven purely by configuration files, providing an easy integration point for developers { "name": "jdbc_source_GoogleBigQuery_foobar_01", "config": { "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector” "connection.url": "jdbc:datadirect:googlebigquery:

  29. Slide 29: Accessing GBQ from 3rd Party Application

    Slide 29: Accessing GBQ from 3rd Party Application

    Accessing GBQ from 3rd Party Application ODBC or JDBC Your Application Examples, can be a BI tool, Programming Languages for ML or Strategic OEM Partner’s tool etc., © 2018 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 29

  30. Slide 30: Unleash the Power of GBQ from your Apps

    Slide 30: Unleash the Power of GBQ from your Apps

    Unleash the Power of GBQ from your Apps ▪ Plug-and-play with any JDBC or ODBC compliant application ▪ High performing, efficient, secure, and reliable ▪ Extend your application to leverage a data warehouse with lots of readily available data and AI/ML with very little effort © 2018 Progress Software

  31. Slide 31: Questions?

    Slide 31: Questions?

    Questions? © 2019 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 31

  32. Slide 32: Progress

    Slide 32: Progress

    Dv Progress’

Source: Internet Archive copy of progress.com

More decks from Progress Software Corporation

All 69 Progress Software decks