Python‑native access to ASAM ODS - with pyHQL

29. October 2025 Dr. Ralf Nörenberg

29. October 2025 - Dr. Ralf Nörenberg

Introducing pyHQL as a Python Library to ASAM ODS

pyHQL (ASAM ODS Toolbox for Python) enables analysts and engineers to utilize the HighQSoft Query Language (HQL) to work directly with ASAM ODS data from Python, providing typed results, mass-data access with units, transactions, and file streaming for analysis, scripts, and dashboards.

HighQSoft is introducing pyHQL, a lightweight Python library that connects to the HQL WEB Service and, through it, to any ASAM ODS server in your infrastructure. You use familiar HQL commands to query metadata and measurement data. pyHQL maps ASAM ODS datatypes to convenient Python objects, allowing you to analyze them immediately.

What’s new?

pyHQL eliminates the effort of crafting low-level REST calls and interpreting ASAM ODS datatypes by providing a ready-to-use library—so teams can spend time analyzing data and focusing on insights rather than integration work.

The HQL Web Service delivers product-based stability and all HQL comfort to the Python end-user.

What you can do with it:

For End-users

Query information easily — Use the same HQL queries you already know to retrieve any information from ASAM ODS servers - with all the comfort you'd expect!
Work natively in Python & Data Frames — Stay in your comfort zone with Python, Pandas, and friends.
Transactions & file streaming — Open/commit/abort transactions from Python; upload and download files via dedicated helpers. Uncommitted transactions are safely aborted on disconnect.

For Analysts & Data Scientists

Create dashboards — Build dashboards on ASAM ODS data with Plotly or other tools on top of typed results.
Write helper scripts — Quickly retrieve and prepare ASAM ODS data for engineering teams or process information for other stakeholders.
Automate pipelines — Combine pyHQL capabilities with Merlin’s pre-built stages to retrieve and write information from ASAM ODS and implement automated processing pipelines.

For Administrators

Product Stability — Built on the well-maintained HQL WEB Service for consistent, predictable behavior.
Simplicity — Get users started fast with a straightforward, two-URI connection model.
Compatibility — Works with ASAM ODS 5 and ASAM ODS 6.

A 30 seconds example to success

from highqsoft.pyHQL.HQL import HQL ASAM ODSURI="hql://admin:admin@localhost:xxxx?licenseserver=xxxx@licenseserver"
hqlURI="http://192.168.xxx.xx:xxx"

hql = HQL(hqlURI, ASAM ODSURI)

>>> result = hql.query("hql id, name from aotest")
>>> print(result)
---------------------------------------------------------
| Station 0.056 seconds to fetch 83 rows with 2 columns |
| id | name |
---------------------------------------------------------
| 26 | Alsfeld |
| 5 | Neuruppin-Alt Ruppin |
| 45 | Anklam |
...
| 81 | Veilsdorf |
| 82 | Oberhaching-Laufzorn |
| 83 | Waltrop-Abdinghof |
| 61 | Helmstedt-Emmerstedt |
---------------------------------------------------------
83 rows selected
---------------------------------------------------------
Query time: 0.056 seconds
Printer time: 0.001 seconds
Execution time: 0.057 seconds

Availability

pyHQL is available now as a ZIP for pip install from the HighQSoft download page. The manual includes installation steps, connection examples, and a quick tour of queries, mass data access, transactions, and file transfer.

#ASAM #ODS #TestData #Merlin #Python #pyHQL #TDM #TestDataManagement #ASAMODS #HighQSoft