How to Query MongoDB View in SSIS

Introduction

MongoDB introduced the view feature in version 3.4. View doesn't store actual data but it uses an aggregation pipeline to return the result. If you try ZappySys MongoDb Source (Direct Table or Query mode) then you might get the below error

QueryFailure flag was Namespace 5ddeb5xxxx_YourDB.SOMEVIEWNAME is a view, not a collection 
(response was { "$err" : "Namespace 5ddeb5xxxx.SOMEVIEWNAME is a view, not a collection"
, "code" : 166, "ok" : 0.0 }).

Solution

To avoid this error, just use the aggregate pipeline feature like below.

{Table: YOUR_MONGODB_VIEW_NAME,Method: aggregate}
{
  pipeline: 
  [
  ]
}

Contact Us

If you have more question(s) feel free to contact us via Live chat or email at [e-mail]

https://zappysys.com/support/