›> ›> 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.


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


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