Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is it best to create s...
Microsoft Dynamics GP (Archived)

Is it best to create separate IM/Integration Manager databases for separate companies? Any advice?

(0) ShareShare
ReportReport
Posted on by ABrown 69

We have multiple companies on 1 instance of GP, all separate databases. At the present time only a small related subset of those companies use Integration Manager.  I'd like to setup a new integration for one of our larger companies. If I setup a new IM db for this company, will this  cause problems with current integrations?  What are best practices for multiple integrations for multiple companies?  Should each company have it's own IM db? Also, we have 3 Citrix prod servers.  The users usually open the GP company then go to IM via the GP menu.  Any guidance or advice is greatly appreciated.

Thank you. 

*This post is locked for comments

  • Galina Profile Picture
    Galina 1,075 on at
    RE: Is it best to create separate IM/Integration Manager databases for separate companies? Any advice?

    The way IM destination adapters work, if you use regular Microsoft Dynamics GP connector, data will go to the company you are currently logged into. If you use Microsoft Dynamics GP eConnect  destination adapters, you can configure the destination database in adapter settings. So, you definitely can use the same DB for multiple companies.

    As far as Citrix is concerned and running integrations on it, we have it as well. Only limited number of users in our company can create integrations, but many can run. So, initially for each user running integrations, user with administrative privileges in GP had to log on to GP and go to Integration Manager and set up the database in Tools->Options menu. When it sticks in their Citrix profile. I'm sure you could set it up in domain group policies somehow, but for us, since we don't have many GP users in need of running integration, this way was easier.

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Is it best to create separate IM/Integration Manager databases for separate companies? Any advice?

    Hi,

    IM allows to create multiple Integration specific to each company and whenever you are logging in into any of your GP companies, then select relevant Integration in IM for your import process.

    It is not required to have multiple DB because, any Custom Integration will be stored in IM Samples.

    Hope this is fine for your to understand.

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans