Category: SmartConnect

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

With SmartConnect installed and configured, the last step is to verify that the GP Connection is working. This is done by checking to make sure the e Connect nodes are available.

Select the Maintenance tab and click on Node Maintenance button on the GP Connector section of the action pane:

Continue reading “Implementing SmartConnect: Verify Connector Working”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

Despite system maintenance having run automatically when the SmartConnect GP Connector was configured, it needs to be run again. Do this by selecting the Setup tab and click on System Maintenance:

Continue reading “Implementing SmartConnect: Run System Maintenance”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

For SmartConnect to function correctly, the service account needs to be added as a user. Do this by opening the Security window from the Setup tab:

Continue reading “Implementing SmartConnect: Configure Security”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

The next step in implementing SmartConnect is to configure the connector with Microsoft Dynamics GP; do this by clicking on the Setup tab and then on the Setup button on the action pane:

Continue reading “Implementing SmartConnect: Configure GP Connector”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

Over the last few posts, I’ve stepped through the installation of SmartConnect and the GP Addin. With that done we can now log into SmartConnect itself and go through the final steps of preparing it for use.

SmartConnect is launched from the Windows Start menu; the first run should be using the account used to install it as this is the first administrator account. The server name will already be displayed, so click OK to login (login used Windows authentication):

Continue reading “Implementing SmartConnect: Console First Run”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

With the SmartConnect GP Addin installed the next step is to use it to populate the GP Resource Cache.

To do this open the SmartConnect Maintenance window (Microsoft Dynamics GP menu » Tools » SmartConnect » SmartConnect Maintenance) and click the Process button:

Continue reading “Implementing SmartConnect: Update GP Cache”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

The next step in installing SmartConnect, is to install the GP Addin. This was in the zip we downloaded as part of the installation post; launch the SmartConnect GP Addin….exe.

Select the relevant version of Microsoft Dynamics GP from the list and click Next:

Continue reading “Implementing SmartConnect: Install GP Addin”

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

A couple of days ago, I covered the installation of SmartConnect, but there are a few additional steps required.

One of these steps is to configure the SmartConnect account with access to update mdgp. This account is the one used by SmartConnect when running the maps; it requires DYNGRP access to all of the mdgp databases in order to both select, insert and update information.

To do this, open SQL Server Management Studio, expand the Security and Logins nodes, find the SmartConnect user account created during the installation, right-click and select Properties.

Select User Mapping, select the DYNAMICS database (assuming you’re using the default system database name), scroll down in the bottom of the window and mark DYNGRP:

Repeat the above step for all of the companies databases and then click OK to commit the changes.

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

Once the core of SmartConnect has been installed, there are a few steps which need to be completed. The first of these is to configure the eOne SmartConnect Service to start with Windows. In theory it is configured to do so during the installation, but I’ve found that the service tries to start before SQL Server, but fails. This service needs to be running to allow maps to be scheduled to run automatically.

To remedy this problem, you have two options:

1. Configure the service startup to Automatic (Delayed Start).
2. Add a dependency for Microsoft SQL Server to the service.

Either one of these options, should be sufficient to remedy the issue and allow the service to correctly start and therefore allow maps to be scheduled.

This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

The first step in installing SmartConnect from eOne Solutions, is to download the installation media. SmartConnect can be downloaded from here. I’d always advise downloading the latest version, especially as SmartConnect is backward compatible with many versions of Microsoft Dynamics GP.

Continue reading “Implementing SmartConnect: Installation”