Hands On with Microsoft Dynamics GP 2018 R2: Install Integration Manager

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

In the last post, I installed eConnect on the client to make the eConnect adaptors available to Integration Manager; in this post, I am going to install Integration Manager.

To do this, launch the setup utility and select Integration Manager from under the Additional Products heading:

Integration Manager

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install Integration Manager”

Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect on Client

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

I already stepped through the installation of eConnect on the server, but eConnect is also needed on the client in order to use the eConnect adaptors in Integration Manager.

To install eConnect on a client PC, launch the setup utility and select eConnect under the Additional Products header:

setup utility

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect on Client”

Hands On with Microsoft Dynamics GP 2018 R2: eConnect Incoming Queue Bug Fixed

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

This post is for those people who skipped Microsoft Dynamics 2018 RTM; you might not be aware that the eConnect Incoming Queue bug which required part of eConnect 2013 R2 to be installed has been resolved.

For Dynamics GP 2018, you can uninstall all previous versions of eConnect and just install the new one.

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Hands On with Microsoft Dynamics GP 2018 R2: eConnect Services and Permissions

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

With eConnect installed on the server there are some changes required to the services and permissions. As with the prerequisites, I am going to link back to the posts I did for the last Hands on series.

There are three changes which are required:

  1. Because the files being integrated this way are quite large, the receiceTimeout setting on the Service.config needs to be changed.
  2. The Incoming_Queue.config needs the ConnectionString and Incoming_Queue settings changed.
  3. The permissions on the MSMQ Incoming Queue need setting for Everyone.

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect on Server

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

As mentioned in the last post, on the eConnect Prerequisites, I have a number of clients who use eConnect for integration data into Microsoft Dynamics GP using the Microsoft Message Queue. This uses an eConnect installation on a server.

To install the server eConnect, log onto the server and launch the setup utility. Under Additional Products, select eConnect:

Microsoft Dynamics GP 2018 setup utility

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect on Server”

Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect Prerequisites on Server

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

I have a number of clients using eConnect in different ways for integration. Several of them use eConnect via the MSMQ and Incoming Queue. Before installing eConnect on the server, there are two prerequisites which must be completed.

I’m linking back to the posts I wrote for the eConnect 18 Prerequisites series when Microsoft Dynamics GP 2018 RTM was released as there has been no change in this area.

The first prerequisite, is to set the service account as a local administrator on the server. Without doing this, the eConnect services will not start correctly.

Secondly, you need to install the MSMQ Triggers Windows feature. Without this, the Incomging/Outgoing eConnect queues cannot be installed.

Once these two prerequisites are met, you’ll be ready to install eConnect on the server.

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Hands On With MDGP 2018 RTM: eConnect Incoming Queue Bug Fixed

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

There was a bug in the Microsoft Dynamics GP 2015 and 2016 versions of eConnect whereby the Integration Service was unable to process messages from the Incoming Queue.

I’ve done some testing of this in eConnect for Microsoft Dynamics GP 2018, and I’m delighted to confirm that the bug has now been fixed. This is great news as it means we will no longer need to be installing the Incoming queue for Microsoft Dynamics GP 2013 R2.

My colleague, Laura Bowie, has also informed me that the year end updates for Microsoft Dynamics GP 2015 and 2016 has also seen this bug fixed.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index

Hands On With MDGP 2018 RTM: Set eConnect Incoming Queue Permissions

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the eConnect Service and the eConnect Incoming Queue configured, the final step is to configure permissions of the queue to accept messages.

Launch Computer Management from the Control Panel on the eConnect server. Expand the following nodes:

  • Services and Applications
  • Message Queuing
  • Private Queues

Right click on econnect_incoming and select Properties

Computer Management

In the Group or users names list, select Everyone and set Permissions for Everyone to Full Control. Click OK to accept the changes

Continue reading “Hands On With MDGP 2018 RTM: Set eConnect Incoming Queue Permissions”

Hands On With MDGP 2018 RTM: Configure eConnect Incoming Queue

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the eConnect Service configured, the next step is to configure the Incoming Queue.

This configuration change is done in the eConnect_Incoming.exe.config file which is located, by default, in C:\Program Files\Microsoft Dynamics\eConnect 18.0\Service\Incoming Service:

Windows Explorer

Continue reading “Hands On With MDGP 2018 RTM: Configure eConnect Incoming Queue”

Hands On With MDGP 2018 RTM: Configure eConnect Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With eConnect installed on the server, there are a couple of pieces of configuration which need to be done. The first is covered in this blog post, and that is the configuration of the eConnect Service.

Perfect Image maintain and support a Dexterity Extension written by a company which is no longer a Microsoft Dynamics partner; this customisation receives transactions via eConnect from an external line of business system. The default configuration results in timeouts if the eConnect service isn’t configured to receive large messages; which basically means adding the following to the Microsoft.Dynamics.GP.eConnect.Service.exe.config file:

receiveTimeout="infinite"

To add this element to the bindings node of the configuration file, open Windows Explorer and navigate to the file in C:\Program Files\Microsoft Dynamics\eConnect 18.0\Service.

Edit the node so it looks like the below and then save the file:

Notepad

Stop and restart the eConnect service to ensure the change is picked up.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index