Hi.
What are suggestions for good products in the Integration Solutions space, i.e. products with features similar to Pervasive Universal Connect.
http://www.pervasiveintegration.com/data_connectors/Pages/universal_connect.aspx
We are looking for an off the shelf solution that will allow us to configure, schedule and monitor retrieval and routing of data. Nothing terribly fancy, these are the features we are looking for:
- Schedule retrieval of files through FTP (and preferably SFTP & FTPS)
- Schedule retrieval of files from a file share
- Schedule retrieval of data through a Sharepoint list
- Schedule pulling of data from a web service
- Retrieve files through email (POP3)
For all these the routing would be very simple, e.g. 'Retrieve file from FTP, save copy to a folder and send an email to notify file was received', or 'Check email box for new emails, save attachments of type .xsl to specific folder, forward email to backup email box and send email distribution list to notify file was received'. So being able to specify multiple actions is required but no workflow with approvals or anything to that effect.
Monitoring requirements would be to be able to detect that a retrieval fails (send notification on failure) and to detect if a file has not been retrieved in a certain time period.
It would be good if non-programmers would be able to performe the coniguration tasks (scheduling retrievals and tasks).
What are good products / solutions in this space? Both open source and commercial products would be of interest.
Simplicity in terms of setup, configuration and deployment is a definite plus.
Thanks