dci-transparent-bg

Powerful Connectivity to PostgreSQL Data

Complete

Fully standards compliant connectivity to PostgreSQL

Fast

Outperforms other drivers in throughput, CPU utilization and memory usage

Powerful

Enterprise-level features including high availability and bulk data loading

PostgreSQL

Connect to PostgreSQL via

ODBC JDBC OData

Features

Fast

High-performance data loading built-in

Secure

Includes robust SSL data encryption and user authentication

Robust

Ensure high availability via application failover and workload balancing without changing application code

Enterprise Features

Advanced connection pooling with transparent reconnections, and robust data type support such as Blob/Clob and timestamp

Easy

True standards compliance with ODBC and JDBC

Versatile

Supported on every major platform and certified to work with leading applications such as Tableau, Informatica, Cognos, Business Objects and more

Security Vulnerability Response Policy

Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy:

Priority* Time Guideline Version(s)
High Risk
(CVSS 8+ or industry equivalent)
30 days Active (i.e. latest shipping version) and all Supported versions
Medium Risk
(CVSS 5-to-8 or industry equivalent)
180 days Active (i.e. latest shipping version)
Low Risk
(CVSS 0-to-5 or industry equivalent)
Next major release or best effort Active (i.e. latest shipping version)

* Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.

Learning & Support

Blog

Tutorial: Connecting to Heroku PostgreSQL via DataDirect

​In this tutorial, learn how to build out seamless connections between Heroku PostgreSQL data and the rest of your analytics infrastructure.

Read More

Blog

RESTify Databases: Expose Your Database with a REST API

Expose your relational & big data databases as RESTful services via the OData Standard using clicks, not code. Democratizing your data is now a matter of days.

Read More

Video

DataDirect Hybrid Data Pipeline: Overview

The Progress DataDirect Hybrid Data Pipeline is a lightweight data access platform that you can install either in the cloud or behind your firewall. It provides simple, secure access to your cloud and on-premises data sources for your business intelligence tools and applications. You maintain complete control over the platform and its connectivity to the data sources and applications in your specific business environment.

This video takes a brief look at the connectivity challenges created when a wide variety of data types and applications reside in different environments, then demonstrates how the Data Pipeline addresses those challenges.

Watch Video

Success Story

Vertex

With more than 30 years of experience, Vertex® Inc., is the leading provider of enterprise corporate tax solutions and process management services worldwide. Founded in 1978, Vertex is a privately held company that employs more than 600 professionals at its headquarters in the U.S. (Berwyn, PA) and offices across the country and in Europe.

Learn More

Success Story

UZ Leuven

UZ Leuven, one of Belgium’s largest hospitals, needed a efficient complex data migration from multiple sources to be shared across 200 applications and multiple facilities. Using Progress® DataDirect® OpenAccess their IT team was able to create a database emulation layer that made it possible to pre-configure and test database integration with DB2 on all 200 applications.

Learn More

Tutorial

Querying External Data from PostgreSQL Using JDBC FDW

Read Tutorial 

Tutorial

Connect to PostgreSQL on Heroku Using ODBC and JDBC Drivers

Read Tutorial 

Webinar

Deliver Secure SQL Access for Enterprise APIs

Companies typically build numerous internal applications and complex APIs for enterprise data access. These APIs are often engineered for application developers and based on protocols such as REST or SOAP with payloads in XML or JSON.

However, enterprise data teams need to access this data for analytics, which requires standard query capabilities and the ability to surface metadata. As enterprises adopt new analytical and data management tools, a SQL access layer for this data becomes imperative. Many industries such as financial services, healthcare and technology rely on Progress® DataDirect® OpenAccess™ SDK to build a custom ODBC, JDBC, ADO.NET or OLE DB layer on top of their internal APIs and hosted multi-tenant databases.

Watch this on-demand webinar to learn about:

  • Use cases for providing SQL access to your enterprise data
  • How organizations provide SQL Access to their APIs
  • Pitfalls and best practices to building SQL access

Plus—don’t miss our live demo using OpenAccess SDK to provide SQL access for a REST API.

Watch Webinar

Webinar

Making the Leap: Best Practices for Connecting to Your Cloud Data Warehouse

Companies are relying more and more on cloud-based data warehousing as a solution to some of the critical needs of today’s digital business world. See how Progress DataDirect Connectors for Cloud Data Warehouses can help you access and analyze the data from cloud data warehouses at the speed of business.

 

 

Watch Webinar

Paper

Deliver Secure SQL Access for Enterprise APIs: For Enterprise Architects and ISVs

IT needs a fast way to SQL-enable their internal API layer for business intelligence.

Organizations are investing heavily in API layers to control authentication and data access from one place. However, enterprise data teams can’t access this data from their favorite BI tools such as IBM Cognos, OBIEE, TIBCO or MicroStrategy without complex custom coding.

As companies adopt multiple analytical and data management tools, SQL access to the enterprise API layer (or data access layer) is crucial. The ideal solution enables you to quickly build real-time access to your API layer from popular BI tools, while taking advantage of centralized API management capabilities.

Download the whitepaper to learn:

  • How to how to quickly integrate your internal API layer into leading tools such as Microsoft Excel, SAP BusinessObjects, IBM Cognos, Oracle Business Intelligence and others
  • What to look for in a connector SDK for delivering SQL clients (ODBC, JDBC, ADO.NET and OLE-DB)
  • Steps to deliver custom SQL connectivity in under five days

Download Paper

Paper

Connect the Unconnectable: Enabling DevOps Dashboards for Siloed Data

A cross-enterprise view of the DevOps process is key to powering the continuous improvement of the software development lifecycle. In this ebook, you’ll discover how to connect key DevOps tools to your analytics and reporting tools to create a unified DevOps view that addresses four central themes: 

  • Planning and Roadmap
  • Epics, Velocity and Ticketing 
  • Continuous Improvement/Continuous Delivery 
  • Reporting and OKRs 
Work faster, save money and improve project visibility with a unified, cross-enterprise view of your DevOps process.  

Download Paper

Connect any application to any data source anywhere

A product specialist will be glad to get in
touch with you