SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 JDE/EXTOL Business Integrator - E1 Database Integration Tips 2

JDE/EXTOL Business Integrator - E1 Database Integration Tips 2

20th February 2014

In an earlier post we reviewed E1 Database Integration Tips, we continue with the Database Integration Tips.


EXTOL EBI ACTION

image

In SQL Actions the E1 Database Schema needs to be present and in double quotes. The table name would follow and also would have double quotes

image

EXTOL EBI SCHEMA

image

Schema Item 1:

Since JDE uses the Data Dictionary(F9210) to store decimal positions, the decimal positions are not stored in EXTOL. If an EXTOL Schema is refreshed, then the numeric fields need to be updated to be implied decimal and the number of decimals inserted.

image

EXTOL EBI RULESET

image

Ruleset Item 1:

For outbound documents using the middle tree updating, it is important to use a rule: “Move” and not any other rule, ie: Move-Trim Left/Right. If trim is applied when EXTOL tries to apply the Database Update Adapter, the correct record(s) will not be found.

Ruleset Item 2:

If a JDE numeric field is set-up in the EXTOL Schema with a decimal position, then each time users move data to the numeric field, the “Move Numeric” rule should be used. This is application to inbound transactions.


EXTOL EBI BINDING

image

Binding Item 1:

When setting up the data selection in a Data Binding, we are basing our criteria on data JDE fields. For example in the outbound 855 we are selecting data on F47026.EDSP and F47026.EDST.

  • For F47026.EDSP we select records where the value is a ’ ’ (single space).
  • For F47026.EDST we select records where the value is ‘855 ’ (855 and 3 spaces)

image


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>