Integration is much more than just moving a data item from one system to another. To make integration valuable it must be woven into the operations routine of a company. Ouvvi is designed to allow an operation department to monitor, schedule, trigger and run sets of actions to enable integration.
There are three underlying components that allow Ouvvi to manage your integration requirements:
Website – The website is the portal to monitoring and configuring integration.
Database – This database holds the configuration (including the DS3 projects) and the details logs.
Service – This is the underlying Windows Service that will run all of the tasks, monitor changes and tell the systems when it is time to run projects.
All of Ouvvi's features can be access from its top menu bar:
Projects contain groups of steps for a single integration. Steps are DS3 Projects, SQL Statements, Http downloads +++. Steps can mark themselves as successful or failed.
Reporting details when projects have been run and if they have been successful or have failed.
Triggers are the link between an event and a project being run. This could be a time of day or a change in a file or entity field change
To monitor the activity and health of the underlying Ouvvi Windows service, you can view its state in the Services page.
The general configuration settings of the Ouvvi solution such as the start of day or default email addresses are managed here.
Logs record the running of a Project including all console output and details about rows synchronised, deleted. Ouvvi also audits the manual running of projects, changes made to steps as well as all debugging information.
The default list of projects displays the essential information for managing projects
To add a new project click on the 'New' menu items in the projects page. Complete the name and save the new project. Drilling into a project will display the list of its steps. You can also run the project manually from here by clicking on the 'Start Project' button.
To add a step click on the 'Add Step' menu item. You will be presented with a list of possible steps. To add a new project click on the 'New' menu items in the projects page. Complete the name and save the new project.
Clicking on the 'Data Sync Project' will create a new Step to hold a DS3 project file:
Complete the new step details. If you have an existing step use the choose file button to upload it. If not Ouvvi will create you a blank project and save it to the database. It can then be opened as if it was uploaded.
Pressing save after completing the new step details will save it to the database. You can manual start the project by clicking on the 'Start Project' button.
To be able to run projects on a schedule or in response to an event you must create a Trigger you can associate with a project.
Open the Triggers page from the menu bar and you will see a list of active triggers.
To Create a trigger that runs a 9 am every day click on the 'Add Trigger' menu item. You will be presented with a list of trigger types.
Select the 'Time Trigger' and you will be show an empty Time trigger page.
Complete the form as show above for the 9am trigger and click save.
To associate the trigger navigate back to your project and click Edit from the menu.
To add the 9am trigger click the 'Add Trigger' from the menu and select the trigger. Click Save and the project will now run at 9am every day.