Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: MongoDB Input Query Instead of Entire Collection

  1. #1
    Join Date
    Nov 2006
    Posts
    14

    Question MongoDB Input Query Instead of Entire Collection

    Hi,

    I'm experimenting with the MongoDB input step. I'm wondering if anyone has configured a transformation to pull a query instead of retrieving an entire collection from Mongo. If anyone has done it, I'm looking for some pointers. I have scalability concerns with retrieving entire collections.

    Thanks,
    Sal

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Hey Sal,

    It's a fairly new step, please file a feature request in JIRA and I'll make sure it will get into the next (4.3) release.

    Matt

  3. #3
    Join Date
    Nov 2006
    Posts
    14

    Default

    Thanks!

  4. #4
    Join Date
    Jul 2009
    Posts
    4

    Default

    If u'r familiar with ruby, this step https://github.com/type-exit/Ruby-Scripting-for-Kettle
    will allow u to connect to mongo and query any data from it, even multiple collections, as well as update data there

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.