Compiere is an integrated ERP and CRM business solution for automating financial, distribution, sales, and service processes, including: financial management, purchasing, materials management, manufacturing, order management, project accounting, customer management, sales, service requests, ecommerce, reporting, and performance management. Compiere utilizes a powerful model-driven application platform that provides customers with unprecedented adaptability, rapid deployment, and low cost of ownership.
The Expense Submittal System (ESS) is a Web-based solution for the creation of expense reports, expense report approval, payment, and accounting. The complete expense reporting process is covered. ESS provides report entry, approval routing, corporate policy checking, credit card statement importation, and report payment.
SQL Uniform is a database comparison and SQL query program. It is a database client with a graphical user interface. It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Solid, SQLITE, Sybase, ThinkSQL, and Yard.
LabKey Server is open source software that helps scientists manage, analyze, and share complex datasets. It supports tandem mass spectrometry, flow cytometry, assays for neutralizing antibodies, Luminex, observational studies, and secure, Web-based collaboration. The software is modular, configurable, and customizable. It can be installed in your institution on any modern hardware and operating system. It is designed to integrate with your existing systems, instruments, and work flows, and to be readily adapted by skilled programmers to novel methods of inquiry. The project is under active development by a team of professional software engineers and a community of active contributors. New versions are released about four times per year.
XML to DDL is a set of Python programs that converts an XML representation of a database into a set of SQL or DDL (Data Definition Language) commands. In addition, it can examine the difference between two XML files and output a sequence of SQL statements (normally ALTER statements) to bring one database up-to-date with the XML schema. You can also download the XML schema directly from the database. Finally, there's a tool to convert your schema into HTML for documentation purposes. XML to DDL currently supports the most recent versions of PostgreSQL, MySQL, Oracle, and Firebird databases.
PyDBDesigner is an entity-relation (ERW) database modeling tool for both Windows and Unix/Linux. It is similar to Power Designer or Erwin, and both physical and logical models are supported. Its main features are database modeling, SQL generation, documentation generation, and reverse engineering. PyDBDesigner is intended to be a GUI design tool for the ERW (entities and relations on the Web) project.
XMLToaster is a tool for extracting and loading XML from databases. It provides a modified version of SQL which has XML mapping extenstions. It can be compared to the "for xml" command in MS SQL Server 2008, but it runs on all common databases and scales to handle very large XML mappings without too much complexity. It is used as a Java library to write XML interfaces, but can also be run as a command line tool.