External Data Connector for SharePoint

Features to Import Data into SharePoint Online / 2016 / 2013 / 2010

Import external data

Import External Data Source objects (tables/worksheets) into SharePoint as List Items and vice versa.

Populate external metadata

Apply metadata from external data sources to documents in SharePoint library.

Combine data from multiple sources

Import data from multiple databases and store under a common List.

Column Mapping

Map columns in Data Sources with SharePoint columns to update with the original metadata.

Query Builder

Use the built-in Query Builder wizard to build queries on tables in databases without having to write complex SQL queries.

Customize import

Edit import preferences using Connection Strings and Query Builder to customize your import.

Data Preview

Check previews to ascertain the availability and accuracy of data being imported in and out of SharePoint.

Customize column mapping

Automatically map SharePoint columns with Data source columns. Or use Column Mapping Conditions to map according to your preferences.

Avoid data duplication

Use reference columns to avoid adding duplicate Items in SharePoint and Data Source.

Create Lists

Automatically create new Lists if necessary while importing DB objects for easy management in SharePoint.

Publish as documents to library

Import and move data into SharePoint Library as Documents storing them in CSV/XLSX/HTML file format.

Export to drive

Import and move data to any networked storage including Drives, Web folders etc. as documents storing them in CSV/XLSX/HTML file format.

Automate tasks

Schedule Data integration tasks to run at a convenient period.

Synchronize data

Auto Synchronization to remove data records from SharePoint or Data Source which are not available in subsequent runs.

Exchange Recipient Picker

Select mailboxes from the list of available mailboxes to fetch mail items.

Exchange Folder Type selection

Use the folder types selection window, to fetch mail items from the list of folder types selected.

Exchange Folder Selection

Select folders to move data from the selected folders to SharePoint list / library.

Exchange Item Search

Specify search queries to filter items from the list of folders / folder types selected.

WordPress Video Lightbox Plugin