• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Applications Questions

Tiago Esperanca

started a topic over 3 years ago

Connecting to Heroku Postgresql Database using OPA

A common use case for companies using Salesforce is the use of Heroku Connect to to perform Data Replication from their Salesforce instance. This data can then be used for any other purposes, for example as input to your Workato recipes.


While the Workato Postgresql cloud connector connects seamlessly with Heroku Postgresql, currently some more advanced actions require the OPA agent to be utilised. E.g., the "Run Custom SQL" action:

Postgresql Custom SQL Action


As per Heroku's Postgresql documentation, SSL is required to secure your connection, otherwise you might run into errors like:

OPC Error: FATAL: no pg_hba.conf entry for host "<your OPA IP Address>", user ...


While SSL is enabled on the cloud connector, it needs to be manual setup on your OPA config.yaml file, like in the excerpt below:


...

  postgre_db:

    url: jdbc:postgresql://<db url>/<db name>

    username: <user>

    password: <pwd>

    ssl: true

    sslfactory: org.postgresql.ssl.NonValidatingFactory

...

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count