Posts by Chris Dew
Tech Tuesday : How to translate your data 5 different ways
There are many times when you are integrating data from multiple systems that you need to translate the values to what the new system expects. Today I will discuss five ways to handle this inside of SmartConnect.We will start with a set of Leads that exist in Excel and we need to bring them into…
[Read More]
Tech Tuesday : Getting more out of Flexicoder by using Extender Windows
Many people have saved thousands of dollars by using Flexicoder to have business rules automatically recode or change distributions in Dynamics GP but sometimes we hear that they would like additional areas that they can use to change the distributions. In this article, we will explore using the built-in functionality of making Extender fields available…
[Read More]
A Guide to Integrating Cloud-Based Applications – Part 2
Last week we discussed the shift to cloud-based applications among business and the various ways those businesses are connecting to their data in the cloud. Today, I’ll give you my recommendations when you are looking at integrating data to or from cloud applications.Five Recommendations for Integrating Cloud-Based Apps:Evaluate your best option. First look to see…
[Read More]
A Guide to Integrating Cloud-Based Applications – Part 1
“We don’t use THE CLOUD at my company, everything is on-premise.”This is what an IT person told me as I spoke with them at a recent conference. After asking a few more questions, he admitted that their custom SQL application did actually call out to a web service to get tax rates…and then he continued:“…and…
[Read More]
Tech Tuesday: Running a Process as a Pre-Map Task and ensuring it finishes before moving on to the next task
This last week I was approached by a customer that wanted to run an SSIS package (that created the data for the Map) but sometimes that task wasn’t finishing before SmartConnect needed to use the result of that task as a data source. In this instance, the desired result wasn’t to run the tasks as…
[Read More]
Tech Tuesday: Removing Unwanted CRM Entities From SmartConnect Mapping
I’ve often seen customers that have begun an integration or migration process to Dynamics CRM and have added entities that they really didn’t want as part of that map or maybe are no longer needed as business requirements have changed. In the following article, we will walk through the steps to remove any entities from…
[Read More]
Dynamics 365 Release of SmartConnect (and other features)
Today we have launched a new version of SmartConnect that provides support for Dynamics 365 as well as Dynamics NAV 2017! We are excited that this release comes within one month of Microsoft’s launch. Included in our new version of SmartConnect are compatiblity features with new releases of Microsoft products, as well as other features and…
[Read More]
Tech Tuesday: Restricting Dynamics CRM Dates To The Current Year
Working with date fields in data can be a challenge and one of those challenges is why you have this subject today. One of our customers asked me if we could restrict some Dynamics CRM data by only pulling records for the current year. I think a few other people may want to do something…
[Read More]
Tech Tuesday: Cancel Map After Maximum Number of Errors
There are not many things that Integration Manager does as well or better than SmartConnect but there is one small little feature that is pretty nice that SmartConnect doesn’t have out of the box. That feature is the ability to quit processing additional records if a certain error threshold has been met. We can add…
[Read More]
SmartConnect 2016 – Feature of the (every other) Day – Named SmartConnect database
Have you ever wanted to test a new version of SmartConnect while keeping the version you have running? Well now you can do it using the same SQL Server! The SmartConnect 2016 release allows you to set the name of the SmartConnect database to whatever you want (ie SmartConnectTEST, SCDEV, SCProduction, etc) and do multiples…
[Read More]