web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Best option for integr...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Best option for integrating SaaS application to GP

(0) ShareShare
ReportReport
Posted on by C4l3b 5

Hi all,

I have a SaaS application that manages employee time cards and scheduling for payroll (and currently jobs in BC).

We are looking to integrate into GP, and would like to know what method people are using these days. From what I know, there are several options: eConnect, Dexterity, Web Services, .NET SDK, (maybe more?).

We would be reading from and reacting to events from the GP payroll tables (this would be for keeping things like employee records, departments, positions, etc in sync to the SaaS app). I come from the BC world where I can subscribe to webhooks for table changes, so similar functionality would be nice.

We will also be pushing values into the time entry tables from the SaaS app. Right now we initiate a "push" from the SaaS app to BC, but if necessary we could do a "pull" from GP.

I am primarily a .NET developer, so that's where I'm most comfortable.

Just looking to get some feedback on which method to get started with.

Thanks!

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    Members of this Community that do more development with GP will probably have more answers to this question.....

    Off the top of my head, I know that eConnect by default has stored procedures already in Dynamics GP related to payroll, such as these for example:

    taCreateBenefitBasedOnPayDedCodes

    taCreateDeductionBasedOnPayCodes

    taCreateEmployeeBenefitBasedOnPayDedCodes

    taCreateEmployeeDeductionBasedOnPayCodes

    taCreateEmployeePayCode

    taCreateEmployeePayCodePost

    taCreateEmployeePayCodePre

    taCreatePayCode

    taCreatePayCodePost

    taCreatePayCodePre

    taCreatePayrollBatchHeaderInsert

    taCreatePayrollBatchHeaderInsertPost

    taCreatePayrollBatchHeaderInsertPre

    taDeleteEmployeePayCode

    taDeleteEmployeePayCodePost

    taDeleteEmployeePayCodePre

    Visual Studio tools is another option. A couple of samples can be found here:

    learn.microsoft.com/.../mdgp2013_vstoolssamples_349

    Web Services I didn't see much for actual payroll, more creating and updating employees and related information.

    Service Based Architecture (SBA) may be another option for you.

    I'd take a look at these and what the Community mentions and from there, see what may be best for what you're looking to implement with Dynamics GP.

    Thank you,

  • Nicole Albertson Profile Picture
    Nicole Albertson 215 on at

    For any data sending into GP, I'd recommend using the eConnect nodes over web services, dexterity, direct to tables etc. And then for tracking data coming from GP, the easiest route would be to use SQL triggers on the main tables themselves to track when a record is inserted or updated.  You just have to be careful with the SQL Triggers as they can affect the Dynamics GP Updates.

    You may want to consider an integration tool like SmartConnect (Home | SmartConnect (eonesolutions.com)).  It does handle both of these methods through its UI, allowing integrations to send to GP/eConnect, handle sql level change tracking for data coming out of GP.  The great thing for you would be that SmartConnect can also allow connecting directly to BC page services and generic REST services for those systems. This way you could use it for GP and BC if you would like.

  • C4l3b Profile Picture
    C4l3b 5 on at

    Thanks for your input.

    I thought about pursuing the SmartConnect route, but it doesn't feel right as a SaaS platform to require a min. $250/mo just to run our integration.

    I want to do what is most accepted/typical by add on providers. Is it common these days for third party services to directly interface with SQL?

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,976 on at

    I would seriously look at the SmartConnect option for integrations. Then you don't really have to create your own. It is just using all of the eConnect nodes and if something is missing, you can just either program it in or write your own stored procedure.

    Yes, the starting at $250/month seems a bit salty, but considering it's just another platform where everything is maintained for you, it starts to become worth it from a time perspective. They have an on-prem version too.

    Joe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans