E9.2 Middleware software for E1 interfaces

[MonsterCable]

We're planning on modernizing our interfaces of E1 with other applications and hopefully add more interfacing to improve automation and less manual work.

Besides Mulesoft & Boomi, does anyone have any other suggestions on other middleware platforms that we should look at?

Currently looking to interface an external WMS SaaS application with E1, but the future applications to be interfaced is yet to be determined. For now, what we know is we're leaning more towards SaaS products.

Thanks.

 

[RussellCodlin]

Really depends on the type of integrations you require and whether you have access to the right resources. If you're going cloud then do you have a preferred cloud IAAS provider? Microsoft, Amazon, Google and Oracle all have solutions. IBM, SAP, Talend, Informatica, Denodo and Qiik are other players in this space.

 

[IanMcGoun]

There are a few options here and it all depends on how these interfaces are to operate;
Will JDE 'pull' the data at scheduled times or will the external systems 'push' data into JDE - is the requirement for that to be 'real time' or on a scheduled batch basis
Are you comfortable to do this via WebServices using the BSSV server and standard business services provided or do you prefer to use flat files via the 'Z' files ? ?
How / where will you perform Error handling and transaction resubmission through your interface ?

All these need to be in the mix in your design stages and I would recommend you produce a high level design / strategy before you start choosing applications to assist in the process. Depending on how you design the interfaces, you may be able to use Orchestrations which is included in your license already without paying out for another product.

 

[MonsterCable]

Really depends on the type of integrations you require and whether you have access to the right resources. If you're going cloud then do you have a preferred cloud IAAS provider? Microsoft, Amazon, Google and Oracle all have solutions. IBM, SAP, Talend, Informatica, Denodo and Qiik are other players in this space.

We are off of Oracle support and will likely be moving to AWS in the future. Does that help in trying to narrow down the solution/vendor?

 

[MonsterCable]

There are a few options here and it all depends on how these interfaces are to operate;
Will JDE 'pull' the data at scheduled times or will the external systems 'push' data into JDE - is the requirement for that to be 'real time' or on a scheduled batch basis
Are you comfortable to do this via WebServices using the BSSV server and standard business services provided or do you prefer to use flat files via the 'Z' files ? ?
How / where will you perform Error handling and transaction resubmission through your interface ?

All these need to be in the mix in your design stages and I would recommend you produce a high level design / strategy before you start choosing applications to assist in the process. Depending on how you design the interfaces, you may be able to use Orchestrations which is included in your license already without paying out for another product.

I think it's too early to tell whether we'll go with pull/push. I think scheduled batch basis is probably the way we'll go.

If we had to choose between BSSV and 'Z' files, we'd go with BSSV. But our preferred option would be to use some sort of REST integration as it looks like that's the future of integrations. Maybe I'm wrong though and will gladly listen to any opposing thoughts.

We've just started discussing error handling and I don't think we have a clear path on that, but definitely a high priority on our technical requirements list.

We're not on Oracle support so we actually don't have access to Orchestrator.

 

[RussellCodlin]

We're not on Oracle support so we actually don't have access to Orchestrator.

Slight side note, if you wish to discuss integration with JDE in more detail we can go through some options. We provide REST API solutions for your tools release of JDE. We can also provide specific advice on the integration platforms options specific to your environment, capabilities and requirements.

 

[jdelisths]

But our preferred option would be to use some sort of REST integration as it looks like that's the future of integrations

If you are open to third-party products, take a look at our Oracle Validated product, with full functionality for REST:

REST API: Easy-to-use REST API for JD Edwards EnterpriseOne - Aellius

JDE, EnterpriseOne, integration, REST, API, business function, table, update, delete, select, insert, add, crud, ube, report, attach, gt, media object, bsfn

www.aellius.com

 

[Alex_Pastuhov]

We're planning on modernizing our interfaces of E1 with other applications and hopefully add more interfacing to improve automation and less manual work.

Besides Mulesoft & Boomi, does anyone have any other suggestions on other middleware platforms that we should look at?

