101 Great Enterprise Open Source Apps
Data Warehouse

Cynthia Harvey
Tuesday, July 14, 2009 10:39:39 AM
Data Warehouse (DW)
61. Talend Open Studio
The self-proclaimed "recognized market leader in open source data integration," Talend
provides several data integration solutions, including the open source Talend Open Studio
and several commercial versions of the Talend Integration Suite. Key features include
business modeling, graphical development views, metadata-driven design, and real-time
debugging. Operating System: Windows, Linux, Unix. Commercial Support Available? Yes
62. LucidDB
Specifically designed for data warehousing and business intelligence, the LucidDB
RDBMS was built from scratch to handle high-performance data integration and
sophisticated query processing. Key features include intelligent indexing, star join
optimization, and advanced connectivity and extensibility. Operating System: Windows,
Linux. Commercial Support Available? No
63. Apatar
This data integration tool's graphical interface makes it easy to create mashups
without writing code. You can also use Apatar to merge, synchronize, and replicate data
from various sources or to move data from third party applications to your internal
systems. Operating System: OS Independent. Commercial Support Available? Yes
64. DataCleaner
DataCleaner profiles, validates, and compares data in order to ensure data quality.
Its claim to fame is its simplicity and low cost compared to other master data management
and DW applications. Operating System: OS Independent. Commercial Support Available?
Yes
65. MailArchiva
MailArchiva works with Microsoft Exchange and other mail servers to provide long-term
storage of messages for compliance purposes. It includes a Google-like search interface,
and it's available in a free, open-source edition and a fee-based enterprise edition.
Operating System: Windows, Linux. Commercial Support Available? Yes
66. KETL
KETL is an extract, transform, load (ETL) tool for data integration. It is highly
scalable and integrates well with most security and data management tools. Operating
System: Linux, Unix. Commercial Support Available? Yes
Document Management Systems (DMS)
67. KnowledgeTree
KnowledgeTree bills itself as a simple document management system that "seamlessly
connects people, ideas, and processes to satisfy all your collaboration, compliance, and
business process requirements." In addition to the free community edition, it's available
in basic, plus, and premium editions which increase in price as the support response time
goes down. Operating System: Windows, Linux. Commercial Support Available? Yes
68. Epiware
In addition to document management and file sharing, Epiware also includes groupware
functions such as wikis and calendaring. The open source version supports Linux only, but
they do offer a free, limited-feature Windows version under a commercial license, as well
as a full-featured, fee-based Linux and Windows versions. Operating System: Windows,
Linux. Commercial Support Available? Yes
69. Inforama
With Inforama, you can create document templates, import data from databases and
spreadsheets, create PDFs, and automatically store documents in a central repository.
It's available in a Community Edition (for a single machine) or an Enterprise Edition,
both of which are free and open source. Operating System: OS Independent. Commercial
Support Available? No, but a list of partners is available on the site
70. OpenKM
Web-based OpenKM makes it easy to find documents and control access. The latest
version includes a dashboard, push services, and a more powerful search engine. Operating
System: OS Independent. Commercial Support Available? Yes
E-Commerce
71. Magento
Magento offers everything you need to manage an e-commerce site, including marketing
and promotions, product catalog, checkout, customer service, search engine optimization,
reporting, and more. The commercial enterprise edition adds a few features not available
in the open-source community edition, such as gift certificates, private sales, and
advance administrator roles. Operating System: Windows, Linux. Commercial Support
Available? Yes
72. Zen Cart
Designed in part by actual businesspeople, Zen Cart is extremely easy to use. Key
features include an XHTML template system, multiple ad banner controller, newsletter
manager, discount coupons, gift certificates, and quantity discounts, as well as all the
typical components you'd expect in an e-commerce system. Operating System: Windows,
Linux. Commercial Support Available? No
73. PrestaShop
PrestaShop is a lightweight e-commerce app that is fast, easy to use, and highly
scalable. It includes both a FrontOffice module which provides the storefront that your
customers see and a BackOffice module which provides the administrative tools that you
use to set up your site. Operating System: Windows, Linux, OS X. Commercial Support
Available? Only in French, but a list of partners is available on the English site
74. Order
Portal
While most of the other e-commerce packages on our list are designed for simple
installations, Order Portal is aimed at companies who either need to integrate their
e-commerce capabilities into legacy back office systems or who need to handle complex
transactions, such as warranty and repair work. It's part of a full Web Business Suite
that adds CRM, data migration, and other capabilities. Operating System: Linux.
Commercial Support Available? Yes
Enterprise Resource Planning (ERP)
75. Postbooks/xTuple ERP
xTuple claims that anyone can "download, install, and be up and running with a full
xTuple ERP system in 10 minutes. Really." It's available in three different packages: the
free Postbooks edition that includes CRM functionality for small- to mid-sized
businesses, the standard xTuple edition that includes commercial support for enterprises,
and the manufacturing edition. Operating System: Windows, Linux, Unix, OS X. Commercial
Support Available? Yes
76. Openbravo ERP
This Web-based ERP solution is very easy to customize and it integrates with Openbravo
POS. Components include master data management, procurement management, warehouse
management, project and service management, production management, sales management and
CRM, financial management and accounting, and business intelligence. Operating System: OS
Independent. Commercial Support Available? Yes
77. Open ERP
Formerly known as Tiny ERP, the very popular Open ERP is downloaded more than 1,000
times per day and includes modules for document management, CRM, and BI. Besides the
open-source community edition, It's available in three different commercial versions
(SMB, Basic, and Corporate), as well as a hosted version. Operating System: Windows,
Linux. Commercial Support Available? Yes
78. 'project-open'
Project-open combines ERP and project planning for service organizations with 2-2000
users. It includes modules for project/portfolio management, CRM, finance, HR, and
knowledge management. Note that the full software is released under a mixed license, that
is, parts are open-source, parts are available under a free commercial license, and parts
are only available under a fee-based commercial license. Operating System: OS
Independent. Commercial Support Available? Yes
79. webERP
Aimed primarily at wholesalers and distributors, this app includes ERP and accounting
functionality. Key features include multi-language support, role-defined security
settings, double-entry accounting, and much more. Operating System: OS Independent.
Commercial Support Available? No, but a list of consultants is available
80. EdgeERP
EdgeERP builds on the code of WebERP and is designed to offer greater reliability,
accessibility, and flexibility. It includes both accounting and ERP capabilities and
boasts a powerful tax setup for handling global operations, advanced security, and
multi-currency and multi-language support. Operating System: OS Independent. Commercial
Support Available? No, but a list of consultants is available
Next: Human Resource Management »