Skip to content
+1-888-319-3663

Calling MySQL Stored Procedures

How do I call a stored procedure in my MySQL database using SmartConnect? Once you have connected to your MySQL database using the ODBC Connection type, per this article Connecting to ODBC Datasources, you can use the syntax below. Call MyStoredProcedure(parameterList); If you need to find the name of the stored procedure you can use the…

[Read More]
Tech Tuesday

Tech Tuesday: Understanding Dynamics GP eConnect Errors

It’s inevitable that when creating an integration to Dynamics GP there are going to be errors returned at some point in the process due source data differences, mapping data incorrectly or differences in eConnect business logic. We might have missing vendors or customers or distributions amounts don’t match documents amounts or we haven’t provided a…

[Read More]
Tech Tuesday

Troubleshooting ODBC Data Source Errors in SmartConnect

*Only applies to versions of SmartConnect 20.18 and olderOne of the most common methods of integrating data using SmartConnect are Microsoft Excel Files or flat files such as comma or tab delimited. To make connecting to these files quicker and easier, SmartConnect contains a list of Excel versions that can be selected or we can…

[Read More]
Tech Tuesday

Using SmartConnect to connect to ODBC Data Source

While SmartConnect has several default connectors for Microsoft Dynamics GP, Microsoft Dynamics CRM and Salesforce.com there are many more connections that can be created using an ODBC Data Source. Within the SmartConnect User Interface several ODBC connections have been listed by default as examples that can be used in SmartConnect.We are going to look at…

[Read More]
Tech Tuesday

Next Dynamics GP Document Number with SmartConnect

When integrating transaction data into Dynamics GP many times the data source does not have a document number that can be used or should not be used. This requires users to either create their own document number scheme or retrieve the value from Dynamics GP setup tables. Thankfully, SmartConnect has a simple method to retrieve…

[Read More]

Tech Tuesday: SmartConnect Processing Sequence

Our Director of Professional Services, Lorren Zemke, will be taking you through the SmartConnect processing sequence for this week’s Tech Tuesday! In this article I am continuing my series of discussions on how SmartConnect processes data. Previously I’ve used examples on summing values and working with line sequence numbers. Today I will diagram the process…

[Read More]

SmartConnect Windows Service

I hope to clear up some confusion about the One SmartConnect Windows Service functionality and where/how it should be installed for SmartConnect to function properly.  The main purpose of the Windows Service is to execute SmartConnect maps on a scheduled basis but is also used to manage changed data source records and map logs.  …

[Read More]

RECENT POSTS


2023 Advanced SmartConnect Bootcamp: REST Web Services Integration
Accessing Your Historical Dynamics NAV Data in D365 Business Central - Part 1: Getting Started
2023 Migration from Dynamics GP to D365 Business Central Training
eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner
Employee Spotlight: Floyd Jones, Front End Developer

POPULAR POSTS


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

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training