AnsweredAssumed Answered

How Boomi ODATA API Filter works?

Question asked by sxyan320928 on Apr 26, 2018

Can someone tell whether the filter for OData API in Boomi is applied on database level or on Boomi server level?


Which means

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!