Solved

Advantages of Custom eConnect XML Nodes

Posted on 2011-09-08
2
945 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
2 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

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…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

785 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