Implementing SmartConnect: Run System Maintenance

eOne SolutionsThis 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:

SmartConnect Setup tab

Continue reading “Implementing SmartConnect: Run System Maintenance”

Implementing SmartConnect: Configure Security

eOne SolutionsThis 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:

SmartConnect Setup tab

Continue reading “Implementing SmartConnect: Configure Security”

Sites Migrated to New Host

azurecurveOver the course of this weekend I have migrated my websites to a new web host; hopefully, the only difference you will notice is that the sites are now being served over an https connection.

However, if you do notice any issues, images not loading or broken links (I’ve moved from a Windows hosting package to a Linux one so case now matters) ,for example, I’d appreciate you leaving a comment below with details.

Update: I forgot to mention, that when I migrated the sites to a new host, I also migrated them from WordPress to ClassicPress.

Windows 10 Calculator Replacement: Conclusion

ApplicationsThis post is part of a series on the Old Calculator for Windows 10 replacement for the default Windows 10 Calculator App.

The Old Calculator for Windows 10 app installs a calculator which looks like the one in Windows 7 and before.

The best reason I ahev for using this replacement, is the speed of launching. I find that apps from the Microsoft Store take so long to load; this replacement starts very quickly (just the the calculator of old).

Implementing SmartConnect: Configure GP Connector

eOne SolutionsThis 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:

SmartConnect Setup menu

Continue reading “Implementing SmartConnect: Configure GP Connector”

Implementing SmartConnect: Console First Run

eOne SolutionsThis 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):

SmartConnect Login

Continue reading “Implementing SmartConnect: Console First Run”

Implementing SmartConnect: Update GP Cache

eOne SolutionsThis 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:

SmartConnect Maintenance

Continue reading “Implementing SmartConnect: Update GP Cache”

Implementing SmartConnect: Install GP Addin

eOne SolutionsThis 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:

SmartConnect - Select which components of SmartConnect GP Addin will be installed

Continue reading “Implementing SmartConnect: Install GP Addin”

Implementing SmartConnect: Assign SQL Login Security

eOne SolutionsThis 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:

SQL Login Properties

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