Create reliable time and event based schedules to run your data integration processes at the right time, every time.
Enable multiple user access to automation dashboards and configuration.
Document each process to ensure IT compliance and visibility into the operational processes you have running.
Create multiple step integration processes with flow control. Take a different action on failure and configure notifications to either Email, Slack or Microsoft Teams.
Each step can be automatically re-tried to overcome transient errors that would typically be resolved by retrying the task.
Use the reporting Dashboard to see processes running and when they have run.
See relative performance of each process.
View performance over time to see how everything is performing.
Drill into errors and get to the route cause quickly and easily
Ouvvi brings reliable Run Book Automation and reporting to your Data Integration Tasks
Ouvvi is deployed as a Web Application you can monitor and manage Ouvvi from a Web browser.
Reporting will show a daily timeline of project execution and status. Drill down into individual projects to see historical execution statistics.
Create Dashboards to monitor the health and performance of Ouvvi projects.
All logs from Tasks are stored in the Ouvvi SQL Database, Data Sync tasks can also store a copy of the actual Data change set.
Manage your Data Sync Data source connection library details.
Create user variables to manage configuration properties and pass these to the Task configuration.
Use Project Import + Export to migrate project configuration between environments.
Deploy multiple isolated Ouvvi environments for example DEV, UAT and PROD.
All configuration is stored in a Microsoft SQL Server Database. Easily backup and restore your complete integration platform.
Ouvvi processes tasks from a Queue and will distribute work across multiple processing threads to run Tasks in parallel.
Use Triggers to run Tasks either on a Schedule or via external system change events.
Call the REST based API to start projects from external systems and monitor the execution progress.
Build custom Task Types with Visual Studio and deploy to your Ouvvi Server.
Preview your Data before you execute against the target ensuring you do not make costly mistakes.
Manually choose which rows to apply, allows you to make selective decisions on what to update.
Use Excel like functions to apply custom Data Transformation on your row data.
Go beyond the limits of simple expressions and use the .NET Framework with C# to apply complex data transformations. Use Project Automation to run your own code during the project execution to handle all those edge cases.
Connect to Files, SQL, SharePoint, Dynamics, Office 365 and many other data sources
Import your data from various Data Sources quickly and easily. Apply Schema Mapping and Data Type conversion on the fly and Export your data to various formats.
Compare your Data with the target Dataset and create a difference Change set of ADD, UPDATE and DELETE actions to apply rather than drop all data and re-import.
Preview all your data before any changes are applied and select which data you wish to change. Prevent those Oops moments!
Simple and Complex transformations via Calculated Columns, Dynamic Columns and Lookup features.
Use powerful Lookups to lookup data in other Data Sources, Create Mapping Transformation tables and more.
Manage your connection configuration via the Connection Library and quickly and easily connect to data sources from the library.
Automate the execution of your Data Synchronisation Studio packages with Ouvvi, Task Schedular, SQL Agent, Command Line or API.
Use the .NET Framework to create your own powerful Data Transformation Expressions. Execute your own code before and after the project runs and more.
Use Project Automation to hook into the process and run custom code.