Tutorial: Connecting to Heroku PostgreSQL via DataDirect

Tutorial: Connecting to Heroku PostgreSQL via DataDirect

November 23, 2018 0 Comments
Tutorial Connecting to Heroku PostgreSQL via DataDirect_870x450

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

More and more developers are choosing to build their apps on the Heroku platform. Heroku’s fully-managed environment and native integration with PostgreSQL make it a perfect solution for many ISVs. We’ve created a tutorial to help users build out seamless connections between their Heroku Postgres data and the rest of their data and analytics infrastructure. 

What is Heroku and Why It Matters

Heroku is a Platform-as-a-Service (PaaS) based on AWS that companies use to develop and launch web applications. Developers increasingly prefer to use Heroku as it is simple to deploy, surprisingly flexible and effortlessly scalable to the needs of the application and business. One main benefit to users is that Heroku completely manages the infrastructure needs of the deployment, leaving the developers free to focus on the app!

PostgreSQL on Heroku

In addition to the fully-managed infrastructure that Heroku provides, developers can also opt for a fully managed Heroku PostgreSQL database deployment. This pairing makes sense given the recent rise in popularity of Postgres. PostgreSQL is open-source, feature-rich, and offers more operating system support options than other similar SQL databases.

Connecting Heroku to PostgreSQL via ODBC/JDBC Connectors

Once you’ve deployed your Heroku + Postgres environment, you’ll more than likely need to connect it to your other cloud and on-prem data sources and apps. Many businesses find that connecting this data in a simple, real-time manner can be difficult or time-consuming. My colleague Saikrishna Bobba has put together a fantastic, step-by-step tutorial to walk you through the process of building this link using Progress DataDirect ODBC and JDBC connectors. This will help you expose your Heroku app data to your BI, CRM, ERP systems and more!  

Take Me to the Tutorial

Or, download a trial driver to get started today: 

 ODBC Trial JDBC Trial

Reach out to us online with any questions or leave us a message in the comments below.

James Goodfellow

James Goodfellow

James Goodfellow is a Senior Product Marketing Manager at Progress and focuses his efforts on the DataDirect suite of solutions. Through his tenure at companies like Progress and SAS, he has spent the bulk of his career launching successful marketing campaigns for data and analytics products. James blogs here and around the web on topics such as data connectivity, analytics, IoT, visualization and machine learning. You can follow him on twitter at @jcgoodfellow.

Comments
Comments are disabled in preview mode.
Topics
 
 
Latest Stories in
Your Inbox
Subscribe
More From Progress
New_Mobile_Dev_Ebook_Progress_Website_Thumbail
The New Mobile Development Landscape
Download Whitepaper
 
IDC Spotlight Sitefinity Thumbnail
Choosing the Right Digital Experience Platform to Improve Business Outcomes
Download Whitepaper
 
TheFastestWayToBuildMobileAppsArtboard-2
The Fastest Way to Build Mobile Apps With Cloud Data
Watch Webinar