Skip to main content

Integrations Questions

Does Visual KPI OPC Interface Support Real-time & Historian Values?

Transpara's Visual KPI Enterprise ADI option includes OPC support, which can handle various OPC flavors, such as:

  • OPC-DA
  • OPC-UA
  • OPC-AE
  • OPC-HDA
test
support

Transpara offers complete support for all OPC-related requirements. To learn more about Visual KPI Enterprise ADI or OPC support contact our Support.

Can I send Alerts via Microsoft Office 365?

You can send Visual KPI alerts via Microsoft Office 365, but you need to configure SMPT emails in IIS to have them delivered from the Visual KPI server to an Microsoft Office 365 email account.

info

You must have a Microsoft Office 365 account with email enabled.

Is there a limit to how many data sources you can integrate to?

We've support for thousands of sources and even have one customer interfacing with over 100 sources against a single Transpara system. You can mix and match data from various sources, combine data from multiple sources using calculations, and even get various attributes dynamically from source (for example, get location data for a group or KPI for a moving object from one source while the data comes from other sources).

Are we required to ingest or copy data into Transpara?

No. One of the most unique aspects of Transpara's approach is that you can leave data in your existing systems and put it to use on-the-fly, leveraging your existing investments and eliminating the most costly, time-consuming and painful part of any data project. If or when required, data can be stored in Transpara time-series analytics cache for the purpose of time-based calculations, analytics that span multiple data sources, or when you don't already have existing sources.

What are the most common data sources you integrate with?

Transpara can interface with thousands (probably millions) of data sources and applications, including industrial systems that many other applications have less experience with, such as historians/time-series databases, SCADA, OPC, IoT/IIoT, control systems, MQTT and others. We like to put data sources into a few large categories as follows:

  • Proprietary historians (those that require the use of an SDK), such as AVEVA OSIsoft PI and AF, Aspentech (IP.21 and inmation), GE and many others.
  • Other time-series databases, including historians, open source (TimescaleDB, InfluxDB, etc), and cloud time-series databases (AWS Timestream, Azure ADX or TSI, Timescale Cloud, etc).
  • Relational databases (SQL Server, Oracle, MySQL, PostgreSQL, etc) and any applications built on relational databases (vertical industry applications, ERP, CRM, LIMS, etc).
  • Data lakes, data warehouses, OLAP and big data sources.
  • Web services, including both internal (any application with a REST API) or external (like weather, commodity pricing, traffic, etc). This includes JSON, XML, Python, etc.
  • IoT/IIoT and other sensor data. This includes OPC, Modbus, MQTT, SNMP and many other protocols.
  • Slow moving or manually entered data, including manual data entry features in Transpara along with Excel, CSV, web form applications and more.
  • IT, Cloud and Security data, including applications like VMware, Zabbix, Splunk and many others.

Even if we've never encountered a particular data source, there are usually no technical limitations stopping us from interfacing with it. Usually the only thing that gets in our way is politics.

Can I integrate my advanced data science tools with Transpara?

Yes. Transpara believes you should leverage all of the tools and applications that provide value to you. We support integrations with data science tools like Jupyter Notebooks, R, Python and specialized or cloud-based analytics platforms (machine learning, AI, etc). If you are curious about integration with a specific tool or application, just reach out to our Support and we can discuss it.

Can you integrate with our business intelligence tools?

Yes. Transpara easily integrates with applications like Power BI, Tableau and others, either as a source of data for Transpara or as a client tool for analysis and reporting.

We use Excel for many things. How does Transpara work with Excel?

Transpara works with Excel in several ways:

  1. As a data source with our native Excel interface,
  2. With the native ability to export data to Excel/CSV for further analysis and charting, and
  3. Our native authoring client (Transpara Designer) is based on Excel so it's already familiar to new users. Excel is widely known as the most popular developer language and analytics tool on the planet, so we integrate deeply wherever possible.

Feedback