Can SmartConnect integrate with _____?

  Wednesday, May 17, 2017   /     Katie Soderberg   /     0 Comments
One of the most common questions we receive is “Can SmartConnect integrate with ____ ?”  You fill in the blank, and it ranges with everything from billing engines like Braintree to marketing solutions like Hubspot to SQL-based systems as well as eCommmerce. There is certainly a lot of variety… [Read More]

Escape Characters in Salesforce.com SOQL Query

  Tuesday, April 11, 2017   /     Lorren Zemke   /     0 Comments
I am trying to compare a Salesforce.com field with a string that contains a single quote character and I am receiving the error, ERROR at Row:1:Column:390 unexpected token: s … [Read More]

Tech Tuesday: Executing SmartConnect Maps from SQL

  Tuesday, July 7, 2015   /     Chris Hanson   /     4 Comments
There are many ways to execute a SmartConnect map; through the interface, scheduled, called by the web service, etc. But one method that also works which isn’t talked about as much is executing a map directly from SQL. The SQL code below covers both the initial setup needed to run maps in this… [Read More]

Tech Tuesday: Importing into Extender Tables

  Tuesday, December 23, 2014   /     Nicole Albertson   /     3 Comments
The importing of data into Microsoft Dynamics GP can be a very useful tool. When using Extender in your Microsoft Dynamics GP, the likelihood that you would want to import that data is pretty high as well. So, what are the best practices for this? … [Read More]

Tech Tuesday: How to Perform a SQL Trace to Debug eConnect Errors

  Tuesday, August 26, 2014   /     Danielle Erickson   /     0 Comments
This week's Tech Tuesday article is from our Support Guru, David Youngquist, who will walk you through how to perform a SQL trace to debug eConnect errors. 1. Find out what user the eConnect service is running under. Press the Windows + R key on your keyboard to bring up the Run command. Type in… [Read More]

Tech Tuesday: Differences in Real-Time and Change Sources

  Tuesday, April 1, 2014   /     Danielle Erickson   /     2 Comments
For today's Tech Tuesday our Senior Technical Consultant, Chris Hanson, discusses the difference between the change based data sources and the real-time data sources within SmartConnect. Both of the options have their own advantages and uses when you are setting up integrations on your system. … [Read More]

SmartList Builder 2013 New Feature of the Day: SQL Scripting

  Thursday, December 19, 2013   /     Nicole Albertson   /     0 Comments
SQL Scripting is a feature that will soon be available in SmartList Builder and Navigation List Builder with the next release.  You will no longer have to go to SQL Management Studio and create a SQL View to pull into SmartList Builder when you want to write SQL Scripts to get the data you… [Read More]

Tech Tuesday: SmartView and SQL

  Wednesday, December 14, 2011   /     Martin Olsen   /     0 Comments
The built in Visual filter is really powerful with many more options that you would have in traditional SmartList. But there will be times that even with these filter options you can not get the exact data filters you need. If you have a complex query that you can't enter with the built-in visual… [Read More]

New Feature: SQL Destination

  Monday, April 4, 2011   /     Martin Olsen   /     0 Comments
You ask, we listen. This is the theme of our new releases in 2011. The upcoming release of SC contains a brand new destination called SQL and Stored Procedures. Have you ever wanted to do a the equivalent of a table import using SmartConnect? Have you ever wanted to pass source data into a complex… [Read More]

open all | close all