Import Data into SharePoint Lists and Document Libraries

External Data Connector for SharePoint imports data into SharePoint from multiple external data sources, including Databases, SharePoint, CSV, Excel files, and Mails from Exchange Server / Exchange Online and integrates them into SharePoint Lists and Document Libraries.
It supports databases such as SQL Server, MS Access, Oracle and any ODBC compliant database, file sources such as XLSX, CSV and Mail Items from Exchange Server / Exchange Online.
The product can integrate data into SharePoint 2016, SharePoint 2013, SharePoint 2010 and SharePoint online in Office 365.

  • Bring your data from external data sources to SharePoint Lists

    • Integrate external data in SharePoint Lists and Synchronize with their external sources
    • Automate filtering and fetching data from external sources using "Query Builder"
    Import your data into SharePoint
  • Extract data from databases and Publish them as reports (documents) in SharePoint

    • Create and store reports about external data sources from within SharePoint
    • Publish these reports as SharePoint List or Library / Export them to a shared folder
    Extract Data & Publish in SharePoint
  • Extract Metadata from your disconnected Legacy / LOB Apps and apply them to documents in SharePoint

    • Synchronize SharePoint Library metadata with the file properties in external sources
    • Simplify data & content management with synchronized SharePoint metadata and source file properties
    Extract Metadata & Apply in SharePoint
  • Import Exchange mails to SharePoint Lists

    • Export mail content to SharePoint for knowledge sharing and collaboration
    • Archive business critical mails to SharePoint lists and libraries
    • Use the Exchange Query Builder to import specific, context based mails such as projects, campaigns, surveys, etc. from mailboxes to SharePoint
    Import Mails in Exchange to SharePoint

 


Highlights

  1. Integration of external data

    Integration of external data from multiple sources into SharePoint Lists / Libraries and vice versa.

  2. Apply metadata from external data sources

    Apply metadata from external data sources to documents in SharePoint library

  3. Auto create SharePoint Lists

    Automatic creation of new SharePoint Lists using imported data.

  4. Sync SharePoint and external data

    Synchronization of SharePoint and external data through field/column mappings.

  5. Auto create new columns and mappings

    Automatic creation of new columns and mappings while creating new Lists using imported data.

  6. Create of scheduled tasks

    Creation of scheduled tasks for automatic import and synchronization of external data and SharePoint Lists and Libraries.

Import Data from external database into SharePoint Lists


Import XLSX, CSV data to SharePoint

Import Data from external database into SharePoint Lists