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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

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

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

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

Slide 32: 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