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 : 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]

RECENT POSTS


US Memorial Day eOne Office Hours - May 27th, 2019
SmartConnect Bootcamp in St. Louis - Don't Miss It!
Directions North America 2019: We Loved It!
Tech Tuesday: Creating a Popdock endpoint to use with Power BI
SmartConnect Office Hours Recap for May 17th, 2019

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps

CATEGORIES

ARCHIVES

open all | close all

TAGS

CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk