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
Compliance Operations Platform. Built to Scale. Icon
Compliance Operations Platform. Built to Scale.

Gain the visibility, efficiency, and consistency you and your team need to stay on top of all your security assurance and compliance work.

Hyperproof makes building out and managing your information security frameworks easy by automating repetitive compliance operation tasks so your team can focus on the bigger things. The Hyperproof solution also offers powerful collaboration features that make it easy for your team to coordinate efforts, collect evidence, and work directly with auditors in a single interface. Gone are the days of uncertainty around audit preparation and compliance management process. With Hyperproof you get a holistic view of your compliance programs with progress tracking, program health monitoring, and risk management.
Learn More
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 Server, Windows

Intended Audience

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

Programming Language

Python

Database Environment

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

Related Categories

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

Registered

2013-08-11
Report inappropriate content