Ecrion's Data Architect supports calling a function from a .Net/Java assembly in order to customize the data processing. External Functions elements provide the ability to invoke .NET/Java code from an existing assembly.

A method call will be displayed as a regular diagram element, with the input parameters on the left side and the output values as data sets on the right.

 

 

The following sample describes a .NET External Function, named ExternalFunctionSample.FullName:

 

 

In this example, ExternalFunctionSample.FullName has:

- three input parameters (firstName, lastName and gender)

- one output parameter (fullName)

 

Output:

 

       <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

       <ns:root Full-name="Mr. Joe Doe" xmlns:ns="http://www.tempuri.org/XML"/>

 

 

 

The following sample describes a Java External Function, named ExternalFunctionSample.Employees:

 

 

In this example, ExternalFunctionSample.Employees has:

- four input parameters (the data source and the id, firstName and lastName columns)

- five output parameters (the resulting table containing the employee's id, firstName, lastName and FullName)

 

Output:

 

 

       <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

       <ns:root xmlns:ns="http://www.tempuri.org/XML">

               <ns:element-name id="1" firstname="John" lastname="Brown" fullname="John Brown"/>

               <ns:element-name id="2" firstname="Mary" lastname="Jane" fullname="Mary Jane"/>

               <ns:element-name id="3" firstname="Arthur" lastname="Clark" fullname="Arthur Clark"/>

       </ns:root>