With the External Data Connector for SharePoint, users of SharePoint gain access to variety of data imported from external sources, directly into Lists and Libraries. Documents, files, tables and items imported into SharePoint can also have their metadata updated. Necessary metadata can also be exported to the source to update it as necessary. Data is imported from multiple sources and not limited to a few formats. Metadata of imported contents is also updated in SharePoint as well as in the source. It is used as a data synchronization tool to keep both SharePoint and non SharePoint users updated with the latest version of content they use. Data can be synchronized with a variety of sources, making the External Data Connector a cross platform data and metadata synchronization tool. The query generator allows for selection of specific data before importing it into SharePoint. This makes it easy to import data from SQL into SharePoint.