KingswaySoft

SSIS Integration Toolkit for Microsoft Project Server

Manage your Microsoft Project Server data integration quickly and easily with SSIS

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.
  • See help manual for a highlight of the technical features.

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

Project Server Connection Manager

Microsoft Project Server Connection Manager

The Project Server Connection Manager facilitates connection to Microsoft Project Server web services.

Project Server Source Component

Microsoft Project Server Source Component

The source component allows you to read data from Microsoft Project Server via web services.

Project Server Destination Component

Microsoft Project Server Destination Component

The destination component facilitates writing data to Microsoft Project Server via web services.

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

D. Ng

Senior DBA

ASCO