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

Codeless
Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

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 an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
Performance

Our software offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.

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.

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.

Microsoft Project Server SSIS Components


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

D. Ng

Senior DBA

ASCO