OpenSyncro is an enterprise application integration (EAI) tool. It runs on the Apache Tomcat application server and has a Web browser interface for setting up and maintaining component based integration processes. Features include data converters from CSV tables and other text based data formats to XML, support for XSL transformations (XSLT 2.0), calling Web Services, accessing files on FTP/HTTP servers, and databases via JDBC. A connector for Smilehouse Workspace webshops is also built-in. OpenSyncro can be extended with Connector Packs for ERP/CRM systems.
|Tags||Text Processing Markup XML Internet FTP Software Development Libraries Application Frameworks Information Management|
|Operating Systems||Windows POSIX Mac OS X|
Release Notes: This release adds support for processing arbitrarily large SQL query result sets, and brings improvements to using temporary files in iterating integration Pipes, which translates to more scalability options. HTTP components allow setting Content-Type header for requests, and can deal with server responses that specify incorrect or no charset encoding information. Querying customer data by last modification date from a Workspace Webshop is now possible. The update includes various bugfixes and resolves a compatibility issue with J2SE 6.0.
Release Notes: The new built-in components make it possible to access multiple Web Services in a single Pipe and to easily capture data at any point in the integration process. A component for exporting customer data from a Workspace webshop has been added. The Transfer log viewer was improved and allows faster browsing of very long log entries. OpenSyncro now supports installation on MySQL 5.0 database. New third party Connector Packs are available for integration with QuickBooks, online market places such as Google Base and eBay, and enterprise applications with support for Finvoice XML format.
Release Notes: This release introduces asynchronous remote invocation of data transfer pipes, based on a persistent and fault tolerant execution request queue. The Pipe List and Pipe Editor user interfaces have been improved. Email notifications can now be sent when a pipe's data transfer is aborted without an error. Improvements to the built-in components include HTTPS support to HTTPSource and HTTPDestination, and sending SOAP messages with HTTPDestination. Five new third party Connector Packs are now available.
Release Notes: This version features an email notification option for alerting administrators of error and warning messages resulting from an integration pipe execution. New built-in pipe components enable processing of arbitrarily large XML files and sending data to the destination system through HTTP GET, POST, and PUT requests. It is also possible to import contract pricing and sales order XML data to a Smilehouse Workspace webshop. When exporting orders with a Hibernate query (HQL) as a selection criteria, payment and handling status of an order in Workspace can be updated.
Release Notes: This version's new built-in components make it possible to connect to databases using a JDBC driver, download files from HTTP servers, and process text files (e.g. CSV tables) larger than the available free memory. Exporting XML data from a Smilehouse Workspace webshop is now more versatile with the introduction of Hibernate query (HQL) components. Third party Connector Packs for integrating Workspace webshops with Compiere and Exact ERP systems are now available.