SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Update JDE SQL Actions with Ease in EBI 3

Update JDE SQL Actions with Ease in EBI 3

26th August 2014

EXTOL Business Integrator’s (EBI) 3 Search/Replace functionality allows for easy updating of SQL actions beteween JDE environments. In the 2 examples below, we replace the datasource to point from PY to PD and replace the environment/schema name from TESTDTA to PRODDTA.

EXAMPLE 1:

We have a SQL statement initially pointing to the PY JDE environment  but we need to redirect it to the PD JDE environment. With EBI 3 we can perform a simple search/replace.

EXTOL Business Integrator (EBI) 3 Data Source Update

EXAMPLE 2:

For the same SQL action we need to replace the schema/environment name from “TESTDTA” to “PRODDTA”. We are able to perform this replacement to this SQL statement and other SQL Actions that meet the same criteria.

EXTOL Business Integrator (EBI) 3 Schema Environment Update

For More Information on JDEdwards in EXTOL Business Integrator 3


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 ' '; ?>