SharePoint: How to sync external XML data with native lists?
The Business Data List Connector for SharePoint
connects almost any on-premise or cloud-based data source, e.g. ODBC, OLEDB,
OData, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases
like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes,
SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to
native SharePoint lists - in just minutes without any programming. This FAQ
gives a step-by-step intro about connecting XML data.
Integrating external XML data sources
(e.g. from LOB applications) from file system or web requests with
native SharePoint lists (e.g. news, contacts, tasks or custom
lists) can close many gaps using Microsoft SharePoint. Please note: It's not
only about displaying external data - it's about full integration with views,
search, lookups, change notifications, workflows, enterprise metadata etc. This
FAQ gives a step-by-step example how to do this.