Posts Tagged ‘SQL’

Tech Tuesday

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]

The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

The user is running a SmartConnect integration to Dynamics GP.On one machine, the integration fails with the error:Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting…

[Read More]

MSSQL Real-Time Data Source Registration Error

When registering an MSSQL Real-Time data source receive the following error message.Latest version of MSSQL real time data source assembly does not exist in SERVER : DATABASETo enable real time data sources please run the script below as a MSSQL system administrator on the server and try again.How to resolve the error messageIn most cases…

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

Escape Characters in Salesforce.com SOQL Query

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 To handle single quotes or other reserved character in a SOQL query, we need to put a backslash in front of the character ( \ ).…

[Read More]
Tech Tuesday

Tech Tuesday: Executing SmartConnect 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: 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]

RECENT POSTS


Tech Tuesday: Adding Company ID to SmartList Builder Multicompany Summary Report
Join us for the Q4 Partner All Hands Call!
SmartConnect Office Hours: Importing Business Central Contacts
2020 SmartConnect Training Opportunities
SmartConnect Office Hours: Real Time Triggers with MSSQL

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

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