External Data Connector for SharePoint

What is External Data Connector for SharePoint?

Import data into SharePoint lists and document libraries

The External Data Connector for SharePoint imports data into SharePoint from a variety of external data sources, including databases, SharePoint, CSV, Excel files, and Exchange Server/Exchange Online email, and integrates it with 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 Exchange Server/Exchange Online mail items. The product can integrate data across SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint Online into Office 365.

Why the External Data Connector for SharePoint data import tool?

External data integration

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

Apply metadata from external data sources

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

Creating scheduled tasks

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

Synchronize SharePoint and external data

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

Automatic creation of new columns and mappings

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

Automatic creation of SharePoint lists

Automatically create new SharePoint Lists from the imported data using EDC.

 External Data Connector for SharePoint features

Resources for importing data into SharePoint Online / 2016/2013/2010

Import external data

Import external data source objects (tables/spreadsheets) into SharePoint as list items and vice versa.

Populate external metadata

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

Combine data from multiple sources

Import data from multiple databases and store it in 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 against tables in databases without having to write complex SQL queries.

Customize import

With the External Data Connector for SharePoint  and dictate import preferences using Connection Strings and Query Builder to customize your import.

Data visualization

Check the visualizations to check the availability and accuracy of data imported into and out of SharePoint.

Customize the column mapping

Map SharePoint columns automatically with data source columns. Or, use Column Mapping Conditions to map to your preferences.

Avoid data duplication

Use reference columns to avoid adding duplicate items in SharePoint and in the data source.

Create Lists with the External Data Connector for SharePoint

Automatically create new lists, if necessary, when importing database objects for ease of management in SharePoint.

Publish as documents to the library

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

Export to drive

Import and move data to any networked storage, including drives, web folders as documents that store them in CSV/XLSX/HTML file format.

Automate tasks

Schedule data integration tasks to run at a convenient time.

Synchronize data with the External Data Connector for SharePoint

Automatic synchronization to remove data records from SharePoint or the data source that are not available on subsequent runs.

Exchange recipient selector

Select the mailboxes from the list of available mailboxes to search for mail items.

Swap folder type selection

Use the folder type selection window to get mail items from the list of selected folder types.

Swap folder selection

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

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit, and Microsoft Windows Vista 32-bit

Resolution: 1024×768