Implementing SmartConnect: Who Are eOne Solutions?

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).

I’ve done a small number of posts before on eOne’s SmartList Builder previously, but this is the first series of posts I’ve done on one of their products.

I’m sure everyone using Microsoft Dynamics GP is aware of who eOne Solutions are, but in case you don’t, eOne are a Microsoft Dynamics GP ISV (Independent Software Vendor) based in Fargo, North Dakota, and with offices in Texas and Australia.

They have created a number of products which either install into Microsoft Dynamics GP or which integrate with it:

  1. SmartConnect – the subject of this series is an integration tool which allows you to integrate lots of different systems with Microsoft Dynamics GP.
  2. Extender – allows you to create new windows and forms for Microsoft Dynamics GP, without needing the services of a developer.
  3. SmartView – provides an alternate, fast and flexible interface to the existing SmartLists.
  4. Node Builder – allows easy creation of new eConnect nodes to be created without the need for a developer.
  5. Flexicoder – allows you to automatically recode Sales transactions with configurable rules and references.
  6. SmartPost – automates the posting of Microsoft Dynamics GP batches.
  7. SmartList Builder – enables both the creation of new SmartList objects or modification of existing ones. Up to 32 tables can be linked and tables can be standard GP tables, any Third Party (ISV) tables, any SQL table, SQL views or SQL Scripts, other SmartLists or Extender resources.

I’ve worked with many clients using SmartList Builder and it has proven to be a very popular tool with them for the ease and flexibility of creating new SmartLists. In more recent times, I’ve also done work with Extender, SmartConnect and NodeBuilder. In this series, I am going to be focused on SmartConnect, but over the coming year, I’ll also be taking a look at some of the other products.

Implementing SmartConnect: Series Index

eOne SolutionsSmartConnect is 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).

I’ve known about SmartConnect for quite a long time now, but have only just started working with it and thought a series of posts on the installation and configuration process might be useful to do.

The index below will update as each post goes live if you are reading directly here (if you’re reading on a syndicated version, you will need to check back to the original post).

Implementing SmartConnect
Who Are eOne Solutions?
Introduction
SmartConnect vs. Integration Manager
System Requirements
Prerequisites
Installation
Configure Windows Service
Assign SQL Login Security
Install GP Addin
Update GP Cache
Console First Run
Configure GP Connector
Configure Security
Run System Maintenance
Verify Connector Working
Conclusion

A Diary of reIMAGINE 2016: Part 17 – Conference Day 3/Tips for Creating Integrations Session

reIMAGINE2016The third and final day of the conference was quite a short day with only three sessoins in the morning.

The first of the sessions I attended was Tips for Creating Integrations which was run by a former Microsoftie who now works at eOne. The session did have general tips on what you should be thinking about and asking when creating integrations, but was, as you would expect for a session run by a partner, focused on using their tools. In this case, the tool was SmartConnect.

As a partner of eOne already, SmartConnect was already on my list to take a look at (we currently mainly do SmartList Builder although we also have clients with Extender and SmartView), it was a very interesting session showing how data could be integrated into Dynamics GP from other sources such as Dynamics CRM or a web site and also how the Excel add-in can be used to extract data, and then update Dynamics GP once the user edits the data in Excel.

Much to think about.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index