We have an external database set up in Heroku using postgres. I would like to be able manage some data from the heroku postgres database in salesforce. I have configured salesforce connect with the OData 4.0 connection that is provided by Heroku, but I have some issues with it.
I want to view the records in lightning but salesforce only allows me to view the records in salesforce classic. From other youtube tutorials that I have seen, others have been able to view their external records in lightning but have not shown nor explained what they did.
I am unable to edit any of the records whether through classic or apex. I read this documentation that said it can be enabled but I do not have the options when setting up the external objects. https://help.salesforce.com/s/articleView?id=sf.platform_connect_considerations_writable_external_objects.htm&type=5. I have read/write access from heroku so I should be able to update the records I believe. I have a salesforce connect license and my account manager said it should not be a licensing permission issue.
Am I going about this the wrong way? Is all of this supposed to come out of the box or do I have to set up my own process for updating external object records and viewing them in lightning?