Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to integrate Dynam...
Microsoft Dynamics GP (Archived)

How to integrate Dynamics GP with Sharepoint Business Portal

(0) ShareShare
ReportReport
Posted on by Dylan West 155

I have an integration that pushes new hire information from GP into Active Directory, but now I'd like to push this new hire info into Sharepoint's Business Portal to automatically create an account for each new hire. How can I go about doing this? I have a few guesses:

-Find out what stored procedure business portal uses to create a new user account (perhaps through SQL profiling) and make my existing integration call that stored procedure to create the new account (or do a direct insert into the database table if such a stored procedure doesn't exist)

-Find some third party module for GP that does this already

Any help would be appreciated. Thanks!

*This post is locked for comments

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    RE: How to integrate Dynamics GP with Sharepoint Business Portal

    Dylan,

    I'm not sure offhand.  I'd probably recommend creating some users and doing a SQL Profile to see what is happening behind the scenes.

    Thanks

    Rob

  • Dylan West Profile Picture
    Dylan West 155 on at
    RE: How to integrate Dynamics GP with Sharepoint Business Portal

    Thanks Rob. Do you happen to know if there is some API call I need to use to insert into some of these tables or perhaps a stored procedure I need to call?

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: How to integrate Dynamics GP with Sharepoint Business Portal

    I have not got the part of "new hire" and wish to have further illustration, in order to provide more valuable details on this.

    Let me answer the part regarding "users" being pulled from Active Directory to Business Portal. There are two things to consider when granting access to Business Portal for users in Active Directory:

    • SharePoint Access: the user should be granted access on the associated web pages and sites on which BP operates
    • MBF Role should be assigned to the user.
    After installing BP, you can't find the users until you go to Business Portal Administration and import all the users from Active Directory. You go through several steps in order to assign the MBF role.
    For further details, please check the following post:
    Hope this helps,
  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    RE: How to integrate Dynamics GP with Sharepoint Business Portal

    Dylan,

    The following tables hold user/role information and may be useful:  MbfUser, MbfUserWindowsIdentity, MbfRole, MbfRoleUser.  Keep in mind that SharePoint security controls access to the pages, and MBF security is used to secure the data.  (You'll need to add your new users to at least two places.)

    Thanks

    Rob

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! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans