MSSCCI magic! Integrate Oracle PL/SQL Developer with Team Foundation Server

  • [アーティクル]

I have recently worked on a migration project with one of our customer for ALM implementation and adoption across the whole organization, the customer has a large team of Oracle developers using PL/SQL Developer tool to develop Oracle projects.

PL/SQL Developer is an IDE that is specifically targeted at the development of stored program units for Oracle Databases, we  want to provide a native Source Control experience from within this tool to support the team adapting Team Foundation Server Source Control first and them embracing the whole Application Lifecycle practices and features.

Looking into what options the tools support to integrate version control, MSSCCI always jump to my head whenever the discussion is around integrate legacy tools.

Microsoft Visual Studio Team Foundation Server 2013 MSSCCI Provider enables integrated use of Team Foundation Version Control with products that do not support Team Explorer integration.

Hereunder a step by step guide on how to integrate the Oracle PL/SQL Developer with Team Foundation Server Source Control:

  1. Download and Install Version Control Interface plug-in (Oracle PL/SQL Developer plug-in) from here https://www.allroundautomations.com/download/vcs124.zip
  2. Download and Install Microsoft Visual Studio Team Explorer 2013 from here https://www.microsoft.com/en-us/download/details.aspx?id=39314
  3. Download and Install Microsoft Visual Studio Team Foundation Server 2013 MSSCCI Provider 32-bit from here https://visualstudiogallery.msdn.microsoft.com/06c8e056-7f77-4a5c-9b8b-49318c143df8
  4. Open Oracle PL/SQL Developer Tool you should have a new menu for version control called VCS
  5. Click on VCS –> Open Project.
  6. Provide the following parameters in the dialog
    1. System: choose the source control provider in our case Microsoft Team Foundation Server MSSCCI Provider
    2. Project: click on the folder icon to connect to Team Foundation Server and then pick the project you’d like to source control the objects to.
    3. User: By default TFS connection will add the workspace owner once you picked the project from TFS projects list.
    4. Local Path: By default TFS connection will add the workspace folder mapping.
    5. Aux Path: By default TFS connection will add the project URL on TFS.

image

Once done, you’ll get the Version Control options available for use and anytime you need to open Team Explorer you can do that from the same tool through “Run Team Foundation… ” menu item for stuff like work items and collaboration.

image 

In closing:

  • You can natively have version control options from PL/SQL Developer tool using MSSCCI provider.
  • For collaboration and other team activities that Team Foundation Server provide for the developers (away from any platform dependency) you can use Team Foundation Server Explorer to manage that.

Comments

  • Anonymous
    July 14, 2014
    Great post! It works like a charm! Thank you!

  • Anonymous
    November 18, 2014
    The comment has been removed

    • Anonymous
      June 06, 2016
      I am facing a similar issue as Locarno. After I connect to TFS and try to check-in/check-out any file, Pl/SQL Developer just hangs with an empty child modal window. It also locks down the tool, so I have to forcefully close PL-SQL developer.Any suggestions/help?Thank you.

  • Anonymous
    January 08, 2015
    TFS connection disconnects after PLSQL closed. how to open connection automatically once the PLSQL opens ?

  • Anonymous
    January 04, 2017
    it works for me, but after add stored procedure which i created in PL SQL developer how to deploy this procedure from TFS2015 server to another oracle database ?