Visual Studio Team Foundation Server Integration and Synchronization

 

Visual Studio Team Foundation Server data (on-premise or in the Microsoft Cloud) can be integrated and synchronized codeless with various other data sources using the Layer2 Cloud Connector via the OData interface. Please take a look here for supported systems and applications.

 

​To connect to Visual Studio Team Foundation Server (TFS) data the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

 

Sample configuration of Visual Stuido Integration

Fig.: Sample connection configuration to connect to Visual Studio Team Foundation Server data.

 

 

Please verify the connection settings in the data preview. Should look like this:

 

Data preview: Team Foundation Visual Studio

Fig.: Data preview of the a TFS sample query.

Visual Studio Team Foundation Server (TFS) Specific Configuration Settings

 

​Please note the following specific settings.

 

  • Select the OData Data Provider to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed. You will find a OData Provider specification here.
  • You can use a connection string like this to connect:
    url=https://tfsodata.visualstudio.com/defaultcollection; Collection=WorkItems; User =myDoain\myUser; Password=myPassword; Authentication=Windows.
  • Several different authentication methods are generally supported. See provider specification linked above for more. For known authentication issues see Microsoft TFS OData documentation.
  • You can make use of OData to query your data as supported by the data provider and source system. For any specification of supported queries see Microsoft TFS OData documentation. You can map your data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • Please enter an appropriate primary key (column with unique values), depending on query (see data preview for this).
  • You can use the connection for uni- or bi-directional synchronization. In case of inserts (full CRUD) via external systems please take care of the primary key. TFS-side IDs will not work in his case.
  • No installation or changes are required at the Visual Studio Team Foundation Server (TFS) data source or data destination.
  • Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.

Step-by-Step Intros For Visual Studio Team Foundation Server (TFS) Integration Scenarios

 

Currently no detailed scenarios available. Just some ideas:

 

  • Sync with local SQL or SQL Azure for better reporting.
  • Sync with Microsoft Exchange (on-premises or online) for notifications, tasks, calendar events, mobile access and offline availability on any device.
  • Sync with 3rd party tools based on SQL databases like Oracle, mySQL or Microsoft SQL Server.
  • Sync with Microsoft SharePoint or Office 365 for better collaboration (for example with customers or partners) or for intranet publishing.

Find related solutions here.

Learn more about similar solutions for data migration, backup, integration, and synchronization by vendor and topic.

Ready to go next steps?

Icon for Product Regsitration - Layer2 leading solutions

Register for free download.

Keep your Sharepoint in sync. Download and try today.

Contact Us Icon for Layer2 leading solutions

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.