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.
I found Dockit product through SharePoint.com and found it extremely useful. We used Dockit to import hundreds of documents into SPS. Users were in desperate need for them but refused to take the time to upload them. Dockit saved us the upload time, and more importantly, made the information available in a timely fashion. Small issues were worked out quickly by a capable and dedicated customer support staff.
We find that Dockit is an extremely valuable tool for migrating intranet content to SharePoint Portal Server. When you are faced a large number of documents to migrate each of which has to be populated with metadata, Dockit reduces considerably the effort involved in publishing information. Typically it reduces the time a user has to spend per document by 75%, by enabling documents to be published in batch mode rather than real time through the standard SPS interface.
The Dockit application proved extremely useful for importing large numbers of files and folders quickly and easily into SharePoint. Previously, we were having to import files individually, but through using Dockit we were able to deal with huge directories in a fraction of the time that it would have taken. An excellent tool, really glad we found it.
We used Dockit to import over a thousand engineering documents, preserving the folder structure. It was simple to use and saved us a lot of time.