Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: schedule Pentaho CDA File

  1. #1

    Default schedule Pentaho CDA File

    Need suggestion regarding scheduling CDA file on email..
    Or
    Is it possible to save xls file to a particular folder on particular time.
    Or
    Auto click export to excel button on particular time.

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    I think you can try to do that using an xaction and the Pentaho platform scheduler or you can try using the system scheduler (cron) to call CDA via URL, get the excel, save it somewhere and then email it.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3

    Default

    Hi Community,

    I have a SQL query with 2 Parameters fromDate and toDate in my dashboard.

    A user can select any date range. But still, users prefer the date ranges for Last 30 Days, Current Week or Current Month.
    The dashboard has some huge data so my SQL queries are getting too slow to load the dashboard.
    So I've enabled the cda cache to make the dashboard reload faster. But the data needs to be updated on hourly basis. So a refresh is required for every hour.
    When I clear the cache the dashboard is too slow the first time it is loaded. So I tried to schedule the query with the CDA cache manager.
    Unfortunately, I am unable to schedule the queries with dynamic parameters.
    How can I schedule the queries with my dynamic parameters? Also is there any way to do clear cda cache for specific queries?

    Kindly suggest your solution.

    Cheers,

  4. #4
    Join Date
    Nov 2009
    Posts
    687

    Default

    To clear chache for a single query use the "CDA Cache Manager". You can find that option under Tools

  5. #5

    Default

    I am looking for some solutions like

    https://hazelcast.com/

  6. #6
    Join Date
    Nov 2009
    Posts
    687

    Default

    You can have a look at the cdc plugin

  7. #7

    Default Any document to schedule CDC SQL based on time ..?

    Any document to schedule CDC SQL based on time ..?

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.