DataCleaner is a data quality analysis tool that allows you to perform data profiling, validating, and minor ETL-like tasks. These activities help you administer and monitor your data quality in order to ensure that your data is useful and applicable to your business situation. It can be used for master data management (MDM) methodologies, data warehousing projects, statistical research, preparation for extract-transform-load activities, and more.
Talend Open Studio for Data Quality helps you to profile your data. The ergonomic interface allows you to define metrics (indicators) and collect statistics on your data in a few clicks. It comes with a set of regular expressions that helps you to identify bad data. You can create your own regular expressions and use them in data profiling analyses. A lot of options exist for each indicator, which change the behavior of the indicator so that it gives you more pertinent information. Data quality options on indicators alert you when your data quality is not what you expected.
Lobotomy involves many sub-projects oriented to experimentation about new design for human-computer interaction and, more generally, a new way for home computing. It involves a relational filesystem, a window manager, and many libraries, tools, and daemons to automatically extract and handle metadata.
The eobjects.org MetaModel is a project created for maximum reuse of a SQL-compliant domain model of the database domain. The MetaModel is a model that contains classes that represent the structure of a database (schemas, tables, column, relationships) and interaction with the database (queries) in a SQL/LINQ-like way. In short, it is a model for modelling data in databases and other datastores. With MetaModel you can query different datastores like databases, CSV files, Excel spreadsheets, MS Access files, and XML files using the same approach and the same domain model.
K.E.T.T.L.E (Kettle ETTL Environment) is a meta- data driven ETL (Extraction, Transformation, Transportation, and Loading) tool. This means that no code has to be written to perform complex data transformations. It is possible to create plugins to do custom transformations or access proprietary data sources. Kettle supports most databases on the market, and has native support for slowly changing dimensions on most database platforms.
JasperServer is specifically designed to provide a general platform for business intelligence. Continuing the philosophy of JasperReports, JasperServer is aimed at providing a managed, stand alone Web reporting and analytic (OLAP) environment, capable of being embedded in existing Java Web applications. It also provides services to a variety of technologies through Web services, including the LAMP stack. By focusing on a clean business API and using an advanced inversion of control architecture, JasperServer can be easily integrated and customized for your needs.
The Gaudí Database Visual Editor is a Java application that allows you to visually design the tables of a database using a JDBC 2.0 (or higher) driver. It saves generated diagrams in XML format. It also generates Java code that binds an object to a table from a database and XML code for generating GUIs.