Skip to content
+1-888-319-3663

EONE BLOG

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 stored procedure through an easy to use mapping interface?

SQL
The SQL destination means that you can update any SQL table you choose, with SmartConnect. This function is extremely powerful in that you can do direct inserts into the table of your choosing via the same SmartConnect interface you are familiar with.

I must have been asked 100 times “Can I use SmartConnet to update my custom table in SQL? Can we push data from GP to Sales Logix? I know the table name and eConnect does not support it, can we just write to it directly? After an import to GP how can we update the source tables with an update flag?”

These sorts of questions always came with work around answers involving writing code or custom nodes. Those days are over. If you are game – you are now able to write data directly to any table anywhere.

The power is great with this feature, but comes with a ‘user be ware’ notice. Obviously the power of eConnect is all the data validation that occurs during integration. The SQL destination by passes the rules – and updates tables exactly how you have mapped it.

Stored Procedure
This is a super cool feature. (Note super cool is not a term I would usually use but I am getting into convergence mode). Safer and more secure than the SQL option above, a stored procedure destination knows no limits. All you need is a stored procedure that inserts data into a table. This Can be a GP table or any other update you can do with a stored procedure.

When you build a map you select a data source as per normal, and then select a destination of Stored Procedure. You can then map your source data direct to the destination fields of the stored procedure within SmartConnect. When you bundle this feature with the stand alone interface we discussed in the last blog entry – you can use SmartConnect to integrate from anywhere to anywhere!


Come and talk to me in Atlanta to learn more.

Leave a Comment





RECENT POSTS


Tech Tuesday: Building My First Matrix Report
Overcoming the Top Challenges of Zendesk Integration
Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features
New Webinar: Getting Started with Matrix Reporting in Popdock

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 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 Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.