Browse Prior Art Database

Microsoft Dynamics SL Connector Service to MS Project Server 2007

IP.com Disclosure Number: IPCOM000174880D
Original Publication Date: 2008-Sep-26
Included in the Prior Art Database: 2008-Sep-26
Document File: 7 page(s) / 294K

Publishing Venue

Microsoft

Related People

Greg Ozawa: INVENTOR

Abstract

If a user is currently using both software packages, dual manual updates of common information stored between MSDSL and MSP will need to be performed.. A Windows® integration service was developed that enables the passing of information from one service to another. This new service eliminates dual manual updates of common information that is stored between different software packages such as MSDSL and MSP. This service allows project managers in MS Project Professional to define projects, tasks, and schedules and then send that information to the MSDSL enterprise resource planning (ERP) system.

This text was extracted from a Microsoft Word document.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 36% of the total text.

Microsoft Dynamics SL Connector Service to MS Project Server 2007

            Microsoft Dynamics SL (MSDSL) is an Enterprise Resource Planning (ERP) and Financial Management solution that has limited resource scheduling of employee/resources and the tasks to which they are assigned; whereas, Microsoft Project Server 2007 (MSP) has a robust scheduling engine.  Companies that use both sets of software may have Project Managers who schedule using MSP based on ERP information.  Scheduling/ERP information includes information pertaining to projects, tasks, resources, timelines, team members, hours worked, budgets, etc.  If a user is currently using both software packages, dual manual updates of common information stored between MSDSL and MSP will need to be performed.  This is inefficient and time consuming. 

            A Windows® integration service was developed that enables the passing of information from one service to another.  This new service eliminates dual manual updates of common information that is stored between different software packages such as MSDSL and MSP.  This service allows project managers in MS Project Professional to define projects, tasks, and schedules and then send that information to the MSDSL enterprise resource planning (ERP) system.  From the MSDSL accounting system, project managers can maintain projects, tasks, resources and capture actual work hours and labor costs from the posting processes.  The process of integrating the scheduling information will be completely seamless.

            Described herein is a bidirectional asynchronous service that controls posting of transactions to or from MSDSL and MSP.  Transactions are captured in queue tables in respective databases.  The service also maintains and respects existing Windows® accounts, user roles, and permissions as defined in the respective solutions.  The service uses a multi-threaded approach to control posting information, suspending or reposting of transactions. 

            The integration service starts multiple threads depending on the number of MS Project Servers allocated, with the minimum number of servers (in one implementation) being two.  One thread is dedicated to managing queue record transactions from MSDSL to MSP.  For each provisioned Project Server, a new thread is created to manage the queue record transactions from each MSP instance back to the MSDSL.  In the previous integration between MSDSL to MSP, all MSDSL applications that needed to pass data to MSP made individual calls to the Project Server Data Web Service (PDS).  Suspended transactions would be stored as an Extensible Markup Language (XML) file.  An administrator in charge of the integration would manually run a program in order to process these transactions.  The integration serv...