Mongo DB secondary node
Good day. I have a question regarding mongo DB connecion account. Is there a way to configure a secondary node? I mean, If I make the connection via connection string, the parameter name and value in that connection string are readPreference=secondary and I can configure the name of that node, but in account configuration in SnapLogic I cound’t find where to define that kind of parameters (if possible). Maybe if I use a generic JDBC account I could define those parameters but I’d like to use the standard mongo DB account. Thank you for your help.
Date filter in MongoDB snap
Hi, I am trying to filter the records from MongoDB Select snap using date filter but somehow it is not working. I am using below expression in condition. Please suggest if I am doing something wrong: {$and:[{“etl_date”:{$gte:“2019-05-15T00:00:00.000”}},{“etl_date”:{$lte:“2019-05-15T23:59:00.000”}}]} Thanks Aditya
MongoDB update snap converts numbers to strings on update and insert
Good Day everyone, I came across this issue when using the mongodb update snap, it seems on update and insert using the upsert setting (on update alone it still gives the issue), all number variables are converted to string in the mongodb database. Is there a fix to this issue? Thanks, Sachin,