Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Using eConnect to rece...
Finance | Project Operations, Human Resources, ...
Suggested answer

Using eConnect to receive data from Microsoft GP

(0) ShareShare
ReportReport
Posted on by Andrew1986 63

Hello Team,

I am going to use eConnect to integrate data with Microsoft GP.
I got acquainted with the specification eConnectProgrammersGuide.pdf, but I have some questions.

1. Should the Customer open access to the database so that to apply synchronization via eConnect?

2. How to comply with the security during using eConnect, because it is direct access to the database?

3. Perhaps there are some other features of using eConnect?

4. How did you solve the situation when the Customer didn't want to open access to the database to use eConnect?

Categories:
Microsoft Dynamics GP
  • Andrew1986 Profile Picture
    Andrew1986 63 on at
    RE: Using eConnect to receive data from Microsoft GP

    Thank you!

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Using eConnect to receive data from Microsoft GP

    With eConnect, it is usually the eConnect service account that is needing the access to SQL server and GP databases.

    In the eConnect install guide, it states that the eConnect service uses SQL Server Integrated security to connect to the eConnect business objects.

    When you installed eConnect, you specify a service user account, that is usually a domain account.

    This account needs to have the DYNGRP database role assigned to it for the GP system and all company databases being used with eConnect.

    This gives the service account the SELECT, UPDATE, DELETE and INSERT permissions on tables and views, as well as EXECUTE permissions on stored procedures, as eConnect is primarily using stored procedures in its processing.

    Thanks

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans