Re: Data transfer between EBS and Dynamics365

ORDS can definitely do the same as ISG. But you have to find the right API's, and won't get too much help from Oracle Support when the API's break.

I use it on most non-eBS systems that I work with. But for eBS, I prefer to first look at the existing methods. No use to re-invent the wheel. When I end up with something that needs to be custom-built, ORDS is definitely worth considering.

Arian

On 2020-10-05 20:01, Alfredo Abate wrote:

> +1 on the Integrated SOA Gateway (ISG), XML Gateway, and BES methods.
>
> We use ISG in conjunction with Oracle Integration Cloud (OIC) to
> communicate both inbound and outbound from our E-commerce solution to
> EBS. We are on EBS 12.1.3 and with the latest ISG patches, you can get
> REST APIs too, as it was backported.
>
> I wonder if using a simpler approach with Oracle Rest Data Services
> (ORDS), if you could accomplish some or all of the same things?
>
> Alfredo
>
> On Mon, Oct 5, 2020 at 12:33 PM Arian Stijf <arian_at_stijf.com> wrote:
>
> Hi Tim,
>
> I worked on a conversion to Dynamics 365, and on a number of
> integrations with other ERP systems.
>
> As far as I know, there is indeed no off the shelf solution.
>
> But my 2ct.
>
> I'll assume you want to do real-time integration. There are no real
> suitable solutions for bulk-transfers.
>
> For the inbound part, it is easiest to use Integrated Soa Gateway
> (ISG). For eBS 12.2 it offers REST-API's (SOAP if you also install SOA
> Suite) for most entities.
>
> For the outbound part, there are XML Gateway or the Business Event
> System (BES).
>
> XML Gateway is suitable for order and invoice information. It offers
> standard XML-formats for most transactions. But it is not suitable for
> customer master data.
>
> BES needs custom PL/SQL or JAVA code to gather te required data. But in
> my opinion, they are easy to build and maintain. BES will take care of
> the appropriate XML formatting, headers and handling. It also offers a
> robust way of triggering the interface when data is entered or
> modified.
>
> Let me know if you have any specific requests.
>
> Kind regards,
>
> Arian
>
> On 2020-10-05 17:15, Tim Gorman wrote:
>
> Thanks!
>
> It isn't a migration, it is an integration. They want to share
> customer data between EBS and D365 CE (a.k.a. CRM). Perhaps there is
> movement toward migration in one direction or another, but I don't have
> visibility into anything but this question.
>
> So far, the EBS REST API is looking likely; nothing else seems to be
> built. They were clearly hoping to "buy", but it is looking like the
> only choice is "build".
>
> On 10/5/2020 6:55 AM, Alfredo Abate wrote:
> Tim,
>
> I wish I did but it sure sounds like an interesting project. An
> organization is actually going from Oracle EBS to Microsoft Dynamics
> 365?!
>
> Alfredo
>
> On Thu, Oct 1, 2020 at 3:09 PM Tim Gorman <tim.evdbt_at_gmail.com> wrote:
> Team,
>
> I'm wondering if anyone on this list has any experience with connectors
> for transferring data between Oracle E-Business Suites and Microsoft
> Dynamics 365?
>
> Thanks!
>
> -Tim
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l