Posts Tagged ‘SQL’
Tech Tuesday: Executing SmartConnect 2018 Maps from SQL
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 manner as…
[Read More]
Tech Tuesday: Adding Company ID to SmartList Builder Multicompany Summary Report
I recently ran into a scenario that I’ve seen a few times before that I thought I’d document in today’s blog article.We’ll document the problem we’re trying to solve, the troubleshooting steps, the underlying issue, and then the solution.The scenario is this:Customer has created a summary report in SmartList Builder that does <something> and they…
[Read More]
Can SmartConnect integrate with _____?
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 out there. To help clarify how…
[Read More]
Tech Tuesday: Importing into Extender Tables
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? Extender Imports: Extender has an import function built into it just…
[Read More]Tech Tuesday: How to Perform a SQL Trace to Debug eConnect Errors
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 “services.msc”…
[Read More]Tech Tuesday: Differences in Real-Time and Change Sources
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. Change based data sources are always handled at the SQL…
[Read More]SmartList Builder 2013 New Feature of the Day: SQL Scripting
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 need.The…
[Read More]Tech Tuesday: SmartView and SQL
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 filter…
[Read More]New Feature: SQL Destination
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]