1

Schedule Data Source Update Time

We host many client databases on a single SQL server, and we have multiple data sources pointing to each of those databases. It would be nice to be able to schedule the time when the data sources update, to make sure that they're not all hitting the database server at the same time, and especially not in the middle of the day. I would like to be able to stagger the times for each of our clients' data sources, and set them to update after business hours. Thanks!

6 comments

  • 0
    Avatar
    Keely Davison
    Our data source API might help here. You can use our api to push your data to the application on a specific schedule. Here is the link to an article about this. http://klipfolio.uservoice.com/knowledgebase/articles/47097-automate-data-upload-using-the-data-source-api
  • 0
    Avatar
    Sidda Eraiah

    That link just redirects to https://support.klipfolio.com/hc/en-us/?r=uv

    I've found that the time at which 24h updates run drifts over time. We have a forecast we want to update at 8am every day. It starts of at 8am then a couple weeks later it's at 9pm. Drift on 15minute updates is not so bad but on 24h updates it's terrible.

  • 1
    Avatar
    Scott Lawrence

    Hi Michael,

    Thanks for your feedback.  We've migrated our knowledge base.  Here's the new link to the article.  (removed non-working link)

    I will raise your current issue noted above with Support.

    Cheers,

    Scott.

     

     

  • 0
    Avatar
    Sidda Eraiah

    That link to the article returns

    Forbidden!

    You're not authorized to access this page

    Even though I'm logged in.

  • 0
    Avatar
    Scott Lawrence

    Hi Michel - I'll look into it and follow up.

    Cheers,

    Scott.

  • 0
    Avatar
    Scott Lawrence

    Hi Michel,

    I should have redirected you to our new API documentation.

     

    Look at the Data Sources section or the Data Source Data section.  Using the API you can either trigger a refresh of a data source or push data you have already captured in a file up to a specific data source in Klipfolio.

    Cheers,

    Scott.

Please sign in to leave a comment.