Can someone tell whether the filter for OData API in Boomi is applied on database level or on Boomi server level?
If on database level, that means the filter will transform to some SQL where clause which will limit the number of records return to Boomi.
If it is on Boomi server level, that means Boomi will read all records from database first and then apply the filter. Which potentially may have issue for large dataset.
Just want to understand how Boomi works and I can choose the proper solution. Thanks a lot!