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