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.
Yes, External Data Connector can be installed and run from a Windows 8.1 / 8 / 7 desktop with .NET Framework 4.0 or higher. Read System Requirements section for more information.
Yes, you can connect to a remote Microsoft SharePoint 2013 / Microsoft SharePoint 2010 server within your local network or an Office 365 site by specifying the required user credentials.
Yes, External Data Connector supports both 32-bit and 64-bit platforms. You can use same setup file to install External Data Connector main application in both architectures (32-bit or 64-bit platforms).
The current version of External Data Connector supports Windows authentication, Forms authentication, Cloud Based Identity and Federated Identity.
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.
External Data Connector supports SQL Server, MS Access, Oracle and any ODBC compliant database, file sources such as XLSX and CSV and also an existing SharePoint list.
Using the Query Builder tool, multiple tables can be merged by specifying JOIN conditions and Query generated from the Query Builder can be used to integrate result-set with the SharePoint list.
Yes, Database views can be used to integrate with SharePoint list. There are no restrictions in using Database views. Even Views and Tables can be merged to form a result-set.
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.
External Data Connector supports CSV, XLSX and HTML file formats to publish data as a file to Document library.
The following permissions must be enabled to use External Data Connector:
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).
Yes, you can select Create a new list option while providing list details in task wizard. External Data Connector can also create columns for you in the newly created list if the column details are provided or Auto Mapping is selected in the Column mapping step.
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.
You can create a Run now task using the task wizard, and run the task whenever the synchronization is required.
External Data Connector requires an impersonated account to connect to the Exchange Server and retrieve resource information (mail items and attachments in mailboxes) stored in Exchange Information Store.
External Data Connector supports Exchange Server 2013 / 2010 / 2007 and also Office 365 Exchange online.