Talend Open Studio for Data Integration is an ETL (Extract, Transform, and Load) tool. Talend Open Studio for Data Integration can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl or Java. The application was designed to be extended with components written by users.
Talend Open Studio for ESB is an innovative, Eclipse-based tooling environment for modeling, configuring, and deploying integration solutions using the Apache-based open source enterprise service bus (ESB), Talend ESB. Talend ESB is a versatile and flexible ESB that allows organizations to address integration challenges, from simple departmental projects to complex, heterogeneous IT environments. Powered by the Apache CXF, Apache Camel, and Apache ActiveMQ Open Source integration projects, it makes enterprise-class integration accessible by delivering a cost-effective and easy-to-use way to integrate and expand systems and applications.
Aubit 4GL compiler is a programming language based on (and compatible with) Informix-4GL. It provides an easy way to generate screen/form based programs, since statements for handling Windows, Forms, Menus, SQL, and similar are built-in. With support for SQL statements forming an intrinsic part of the language, it's especially suitable for developing database-oriented applications. Database connectivity is provided for PostgreSQL, MySQL, Informix, and others via ODBC. It supports both ncurses (console mode) and GTK+ (GUI mode) output.
xplain2sql converts files from Xplain to SQL. It supports a very large subset of Xplain, and it can convert from Xplain to Microsoft SQL Server, DB/2, Inprise InterBase, PostgreSQL, Oracle, MySQL 5, SQLite 3 or ANSI-92 SQL. It can also generate an XML description of the generated SQL. This XML description can be used to create low-level middle-tier code. Example stylesheets for Eiffel/ECLI and Delphi/ADO are included. The C source code release should compile on any platform with an ANSI C compiler. There are binary releases for FreeBSD, Linux, Solaris x86, and Windows 2000.
EFEU is suitable for handling data cubes, which are especially useful for building data warehouses. It consists of a building system including mkmf (a xmkmf like Makefile generator), esh (a powerful C/C++ interpreter), efeudoc (a document generator with different output formats (LaTeX, HTML, roff, etc.)). EFEU has a huge set of C library core features, including robust memory allocation tools, functions to concatenate and copy strings with memory allocation, buffers for dynamically-growing strings and fields, data structures with reference counters and garbage collection, and file tools that allow you to specify pipes wherever a filename is expected and support automatic implementation of (de)compression filters (gzip) depending on filename extensions. It also includes a high-level interface to files, strings, and anything else you can read from or write to.
SynApp2 is a development tool that generates database-backed Web applications by processing your MySQL or Oracle schema definition and producing the Web pages used to manage your data. It does more than an admin tool or file manager by considering table relations as a cohesive whole that drives the generation of a complete application that smoothly integrates your entire database design, complete with PDF reports. It is open, compact, efficient, and compatible with the tools and technologies you’re using now.
Admin is entirely written in Java. It uses Swing GUI Components and JDBC to connect to databases. It has been succesfully tested with MySQL, InstantDB, Oracle, Empress, and PostgreSQL. You can have a tree view of the RDBMS or pick a single instance to have a look at its metadata. It allows you to create, modify, and drop tables and to create indices on a table. The dynamic form makes it easy to enter data into a certain table, and the guided query makes it easy to retrieve data from a table and to export it. Java developers will probably enjoy the code generator doing an OO relational wrapper and a swing GUI for them. You can also export and import data and transport it from one DBMS to another.