You can get your Database URL using either Heroku CLI or from your Heroku dashboard.
heroku config:get DATABASE_URL -a <your_heroku_app_name>
NOTE: Disabling server certificate validation opens a serious security hole by allowing man in the middle attacks. This is likely acceptable for test environments, but it is highly recommended that a server certificate issued by a recognized certificate authority be used in production environments.
We hope this tutorial helped you to get connected to your PostgreSQL database on Heroku. If you are looking to access your PostgreSQL database using a REST API (OData), you can check out Progress DataDirect Cloud. This enables you to access your database through a standards based REST API – OData. Try it for free!
Connect any data source to any application
Discussions, tips and tricks for
DataDirect Connect drivers
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.