1EDI Source

Your business situation is unique. You need your EDI solution to work for you and your particular needs. 1EDISource is the best source for helping you to get there.

Home  chevron  About Us  chevron  News Room
Error You are using an unlicensed and unsupported version of DotNetNuke Professional Edition. Please contact sales@dnncorp.com for information on how to obtain a valid license.

Mapping Tip: ODBC File Definitions with XML Instead of Delimited

Thursday, August 05, 2010

Are you tired of changing your map when your database structure changes? We can help!!

Often, data is extracted from a database using ODBC and is returned in a delimited/positional format. The more fields extracted, the more fields there will be in the delimited file. When designing the map the field position number is needed. Counting and keeping track from the beginning of the file record to the needed data field can be annoying and time consuming, especially when there are many fields.

EDI/HQ™ has an easier way that makes map designing MUCH easier. Simply change the output from delimited data to XML and then use XPath queries in the map. The data will be automatically formatted with the table field names as node tags. An additional benefit: mapping changes are minimal when fields are inserted into the table.

Using XML and XPath queries will increase accuracy and ease when mapping your outbound EDI by eliminating the need to constantly reference file layouts while creating and editing outbound maps. For more information give us a call 877-EDI-1EDI.

Page Title: EDI Tips & News | 1 EDI Source, Inc. - Mapping Tip: ODBC File Definitions with XML Instead of Delimited