Looking for a mapper to take an EDI 810 flat file to an SQL DB
EDI 810 mapping to SQL
| Author | Comment | ||
|---|---|---|---|
 markabt |
EDI 810 mapping to SQL |
Lead | |
|
Posts: 2 (08/30/06 09:48:42) |
|
||
|
Bryce K Nielsen |
Re: EDI 810 mapping to SQL | ||
|
Posts: 230 (09/03/06 16:22:24) Administrator |
In a round about way, yes. You can use xmlLinguist to get the EDI document into XML, and then you can use xmlDig to insert the data into any OLEDB database. We don't have a public application that will tie it all together though. For that you will need to use a scripting or programming language like C# or Delphi.
The flow would be as follows: EDI -> xmlLinguist -> XML -> xmlDig -> SQL DB. And it wouldn't be that difficult to piece it all together with VBScript. Take a look at our tutorial www.sysonyx.com/xml-to-edi-850 to see how VBScript is used with xmlLinguist. You can read more about xmlLinguist at www.sysonyx.com/products/xmllinguist and you can check out the xmlDig beta at www.sysonyx.com/products/xmldig. -BKN |
||
|
Bryce K Nielsen |
Re: EDI 810 mapping to SQL | ||
|
Posts: 230 (09/03/06 16:23:40) Administrator |
I should add that we are working on an EDI/EAI application that will do the piecing together for you without need for a script. It's call xmlLynx and you can see a screenshot at www.sysonyx.com/products/xmllynx
-BKN |
||
|
Eskelvar |
Solution | ||
|
Posts: 1 (01/26/09 09:14:59) |
If you are already exporting into an Excel spreadsheet, create a automated process that checks like... once a day for import into a holding table in SQL for
the speadsheet and that would be the easiest way to get it in your SQL. You may have to take a few tries to get it right, but your SQL is very flexible in
that regards. I'm sure there are others out there that are doing this as well.
|
||
