We have a rather typical requirement at a first glance - just to make bunch of records from external mysql database available in clients' sf orgs. And we are giving a short to SF External Object as an out-of-the-box solution for such use case.
The challenge here is that for each specific client's org we need to make available only a subset of records from that mysql table. We may say that we have 'orgId' column in that mysql table, and requirement is to let org see only its own records.
Is there any way to achieve this still with the help of external objects? Filtering objects on SF org side is not an option for us, cause it's sensitive data and they should not be accessible for other orgs at all, except the specified one.
Any help would be appreciated.