Free reporting data from many sources software for linux

Kexi Report Part is a reporting component for Kexi 1.6 based on OpenRPT 1.2.
Main features:
- A report viewer for Kexi
- An external report designer (KexiReportWriter) based on the OpenRPT writer program
Known Working Features
- Page Header
- Page Footer
- Report Header
- Report Footer
- Detail section
- Labels
- Lines
- Fields
- Page Browser
How To Create Report
1. Install the component following the instructions in INSTALL
2. Run KexiReportWriter to start designing a report
3. Select Database->Connect to DB
4. Browse to an existing Kexi Database and open it
5. Create a new report (File->New)
6. Assign a data source to the report (Document->Properties)
7. Create the report using labels/fields/lines
8. Assign columns to the field objects (Double click for properties)
9. Save the report. (Database->Save to DB)
10. Load the database in Kexi and double click the report to view it
Enhancements:
- Removed requirement to have kexi source available to install the plugin.Done this by including the needed kexi headers in the package. Only downside is that kexi 1.1.3 (from koffice 1.6.3) is required.

OpenLink AJAX Toolkit in short OAT, offers a broad Javascript-based, browser-independent widget set for building rich user interfaces on all common browsers.
It comes with sample applications for interactive SQL query composition and database design. These applications work against any Microsoft XML for Analysis (XML/A) servers, such as OpenLink Virtuoso and others.
Enhancements:
- This release includes the following new Semantic Data Web technologies: a JavaScript-based Fresnel processor, enabling declarative display templates for RDF Data Sources; an XSLT template for producing HTML from the Fresnel processor; Interactive Query Builder for SPARQL (iSPARQL) with support for INSERTs and DELETEs; an enhanced N3/Turtle parser; and new Navigator UI for the OAT RDF Browser.
- Other fixes and enhancements were made.
- Additionally, there is a new OAT.Notify widget and notification service, facilitating real-time tracking of data sources similar to services such as Yowl and Growl.

OpenLink Virtuoso is a Virtual Database product that provides transparent real-time access to disparate data sources (ODBC, JDBC, XML, and Web Services), and transparent integration of disparate application logic (e.g. Mono ECMA-CLI and J2EE integration). OpenLink Virtuoso Universal Servers broad protocol support enables it to offer Web, File, and SQL database server functionality alongside native XML storage, and Web services platform functionality as part of a cohesive single server solution.
Virtuoso is at the core a high performance object-relational SQL database. As a database, it provides transactions, a smart SQL compiler, powerful stored procedure language with optional Java and .Net server side hosting, hot backup, SQL 99 and more. It has all major data access interfaces, as in ODBC, JDBC, ADO .Net and OLE/DB.
Virtuoso has a built-in web server which can serve dynamic web pages written in Virtuosos web page language as well as PHP, ASP .net and others. This same web server provides SOAP and REST access to Virtuoso stored procedures, supporting a broad set of WS protocols such as WS-Security, WS-Reliable Messaging and others. A BPEL4WS run time is also available as part of Virtuosos SOA suite.
Virtuoso has a built-in WebDAV? repository. This can host static and dynamic web content and optionally provides versioning. The WebDAV? repository is tested to interoperate with WebDAV? clients built into Windows XP, Mac OSX and others and makes Virtuoso a convenient and secure place for keeping ones files on the net. Further, Virtuoso provides automatic metadata extraction and full text searching for supported content types.
Open Virtuoso supports SPARQL embedded into SQL for querying RDF data stored in Virtuosos database. SPARQL benefits from low-level support in the engine itself, such as SPARQL aware type casting rules and a dedicated IRI data type. This is the newest and fastest developing area in Virtuoso.
Enhancements:
- Enhanced cost-based optimizer
- Fixed cost calculation for RDF inf nodes
- Added larger sample in query cost model sampling
- Enhanced SPARQL support
- Added BREAKUP
- Added CONSTRUCT ... LIMIT ...
- Significant performance optimizations
- Added QUAD MAP { ... } group pattern
- Updated documentation
- Significant update of all ODS applications
- Added compliance to latest SIOC vocabulary
- Added calendar
- Added OpenID login and registration
- Added new SIOC subclasses to allow RDF inference
- Enhancements to existing applications
- Bug fixes

Agata Report is a cross-platform database reporting tool with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as PostScript, plain text, HTML, XML, PDF, or spreadsheet (CSV) formats through its graphical interface.

You can also define subtotals, levels and a grand total for the report, merge the data into a document, generate address labels, or even generate a complete ER-diagram from your database.

