External Data Connector for SharePoint

2.2

Download Request Quote Buy Now

Import external data

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

Fetch business data from databases / files and populate them in SharePoint lists
Populate external metadata

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

Update document metadata from external data sources
Combine data from multiple sources

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

Filter business data from multiple databases and populate them in SharePoint lists
Column Mapping

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

Map fields in external sources with SharePoint columns to update metadata values
Query Builder

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

Query Builder interface helps you construct database queries when importing data
Customize import

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

Customize import using Query Builder and Connecting String options
Data Preview

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

Preview data to validate the dataset before publishing them to SharePoint lists
Customize column mapping

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

Map columns between SharePoint and external source DBs for an error free import / export
Avoid data duplication

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

Designate a primary / unique column to avoid data duplicates
Create Lists

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

Create new SharePoint Lists or use existing ones to store external data
Publish as documents to library

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

Retrieve external business data and publish them as files in SharePoint libraries
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.

Publish the external business data as files in shared storage locations
Automate tasks

Schedule Data integration tasks to run at a convenient period.

Schedule import tasks or updates to run at off-peak hours
Synchronize data

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

Auto synchronize data between external source and SharePoint at periodic intervals
Exchange Recipient Picker

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

Select 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.

List of folder types to fetch mail items
Exchange Folder Selection

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

List of available folders to fetch mail items
Exchange Item Search

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

Specify search queries to filter mail items