.Net/C# Integration with E1

mary.e1

Member
We are a .Net shop and are looking for options to create integration processes with E1 (such as G/L, A/R, A/P etc.) using C#. I know we can call the existing BSSV/Business Services from .Net, but would like to create the integration process itself in .Net as it will be easy for us to develop and maintain (sorry, our developers don't like Java, no offense to anyone).

Thanks in advance.
 
Is .NET going to play the role of a middleware here in the true sense ? Are you trying to build services in .NET which JDE E1 can consume ? What basically this integration going to achieve ?
 
We would like to create integrations in .net that can be consumed by external applications. So, a .net program that creates address book and supplier master records in e1, for example. Not using Z tables, of course.

More often than not, I have seen developers create .net proxies to call BSSVs in e1. It would be nice to harness the abundant .net resources to create the integration processes (instead of .net on one side an Java on the other)
 
It looks like there is a product that can do this ... I found this link today: http://stackoverflow.com/questions/15774463/how-to-communiccate-between-jd-edwards-enterprise-one-9-0-and-net. Copying and pasting some sample code from this link below.

private bool CallAddressBookBsfn(BusinessDocument businessDocument, Transaction transaction)
{
AddressBookMaster abm = businessDocument.document.input.AddressBook;
// create an instance of the Address Book Master Business function
// note the use of JDE Transactions
AddressBookMasterMBF bsfn = new AddressBookMasterMBF(transaction);
// set parameters - most of this code is auto-generated
bsfn.DpmnAddressBookNumber.InValue = (long)abm.AddressNumber;
bsfn.DpszSearchType.InValue = abm.AddressType;
bsfn.DpszAlphaName.InValue = abm.Name;
bsfn.DpszAddressLine1.InValue = abm.AddressLine1;
bsfn.DpszAddressLine2.InValue = abm.AddressLine2;
bsfn.DpszAddressLine3.InValue = abm.AddressLine3;
bsfn.DpszAddressLine4.InValue = abm.AddressLine4;
bsfn.DpszPostalCode.InValue = abm.ZipCodePostal;
bsfn.DpszCity.InValue = abm.City;
bsfn.DpszState.InValue = abm.State;
bsfn.DpszCountry.InValue = abm.Country;
bsfn.DpcActionCode.InValue = 'A';
bsfn.DpcUpdateMasterFile.InValue = '1';
// execute the business function
if (bsfn.Execute() != BusinessFunctionResult.Success)
{
// get errors
return false;
}
// assign output
businessDocument.document.output.AddressNumber = bsfn.DpmnAddressBookNumber.OutValue;
businessDocument.document.output.AddressNumberSpecified = true;
return true;
}
 
That is correct. Our product (LynX Business Integrator) natively integrates EnterpriseOne using C#. So, you can do the following using .Net (in Visual Studio):
1. Call business functions
2. Table I/O (select, insert, update, delete)
3. Attach media objects
4. JDE Transactions (across 1, 2 and 3 above - no transaction server required)
5. Call reports

Note that this all of this is through EnterpriseOne’s application layer – so, no direct database access. A demo of this is available on YouTube here: http://www.youtube.com/watch?v=3GJjhEeHe_Q.

BTW, this product is Oracle Validated for both 9.0 and 9.1:
http://www.oracle.com/us/partnerships/solutions-catalog/ds-aellius-jde-e1-9-1-1730280.pdf
http://www.oracle.com/us/partnerships/ds-aellius-jdee19-0-1555292.pdf
 
That is correct. Our product (LynX Business Integrator) natively integrates EnterpriseOne using C#. So, you can do the following using .Net (in Visual Studio):
1. Call business functions
2. Table I/O (select, insert, update, delete)
3. Attach media objects
4. JDE Transactions (across 1, 2 and 3 above - no transaction server required)
5. Call reports

Note that this all of this is through EnterpriseOne’s application layer – so, no direct database access. A demo of this is available on YouTube here: http://www.youtube.com/watch?v=3GJjhEeHe_Q.

BTW, this product is Oracle Validated for both 9.0 and 9.1:
http://www.oracle.com/us/partnerships/solutions-catalog/ds-aellius-jde-e1-9-1-1730280.pdf
http://www.oracle.com/us/partnerships/ds-aellius-jdee19-0-1555292.pdf

Can we extract media objects from attachments?
 
Back
Top