Project has moved to: https://github.com/OptimalBPM/qal

QAL is a collection of libraries for mining, transforming and writing data from and to a number of places.

Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages.
It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming.
It uses XML/JSON formats(self-generated SQL schemas) for representing queries, transformation and merging, making it scriptable.

This means that QAL can be backend agnostic about a subset of SQL features and data types. Of course custom SQL:s are also supported.


It is currently distributed as a Python 3 Library (pip3 install python3-qal) and Debian .deb package.

It is related the Optimal BPM project, see its Optimal Sync application for usage examples.

The text of this page is released under the Creative Commons Zero Waiver 1.0 (CC0).

Features

  • Data transformation
  • Query Abstraction layer
  • Oracle
  • DB/2
  • PostgresSQL
  • MySQL
  • SQL server
  • flat file
  • XML
  • Python
  • Merge
  • Multi platform

Project Activity

See All Activity >

Categories

Data Formats, Database, Business Process Management

License

BSD License

Follow QAL

QAL Web Site

Other Useful Business Software
Forever Free Full-Stack Observability | Grafana Cloud Icon
Forever Free Full-Stack Observability | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
Create free account
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of QAL!

Additional Project Details

Operating Systems

Fink, Linux, Windows, Windows Server

Intended Audience

Architects, Engineering, Financial and Insurance Industry, Information Technology, Legal Industry, Science/Research

Programming Language

Python

Database Environment

Flat-file, IBM DB2, Microsoft SQL Server, MySQL, ODBC, Oracle, Other API, PostgreSQL (pgsql), Project is a database abstraction layer (API), SQL-based, XML-based

Related Categories

Python Data Formats Software, Python Database Software, Python Business Process Management Software

Registered

2013-08-11
Report inappropriate content