Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How do I get a today's data?

  1. #1
    Join Date
    Jul 2012
    Posts
    11

    Default How do I get a today's data?

    I have the online access log data in MongoDB.

    I want retrieve the today's log data by JSON.

    what quiery do I write in spoon ?

  2. #2
    Join Date
    Dec 2011
    Posts
    124

    Default

    you should use log tables to retrive latest data..

    log tables can store start ,end date, job log status etc. using kettle log table you can write a small query and can do load oparations.

    Thank you

  3. #3
    Join Date
    Jul 2012
    Posts
    11

    Default

    Thanks,raghavavundavalli.

    Where is the "log table" in the design dialog of Spoon ? or does it has another parts name.

    My spoon (data integration) version is 4.3.0.

  4. #4
    Join Date
    Dec 2010
    Posts
    193

    Default

    Inside a transformation or job , right click open transformation or log settings , inside that click on logging parameter and then specify the table connection with the needed fields. Once you specified that connection, each time when you run a job or trans , you will get the necessary log details by querying the table

    Enjoy

    Sathish

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.