Open Forum

Expand all | Collapse all

integration manager running without Dynamics GP?

  • 1.  integration manager running without Dynamics GP?

    Posted 11 days ago
    Edited by Eric Anopolsky 10 days ago
    EDIT: Please be advised I have found the answer, but I will be leaving this post in place in case anyone else has the same question later and starts by searching the forum.

    Whether a given integration will run without Dynamics GP installed, running, and authenticated depends on the type of destination adapter that the integration uses. Integrations using the "Dynamics GP eConnect" destination adapter will work, but integrations using the "Dynamics GP" destination adapter will not.

    The problem description I originally wrote below implies that I was running the same integration interactively and through IMRUN, but after reading the eConnect and Integration Manager manuals and taking a second look, I discovered that was not the case.

    Thanks,
    Eric


    ------------

    Good morning,

    Please be advised I would appreciate some assistance understanding how Integration Manager could be working correctly when Dynamics GP is not working correctly. All of the documentation I have read indicates this is impossible, but it appears to be happening on one of our servers.

    Here are the relevant facts:

    * In our production environment, we are using Dynamics GP 2016, having upgraded from 2015 in March. All of our accountants have Dynamics GP 2016 installed on their individual workstations, and it is working fine for them.

    * We have a server that is responsible for performing one task: receiving messages about POs created in an external purchasing system and importing those POs into Dynamics GP through Integration Manager. It has a scheduled task that executes 'C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 14\Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe /I "Integration Name" /S' every five minutes.

    * The scheduled task is working perfectly. Every time a PO is created in the external system, that PO appears in our production environment after about five minutes. I have verified this as of today.

    * On that server, Dynamics GP 2016 has _not_ been installed. Dynamics GP 2015 is still installed, along with Integration Manager 14 and eConnect 14.

    * If I remote into the server, manually open Integration Manager, and try to run "Integration Name", it tells me that Dynamics GP must be running in order to run integrations.

    * If I start Dynamics GP 2015 (the latest version installed there), and attempt to log in, it gives me this error message: "You are using an earlier version of Dynamics.dic than the one that's currently installed on the network." As soon as I dismiss this error, Dynamics GP 2015 immediately closes.

    * Examining the process list shows that Dynamics.exe is not running. However, the integration is still being run successfully every five minutes.

    Please let me know if you have any ideas about how this might be happening.

    Thanks,

    ------------------------------
    Eric Anopolsky
    New Mexico Military Institute
    Roswell NM
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: integration manager running without Dynamics GP?

    TOP CONTRIBUTOR
    Posted 10 days ago
    The reason is because of the difference in backends between the two types of integrations.  The standard ones are really just macros - they still want to traverse the Dynamics GP windows, plug in values, and hit buttons.  The eConnect ones actually tie into the stored procedures used to put the data in the database - which is consequently why they are typically faster as well.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: integration manager running without Dynamics GP?

    Posted 10 days ago
    Good afternoon,

    Please be advised I appreciate the additional information as I had been wondering how the plain "Dynamics GP" destination adapter worked.

    The more I learn about Integration Manager, eConnect, Dynamics GP, and our environment, the more appealing it seems to implement new integrations by writing my own applications that call the stored procedures directly. It seems like the code would be cleaner, there would be fewer opportunities for error, and should we ever decide to transition to Dynamics 365, updating the integrations would be faster.

    My employer does not have a need for new integrations right now, so this is just idle curiosity, but I would be curious to hear your thoughts on the advisability of this approach as someone who is experienced with Integration Manager.

    Thanks,

    ------------------------------
    Eric Anopolsky
    New Mexico Military Institute
    Roswell NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: integration manager running without Dynamics GP?

    TOP CONTRIBUTOR
    Posted 9 days ago
    The Microsoft-provided adapters have been developed and tested by insiders so as to be dependable, but I realize that they don't cover every data integration need.  I looked into writing my own in one instance and after trying to dig through about five procedures determined that the code research necessary was cost- and time-prohibitive.  If you take it on as a hobby, I know I would be very interested in what you find!

    PS - Dynamics 365 is a completely different product, BTW.  It is NOT an upgrade to any of the existing Dynamics products (GP/NAV/AX).  Anything done in Dynamics GP is unlikely to transfer to that platform.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: integration manager running without Dynamics GP?

    TOP CONTRIBUTOR
    Posted 9 days ago
    Hi @Eric Anopolsky
    I agree with @Blair Christensen that the biggest benefit of Integration Manager and eConnect are they they are well tested and they provide the data validation that would happen if you did the entry directly in GP.

    But if you're looking for more sophisticated and user friendly importing,  you should take a look at SmartConnect by eOne.  It has a nice user interface but also allows for advanced scripting of data before importing, scheduling of import in multiple ways and much more.
    It is a great import tool!
    Thanks
    Windi​​

    ------------------------------
    Windi Epperson
    Customer Support Manager
    Njevity, Inc
    Norman OK
    720-870-9700 x104
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: integration manager running without Dynamics GP?

    Posted 7 days ago
    Good morning,

    @Blair Christensen, thank you for the insight into the benefits and drawbacks of Integration Manager adapters vs eConnect. Per your request, I will provide updates on my findings should I take this on as a personal project "off the clock."

    @Windi Epperson, thank you for bringing SmartConnect to my attention. I will consider it if my employer requires any additional integrations to be developed.

    Thanks,
    ​​

    ------------------------------
    Eric Anopolsky
    New Mexico Military Institute
    Roswell NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role