How to sync local text / CSV data with native SharePoint lists?
The Cloud Connector for Microsoft Office 365 and
SharePoint connects almost any on-premise 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 and libraries in the Microsoft Cloud - or
any other Microsoft SharePoint on-premise installation - in just minutes without
any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.
Integrating external text / CSV data
sources (e.g. exports from LOB applications) with native
SharePoint lists (e.g. news, contacts, tasks or custom lists) in
Microsoft Office 365, SharePoint Online or SharePoint on-premise can close many
gaps using Microsoft SharePoint. Exporting text / CSV files on a regular base is
helpful in some cases:
- a direct connection to any LOB system via ODBC/OLEDB/ ODATA etc. is
technically not possible,
- it causes possible issues in terms of security or availability,
- generally available data providers are very
expensive and of high complexity, e.g. needs programming (for example for
Please note: It's not only about displaying external data in SharePoint -
it's about full integration with search, lookups, change notifications,
workflows, enterprise metadata etc. Also it is not about bulk import.
These FAQ gives a step-by-step example how to do this.