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
  2. Download and Install Microsoft Visual Studio Team Explorer 2013 from here
  3. Download and Install Microsoft Visual Studio Team Foundation Server 2013 MSSCCI Provider 32-bit from here
  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.


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.


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 (5)
  1. Maksat Maratov says:

    Great post! It works like a charm! Thank you!

  2. Locarno says:

    Unfortunately, after I do all this and choose my project in "Open Version Control Project", PL/SQL Developer just hangs, with a totally empty child modal dialog box titled "VCS" that I cannot close. Any thoughts on what I can do to overcome this?

    1. Tailor says:

      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.

  3. Ugur says:

    TFS connection disconnects after PLSQL closed. how to open connection automatically once the PLSQL opens ?

  4. enhbaatar says:

    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 ?

Comments are closed.

Skip to main content