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,
advantage
Thanks for your support.
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,
advantage
Thanks for your support.
The post was edited 1 time, last by advantage ().