Also consider looking at Enterprise Enabler from Stone Bond Technologies. Enterprise Enabler supports a combination of Extract-Transform-Load (ETL) and Enterprise Application Integration (EAI) technologies, with an integration engine that extends the reach of the SharePoint installation far beyond the default capabilities of the BDC. This eliminates the need for a staging database and virtually eliminates any custom code. Enterprise Enabler’s federated query capability allows SharePoint to search, index, and report from a variety of sources and define relationships across system boundaries, bi-directionally.
Enterprise Enabler (EE) is designed so that with little or no programming, interfaces and workflows can be built to move data securely from any sources to any destinations with very easy mapping of complex data transformation. EE can be implemented with any combination of real-time data flows, on-demand, or triggered based on any event. EE manages and monitors the data flow and workflow logic.
Please contact me for more information.
Regards,
Jeff Isola
Stone Bond Technologies
jisola@stonebond.com
713-300-8886