Supported Data Sources
Visual KPI not only supports almost any data source, it's at its best when supporting many at the same time.
- Have multiple systems with critical IoT, IIoT, operations and other types of data?
- Want that critical subset of your big data available anywhere in real-time?
- Want to roll-up multiple divisions or departments with separate systems?
- Want to easily create KPIs from tag values to display and alert status on them?
- Want your actual values to come from one system, but your limits and attributes from another?
- Has a merger left you with mutiple applications that aren't integrated?
All of these situations are ideal for Visual KPI. Because of our web-based architecture, we can interact with multiple systems without a need for deep integration and without a performance or security hit. Our job is to take your valuable data and make it useful... today.
When it comes to utilities, oil & gas, manufacturing, data centers and many other real-time industries the data historian is often the most important operational data source. In fact, Visual KPI was born from years of working with these powerful engines. We support most of the majors including the OSIsoft PI System, Invensys Wonderware (InSQL), system:inmation, GE Proficy, Rockwell FactoryTalk (RSSQL), AspenTech IP.21, Iconics, OAS and many others.
Databases & Data Warehouses
The other most popular engine for fast-moving data is the large database. Oracle, Microsoft SQL Server, MongoDB, PostGres, MySQL, NoSQL, and many others. Same for data warehousing and business intelligence.
Big Data / Internet of Things (IoT)
Visual KPI is ideal for operational Big Data and industrial IoT scenarios and with our integration server technology we can even change the configuration, grouping and metrics on the fly based on what your big data is telling you (contact us to learn more).
Cloud Infrastructure / IaaS Monitoring (AWS, Azure, Etc.)
Our software was originally designed around critical industrial asset monitoring, which makes it perfect for monitoring cloud infrastructure in real-time. Not only can we get data from today's leading IaaS vendors like Amazon CloudWatch and Microsoft Windows Azure, but we can also sync the metadata from these stems so as you add, remove and change resources they are immediately reflected in Visual KPI. Contact us if you would like more details.
SAP, Oracle Applications, Microsoft Dynamics and others. ERP, CRM, and just about any other abreviation you can throw at us. We can access these systems directly via ODBC/OLEDB or through custom views or staging tables.
Web Services / Data Feeds
We don't just work with internal data. Some of our most successful customers combine internal data with feeds from supply chain partners or other external sources using XML, JSON, Odata, etc.. If you are monitoring wind farm assets, why not combine it with weather data? The possibilites are endless.
In addition to the usual enterprise data sources, we all know someone who has at least a bit of information stored in an Excel spreadhseet somewhere (even we do, admittedly). Whether you have some KPI targets or limits in Excel that need to be combined with some historian or database data on the fly, or you just want a simple Excel table to appear on your smartphone or tablet, we've got you covered. You can access local Excel files, remote files, or even files hosted in the cloud.
If you have data sources beyond what is listed here, contact one of our engineers and see if we support it. Chances are we can.