General ETL task question

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • General ETL task question

      Hey Community.

      I have to do some tasks with PALO at work, but i have never worked with it before ;(
      I should collect data from an MSSQL database (CRM System), then they must be written in a new table in the MSSQL database (data of the actual week).
      This should happen every week like a cron job. I already created a job exporting the data of the running week.
      In the next step the last 5 weeks should be reimported from the new table to view them in a diagramm in palo.
      Can you explain me how to do these jobs? ("Cron", reimport and view)

      Best regards,

      Thanks for your support.

      The post was edited 1 time, last by advantage ().