I'm new to Heroku and I'm trying to wrap my head around with it and I have seen that in demo here talks about the exposing the services in Heroku and expose your services like this: http://orderdb.herokuapp.com/orders.svc

my question is: What do I need to do in order to expose the Service svc, do I have to write an application? or if you have postgreSQL then it will expose automatically by configuring? those are the answers I'm trying to find, appreciate any help!

  • another example of exposing oData service http://services.odata.org/Northwind/Northwind.svc/
    – Nick
    Apr 29, 2016 at 1:30
  • You will have to raise a case with Heroku Support and they will enable the heroku connect using which yuo can expose your postgres as oData service. They willl do that for the free accounts as well. Cheers!
    – Sam
    Apr 29, 2016 at 13:33

1 Answer 1


You will need Heroku Connect for your exposing Postgregs data as Odata Service .Heroku Connect offers out of box feature called Heroku external objects which can be used inside Lightning Connect .

Check these article links for more info



  • Thanks for the links and I have read those blogs and I have postgresql db in heroku but I'm unable to expose that as service to be more clear I have no idea how to expose postgresql db as oData service.
    – Nick
    Apr 29, 2016 at 1:22
  • Do you have Heroku connect in your Heroku instance ? Thats the first step .The second article clearly highlights you need to get Heroku external objects Apr 29, 2016 at 2:47
  • yes i do have heroku connect and heroku postgres db but how do i expose the odata service?
    – Nick
    Apr 29, 2016 at 2:54
  • OK this means you did not read article well enough. The article says once you have heruko external object enabled in main navigation you will be able to find settings to get external URL generated automatically. Please read the docs Apr 29, 2016 at 3:17
  • You should see external objects in main navigations .This will also have an endpoint for you. Apr 29, 2016 at 3:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .