Using Ouvvi to Schedule and Manage your Data Sync ETL
Here’s a quick overview of how we are using Ouvvi internally to manage our Data Sync projects.
We have a series of Steps that basically download our Timesheet Data from Exchange Server which is then synchronised into a SQL Table. Then we create a View that returns statistics about the time spent on each project which is Synchronised into a SharePoint List with Data Sync.
So this project consists of the following Steps
- Get Exchange Records
- Update Job Codes (2 way sync of SharePoint List containing Job Codes)
- Update Job Stats
- Email support if there was an error.
In Ouvvi this is really easy to setup we just create a new project and add the steps like below.
Adding a Data Sync Step is easy too we just enter the path to the Data Sync Project like so.
We want this process to run at “Start of Day” and every 30 minutes so we just add the Triggers for “Start of Day” and 30 Minutes.
For the Failure report we just add a SMTP Step which only runs on the Run Condition “Failure” like so.
And that’s it all setup and running every day, logging the status to the Ouvvi logs and reporting any error to our HelpDesk. (Ouvvi has an automatic retry pattern so we need 3 failures in a row to initiate an actual error).
Anytime we need to kick this process off again Ad-Hoc we can just hit the Start button without having to log onto the server.
