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

Enables seamless Project Server integration with virtually any application or data source that you may need to work with. Streamline your Project Server workflows and leverage the full potential of your data.

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, Microsoft Dynamics 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 2022,
    • 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 Connection Manager

Microsoft Project Server
Connection Manager

  • The Project Server Connection Manager facilitates connection to Microsoft Project Server web services.
  • Provides different authentication modes, including Windows Authentication and Username/Password, giving users flexibility in connecting to Microsoft Project Server.
  • Efficiently handles Project Server APIs, optimizing communication to ensure smooth and reliable data transfer between SSIS and Project Server.
  •  See this component's documentation.

Microsoft Project Server
Source Component

  • The source component allows you to read data from Microsoft Project Server via web services.
  • Supports custom queries and filters, allowing users to extract specific project data based on their requirements.
  • Enables real-time data synchronization, ensuring up-to-date project information is available for integration with other systems.
  •  See this component's documentation.

Microsoft Project Server Source Component

Microsoft Project Server Destination Component

Microsoft Project Server
Destination Component

  • The destination component facilitates writing data to Microsoft Project Server via web services.
  • Supports bulk data insertion, optimizing the upload process for large datasets to Project Server and reducing processing time.
  • Provides robust mapping capabilities, allowing users to accurately align SSIS data with corresponding fields in Microsoft Project Server for precise data integration and management.
  •  See this component's documentation.

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

D. Ng

Senior DBA

ASCO