PIPER Data Access
Visualize data in Ms. Excel
PIPER Data Access - Excel
Visualize data in Ms. Excel
Excel Add-In capable of retrieving tag and attribute values.
It allows searching for tags and attributes, and querying:
- current value,
- value at a specific time,
- values within a time range,
- calculated value over a time range, and
- calculated values by intervals within a time range.
Authentication is handled through user login via User Manager.
PIPER Data Access - Rest API
REST API that allows connection with Business Modeler for querying and inserting data.
Authentication is handled using an API Token in the request header as follows:
• Authorization: PIPER {APIToken}
It provides read access to the following entities:
- Database
- TagValue
- Element
- Attribute
It provides write access to the TagValue entity.
Data Access - AI
Description
Python library capable of retrieving tag and attribute values.
It allows searching for tags and attributes, and querying:
- current value,
- value at a specific time,
- values within a time range,
- calculated value over a time range, and
- calculated values by intervals within a time range.
The queried values are returned in Pandas DataFrame format.
Perform advanced analytics by accessing historical data of contextualized tags and attributes from Business Modeler directly from Jupyter notebooks in Python.