Cost-effective, easy-to-use and high-performance data integration solution for Microsoft Project Server, utilizing SSIS ETL capabilities.

Enables Project Server integration with virtually any application or data source that you may need to work with.

The SSIS Integration Toolkit for Microsoft Project Server

  • High performing data integration for Microsoft Project Server using SSIS.
  • Take advantage of the flexibility and power of SSIS ETL engine.
  • Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
  • Robust error handling and superior performance.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
  • Integrate with virtually any application or data source.
  • Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition including Microsoft Dynamics 365 and SL, SharePoint, Salesforce and many more.

Project Server Data Integration

  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months

    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget

    Flexible and Easy to Use

    We make the most flexible integration solution
    on the market. Our software offers intuitive user
    interfaces that are flexible and easy to use

    Cost Effective

    With a streamlined development experience,
    and a simplified licensing model, our solution
    offers the best value for your investment

  • fill

    The KingswaySoft tool’s UI is
    very intuitive and you cannot beat
    the support they provide.

    D.Ng Senior DBA, ASCO

Unique Features

  • 7 available objects to retrieve data from: Project, Task, Timesheet, TimesheetAction, TimesheetLine, TimesheetLineDetails, or Resource.
  • Specify which data store you are working with (PublishedStore, VersionsStore, WorkingStore or ReportingStore).
  • 5 different actions for writing to Project Server: Create, Update, Upsert, Delete or Publish.
  • Automatic field mapping based on a name-match.
  • Includes Implicit Text Lookup functionality.

Microsoft Project Server SSIS Components

Technical Requirements

  • Microsoft Project Serve, either:
    • Microsoft Project Server Online, or,
    • Microsoft Project Server On-Premises.
  • Microsoft SQL Server Integration Service, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008 R2, or,
    • Microsoft SQL Server 2008.