All Projects → equinor → tagreader-python

equinor / tagreader-python

Licence: MIT license
A Python package for reading trend data from the OSIsoft PI and Aspen InfoPlus.21 historians

Programming Languages

python
139335 projects - #7 most used programming language

Projects that are alternatives of or similar to tagreader-python

Kyuubi
Kyuubi is a unified multi-tenant JDBC interface for large-scale data processing and analytics, built on top of Apache Spark
Stars: ✭ 363 (+1244.44%)
Mutual labels:  odbc
Mssqlex
Microsoft SQL Server Adapter for Elixir
Stars: ✭ 38 (+40.74%)
Mutual labels:  odbc
Nanodbc
A small C++ wrapper for the native C ODBC API | Requires C++14 since v2.12
Stars: ✭ 175 (+548.15%)
Mutual labels:  odbc
Turbodbc
Turbodbc is a Python module to access relational databases via the Open Database Connectivity (ODBC) interface. The module complies with the Python Database API Specification 2.0.
Stars: ✭ 449 (+1562.96%)
Mutual labels:  odbc
Soci
Official repository of the SOCI - The C++ Database Access Library
Stars: ✭ 960 (+3455.56%)
Mutual labels:  odbc
Xeus Sql
xeus-sql is a Jupyter kernel for general SQL implementations.
Stars: ✭ 85 (+214.81%)
Mutual labels:  odbc
Odbc
Connect to ODBC databases (using the DBI interface)
Stars: ✭ 285 (+955.56%)
Mutual labels:  odbc
Aioodbc
aioodbc - is a library for accessing a ODBC databases from the asyncio
Stars: ✭ 206 (+662.96%)
Mutual labels:  odbc
Odbc adapter
An ActiveRecord ODBC adapter
Stars: ✭ 36 (+33.33%)
Mutual labels:  odbc
Pyodbc
Python ODBC bridge
Stars: ✭ 2,270 (+8307.41%)
Mutual labels:  odbc
Mdbtools
MDB Tools - Read Access databases on *nix
Stars: ✭ 616 (+2181.48%)
Mutual labels:  odbc
Eosio sql plugin
EOSIO sql database plugin
Stars: ✭ 21 (-22.22%)
Mutual labels:  odbc
Qtl
A friendly and lightweight C++ database library for MySQL, PostgreSQL, SQLite and ODBC.
Stars: ✭ 92 (+240.74%)
Mutual labels:  odbc
Sqlpad
Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, ClickHouse, Trino, Presto, SAP HANA, Cassandra, Snowflake, BigQuery, SQLite, and more with ODBC
Stars: ✭ 4,113 (+15133.33%)
Mutual labels:  odbc
Cidlib
The CIDLib general purpose C++ development environment
Stars: ✭ 179 (+562.96%)
Mutual labels:  odbc
Rdbc
Rust DataBase Connectivity (RDBC) :: Common Rust API for database drivers
Stars: ✭ 328 (+1114.81%)
Mutual labels:  odbc
Zabbixdba
Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)
Stars: ✭ 68 (+151.85%)
Mutual labels:  odbc
Freesql
🦄 .NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, Click house orm, MsAccess orm.
Stars: ✭ 3,077 (+11296.3%)
Mutual labels:  odbc
Django Pyodbc
An ODBC-powered MS SQL Server DB backend for Django 1.4+
Stars: ✭ 194 (+618.52%)
Mutual labels:  odbc
Clickhouse Odbc
ODBC driver for ClickHouse
Stars: ✭ 161 (+496.3%)
Mutual labels:  odbc

tagreader-python

GitHub Build Status Devops Build Status PyPI - Python Version PyPI Downloads

Tagreader is a Python package for reading trend data from the OSIsoft PI and Aspen Infoplus.21 IMS systems. It is intended to be easy to use, and present as similar interfaces as possible to the backend historians.

While originally developed for Windows, Tagreader can since release 3.0.0 also be used on Linux and Windows platforms.

Queries can be performed using either REST API (preferred) or ODBC queries. The use of ODBC queries require installation of proprietary drivers from AspenTech and OSIsoft that are only available for Windows.

Trend data is output as Pandas Dataframes. The HDF5 file format is used to cache results.

Requirements

Python >=3.7 with the following packages:

  • pandas >= 1.0.0
  • tables (*)
  • requests
  • requests-kerberos
  • certifi >= 2020.04.05
  • pyodbc (**)

*) If tables is not installed, caching of fetched data will be disabled. Tables will be installed alongside Tagreader unless the installation is known to fail, which is the case for Macs with M1 chip.

**) If using ODBC connections, you must also install proprietary drivers for PI ODBC and/or Aspen IP.21 SQLPlus. These drivers are only available for Microsoft Windows. Pyodbc will therefore not be installed for non-Windows systems.

Installation

To install and/or upgrade:

pip install --upgrade tagreader

If you wish to use ODBC connections to the IMS servers, you will also need to install some proprietary drivers. There is more information in the manual. Please note that the web APIs should normally be preferred.

Documentation

There is a quickstart example file that should get you going. Also check out the manual for more information.

Contributing

All contributions are welcome, including code, bug reports, issues, feature requests, and documentation. The preferred way of submitting a contribution is to either create an issue on GitHub or to fork the project and make a pull request.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].