North America: +1 (646) 257-3449
Global: +91-44-2471 7142
Support Hours (M - F) : 9am - 8pm IST (GMT+5:30)
Current Time :  0:00:00 pm IST (GMT+5:30)
External Data Connector for SharePoint
Home :: Products :: SharePoint :: External Data Connector for SharePoint

External Data Connector for SharePoint

DownloadRequest QuoteBuy Now

How is the External Data Connector licensed?

We are offering a free 30-day trial edition that can integrate data from external data source to a single site collection. The full version is a per user license. A license is required for each user using the software.

Does External Data Connector work with SharePoint Online in Office 365? How does it work?

Yes, External Data Connector supports SharePoint Online in Office 365 seamlessly. External Data Connector supports both Cloud Identity and Federated Identity to connect to Office 365 based SharePoint sites. There is no feature restriction or limitation in External Data Connector to integrate with Online SharePoint sites.

Is there any way to automatically synchronize items in SharePoint list in subsequent runs?

Yes, while selecting the destination SharePoint list, there will be an option to synchronize automatically. On synchronization, External Data Connector will automatically delete items in SharePoint list which are not present in the data source. Currently, External Data Connector supports only one-way synchronization (that is, from the data source to SharePoint Lists). Two-way synchronization will be supported in the next major release.

What is the use of reference column obtained in column mapping step?

Reference column is needed to avoid adding duplicate items in a SharePoint list. So it is mandatory to select at least one reference column. External Data Connector will read the reference column value, query them against the list and if the item exists in the list, action specified in the list item settings will be performed (Skip, Update, Overwrite or Add).

What about security while saving user account details like username and password for scheduled tasks?

The user account will be created as a user profile in Windows Stored User Names and Passwords applet. The stored user profile is a generic credential which can be used by External Data Connector application only. The credential information is stored securely in a 256 bit encrypted format in Windows Stored User Names and Passwords applet. See relevant section in help document for more information.