JOOReports (Java/OpenOffice Reports) is an open source solution for creating office documents and reports in Java, using OpenOffice.org.
Its primary goal is making template composition easy. Templates are regular word processor documents, created the OpenOffice.org Writer, with just a few special features for marking fields and other dynamic parts.
Despite this JOOReports includes support for powerful templating features, such as :
dynamic field replacement, using a powerful expression language
conditionally displaying a document portion based on a test expression
repeating a document portion (e.g. a table row) for each item in a collection
replacing an embedded image.
As for the data to be merged into the template, JOOReports support regular Java beans, so you can use a simple java.util.Map if you just need a few variables, or use any of your existing classes representing your application data model. XML support is also available for importing data from external sources.
JOOReports is licensed under the terms of the LGPL. This means that the unmodified JOOReports library is free to use in both open source and commercial projects.
Enhancements:
- The only change since rc2 is a fix for a bug with character encodings on platforms where UTF-8 is not the default.

Progress is a utility used in a pipe to report progress of data transfer to standard error. Command-line arguments tells to specify how frequently to report, what character to use to report, and how much buffering to do.
Enhancements:
- February 9, 2003
- progress 1.0
- Initial announcement

Data Architects, DBAs, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use of their resources. The Power*Architect allows these busy highly technical resources to perform this most intricate part of their job in a fraction of the time.
Power*Architect project is an innovative Java-based data modeling tool geared specifically for Data Warehouse and Data Mart design. It allows the designer to open multiple concurrent source Database connections, create and explore profiles of the source data, drag and drop source schemas, tables and columns into the data modeling playpen, and forward engineer the resultant target database and its associated ETL template.
Main features:
- Access any JDBC or ODBC accessible source database
- Quickly create profiles of source data, including information about the size of the data in each column, maximum and minimum values, frequency distribution of values in a column, and more.
- Profile information is saved with the project, so profile data can still be used to aid off-site design sessions when it is not possible to access the source databases.
- Design the target database Data Model (Data Warehouse)
- Compare the database structure of any two databases highlighting the structural differences and generating the required DDL to synchronize
- Compare the Data Model data structures to an existing target database
- Save a snapshot of all source systems data structures in the project file, allowing data warehouse designers to evolve their target data model remotely
- Forward engineer to Oracle, SQL Server, DB2, and PostgreSQL and more.
- Forward engineer ETL Templates containing source-to-target data mappings
- Invoke ETL Engine to load initial set of data into the target database
- Enable easy centralized installation and updates to many end users (Supports Java WebStart technology).
- The Power*Architect can open multiple source databases concurrently, even if they are from competing database vendors. Another key feature of the Power*Architect, that sets it apart from other data modeling tools, is that it remembers the origin of each column, and is capable of automatically generating the source-to-target data mappings.
- Whether youre building or maintaining your Data Warehouse data model, the Power*Architect will provide you a complete view of all required database structures and will expedite every aspect of your data warehouse design.
- Design your Data Warehouse in a fraction of the time with the Power*Architect.
- We look forward to showing you how!
- The Power*Architect is available now for download! The product is available for free to individuals for personal use. Commercial licensing and support are available at competitive prices. Please call us at 1-866-SQL-POWR to purchase.
Enhancements:
- This release fixes a bug that caused corrupt project files to be saved.
- The handling of automatic cascading primary keys in multi-level identifying relationships now works better.
- The profile manager is now even more stable.
- It is now possible to add new database connection types from within the GUI.

DBD::AnyData is a DBI access to XML, CSV and other formats.

SYNOPSIS

use DBI;
my $dbh = DBI->connect(dbi:AnyData(RaiseError=>1):);
$dbh->func( trains, CSV, /users/joe/cars.csv, ad_catalog);
$dbh->func( bikes, XML, [$xml_str], ad_import);
$dbh->func( cars, DBI, $mysql_dbh, ad_import);
#
# ... DBI/SQL methods to access/modify the tables cars,bikes,trains
#
print $dbh->func( cars, HTMLtable, ad_export);

or

use DBI;
my $dbh = DBI->connect(dbi:AnyData(RaiseError=>1):);
$dbh->func( Pipe, data.pipe, XML, data.xml, ad_convert);

or

(many combinations of a dozen other data formats, see below)

The DBD::AnyData module provides a DBI/SQL interface to data in many formats and from many sources.

Currently supported formats include general format flatfiles (CSV, Fixed Length, Tab or Pipe "delimited", etc.), specific formats (passwd files, web logs, etc.), a variety of other kinds of formats (XML, Mp3, HTML tables), and, for some operations, any DBI accessible database. The number of supported formats will continue to grow rapidly since there is an open API making it easy for any author to create additional format parsers which can be plugged in to AnyData.

Data in these various formats can come from local files, from remote files, or from perl data structures such as strings and arrays.

Regardless of the format or source of the data, it may be accessed and/or modified using all standard DBI methods and a subset of SQL syntax.

In addition to standard database access to files, the module also supports in-memory tables which allow you to create temporary views; to combine data from a number of sources; to quickly prototype database systems; and to display or save the data in any of the supported formats (e.g. to display data in a CSV file as an HTML table).

These in-memory tables can be created from any combination of DBI databases or files of any format. They may also be created from perl data structures which means its possible to quickly prototype a database system without any file access or rdbms backend.