Currently looking to interface an external WMS SaaS application with E1, but the future applications to be interfaced is yet to be determined. For now, what we know is we're leaning more towards SaaS products.

Thanks.

We have EveREST2JDE solution available.

 

[MonsterCable]

If you are open to third-party products, take a look at our Oracle Validated product, with full functionality for REST:

REST API: Easy-to-use REST API for JD Edwards EnterpriseOne - Aellius

JDE, EnterpriseOne, integration, REST, API, business function, table, update, delete, select, insert, add, crud, ube, report, attach, gt, media object, bsfn

www.aellius.com

How would this work without Orchestrator? Kernel-level interface?

 

[MonsterCable]

Slight side note, if you wish to discuss integration with JDE in more detail we can go through some options. We provide REST API solutions for your tools release of JDE. We can also provide specific advice on the integration platforms options specific to your environment, capabilities and requirements.

How would this work without Orchestrator?

 

[RussellCodlin]

How would this work without Orchestrator?

Connects to the enterprise server directly. We provide a REST API solution combined with a heap of API end points for specific transactions. The end points cover off most integration requirements for procurement, inventory, distribution, manufacturing, asset management plus generic stuff like media attachments etc. You can also build your own if required. It also handles newer authentication methods as well. So for example, you can generate JWT bearer tokens to be used by solutions like Boomi which means you don't need to handle the login process as part of the integration.

 

[ybuffetaud]

You could use Oracle Data Integrator, or best Stambia, this is an ELT which is like ODI but better and licensing is based on development effort.

 

[MonsterCable]

Connects to the enterprise server directly. We provide a REST API solution combined with a heap of API end points for specific transactions. The end points cover off most integration requirements for procurement, inventory, distribution, manufacturing, asset management plus generic stuff like media attachments etc. You can also build your own if required. It also handles newer authentication methods as well. So for example, you can generate JWT bearer tokens to be used by solutions like Boomi which means you don't need to handle the login process as part of the integration.

At this point we've had meetings with Mulesoft and are interested in other Integration options. To be frank, we're trying to focus in on what platform besides Orchestrator could be our long term integration tool. We're expecting the solution to have full integration and flexibility in the future. Does Cantara do the same (or more) than what Mulesoft can? or is there a secret sauce that Cantara provides that nobody else can compete with?

 

[jdelisths]

How would this work without Orchestrator? Kernel-level interface?

LynX Business Integrator (LBI) integrates with JDE at the API level, so you could call it a "kernel-level" interface (specifically, we don't use XML call object, so we don't inherit its limitations). You can integrate through REST at the granular level (i.e. call business functions, table i/o etc.), which requires no development, or create a business process for specific tasks (like A/P voucher, G/L journal etc.) and consume them through REST (or SOAP). We have a bunch of pre-built business processes, but you can create your own or customize one of ours. Business processes are created using .NET/C#, so you are in a programming environment that has a lot of available resources - anything that .NET has to offer is at your disposal.

For those products like Mulesoft and Boomi, JDE is just one integration point. LBI exposes JDE as an integration point, making it easy for those productions to hook into JDE without having to deal with the nuances/complexities of doing so.

 

[RussellCodlin]

Does Cantara do the same (or more) than what Mulesoft can? or is there a secret sauce that Cantara provides that nobody else can compete with?

Cantara is generally combined with full blown middleware/integration products as a standard REST based connector for JDE. So for example, we have customers that use Mulesoft, Boomi, Talend, Azure Integration Services, and a few others, as their enterprise integration platform and then use Cantara to connect those systems to JDE. The benefit of Cantara is that it provides a heap of standard atomic APIs for most integration use cases and also abstracts away the complexity of JDE data so that integration developers don't need to have JDE knowledge. Simple things like dealing with business units being left padded or doing lookups for UDC values so the API can return the description and special handling codes, not just the key.
So if you talk specifically about Mulesoft for example, we have a connector that you can pull in to Anypoint Studio although it is not really needed.