web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans