Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Advantages of Custom eConnect XML Nodes

Posted on 2011-09-08
2
Medium Priority
?
957 Views
Last Modified: 2012-05-12
I am familar with the practice of attaching custom data in an eConnect transaction as documented here:
http://msdn.microsoft.com/en-us/library/bb625126.aspx

And illustrated well here:
http://www.timwappat.info/post/Piggyback-your-data-on-eConnect-for-Dynamics-GP.aspx

But outside of transactional consistency, what is the advantages of this method over simply calling a stored procedure directly in GP?  In my case, when inserting a budget master record, I need to insert a row of data into a standalone table inside of GP .  I'm having a hard time justifying the extra work of attaching the extra xml over just inserting the row directly.
0
Comment
Question by:b_levitt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 2000 total points
ID: 36506243
Hi,

I would agree with you in questioning the value, and would actually reverse the question and have someone try and answer it.

"Why would I want to add custom XML nodes to my eConnect transactions?"

Like most things technical and development related, there are often several different ways of accomplishing a goal or meeting a requirement.

My preference is to try and keep things as simple as reasonably possible.  If I have a choice between a few lines of code calling my very reliable classes and methods to insert non-eConnect data into GP, or writing code to somehow serialize and/or insert custom XML into an eConnect XML document so that eConnect can then call a separate custom stored proc, it's obvious to me which option I'll choose.

eConnect is great for what it is and what it does, but I'm not enamored enough with it to start having it do my non-eConnect database work for me.  It's easy enough to use an If statement in my code to see if eConnect succeeded or failed, and to manage my remaining inserts from there.

In most cases, reading from and writing to GP SQL Server tables is very simple and straightforward, and does not require anything elaborate.  So I stick with simple and straightforward.

The one extra feature that I have occasionally taken advantage of with eConnect are the User Defined fields present in most eConnect schemas.  Those are handy for inserting a few custom fields related to a transaction using the eConnect Pre and Post procs.  Sure, you could write your own code, but Pre and Post procs and 5 UDF nodes are simple enough that they pass my smell test for simple and straightforward.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 
LVL 11

Author Closing Comment

by:b_levitt
ID: 36510247
Your feedback is enough for me Steve.  Especially since your previous help is what is allowing me to cover transactional consistency outside of econnect:
http://www.experts-exchange.com/Software/Industry_Specific/Financial/Great_Plains/Q_24786364.html
Thank you,
B
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question