My queries on External Objects from within Salesforce are case sensitive, making searches where case sensitivity is undesired difficult. Can I use case insensitive search with Heroku Connect?
Unfortunately, there really is no way to do this when using External Objects with Heroku Connect.
Here is an example of how this might be worked around when using OData directly.
eq operator is intended to results that match case-sensitive strings. In order for a query to be case-insensitive, one can use
toupper in order to normalize the text.
/opportunities?$filter=tolower(Name) eq tolower('My Opportunity')
This would match Opportunity records with a
Name of "My Opportunity", "MY OPPORTUNITY" or "my opportunity".