SmartConnect Configuration
Tech Tuesday: Understanding SalesForce queries in SmartConnect
This week we are going to go over something that can be very challenging for someone that doesn’t come from a SalesForce background. We will go into detail about how to build a SOQL query using the developer console in SalesForce and how to join multiple SalesForce Objects. Where to build a SalesForce querySmartConnect on-premise has…
[Read More]
Tech Tuesday: Using GETMAPXML/VAR to pass in parameters to a map and getting the data back
While we position SmartConnect as a tool where you don’t need to be a developer to create integrations, we have quite a few developers that want to take advantage of our interface but have all of the power to call a map whenever needed. In the example below we will explore using the GETMAPXML funtion…
[Read More]Business Central error- Key “XXX” is not well formed! – when trying to delete a record
I’m trying to delete a Customer record in Business Central/NAV using the SmartConnect SOAP CustomerCard endpoint.When I run the integration, it fails with the error:Failed to delete record with Keys ‘Key = XXX’ Key “XXX” is not well formed!Why do I get this error?The reason for the error is a mismatch for the data provided…
[Read More]
Tech Thursday: Resetting the web client password in SmartConnect
One question I’ve seen come in a few times recently is “how do I reset the web client password in SmartConnect?” It’s easy. Simply follow my steps below and you’ll be well on your way. Open SmartConnect, hit the “Setup” tab, and then click on the “Security” button. Highlight the user you want to change the password…
[Read More]
Running SmartConnect from PowerShell
Many people are choosing to do administration of common tasks using PowerShell and the SmartConnect customer base is no different. Below you will find a simple script that will allow you to run a SmartConnect map to any destination directly from PowerShell:###Start Script#Define Path to RunMapConsole.exe$RunMapConsolePath = “D:\Program Files (x86)\eOne Solutions\SmartConnect\eOne.SmartConnect.RunMapConsole.exe”#Specify the Map ID to…
[Read More]
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 : Using Parameters to Enhance the REST Connector Setup
Hey everyone! Today we are looking at using different parameters within the REST Connector to either give additional options during running the map, pass through header information on any request, or to allow for bulk adjustments on the setup of the endpoints/methods themselves.This article is aimed at users who have worked with the REST Connector…
[Read More]SSL Security error using OLEDB Connection
This error may be caused by the Transport Layer Security (TLS) version 1.2 being the only enabled version on the SmartConnect Server. TLS 1.2 support for Microsoft SQL Server If you are using TLS 1.2 on your server that runs SmartConnect with TLS 1.0 and 1.1 turned off, the OLEDB Connection Data Source will no longer work. …
[Read More]
How to make Salesforce and Dynamics NAV work together
Your company has outgrown their current ERP systems and needs to upgrade. With unique business needs, you need software that is both easy to use, highly configurable, and will scale as your business continues to grow. Your company chooses Salesforce and Microsoft Dynamics NAV.Both powerful systems have their respective experts to set things up to…
[Read More]
Don’t Miss: SmartConnect Bootcamp in Vegas
Do you have team members who would be interested in attending on-site training for SmartConnect in Las Vegas on January 23-24th? In the Las Vegas SmartConnect Bootcamp, we’ll cover a deep dive on SmartConnect integration options, using eOne’s integration templates and best practices for delivering a successful integration project. You can learn more about the SmartConnect Bootcamp course description, pricing and discounts available here.Here is the direct…
[Read More]