Integration

Get Involved. Join the Conversation.

Topic

    Mohana Gopal Selvam
    Integration ApporachAnswered
    Topic posted July 31, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Database, REST 
    41 Views, 8 Comments
    Title:
    Integration Apporach
    Content:

    Hi,

    Our customer have DB Cloud, OIC (Oracle Integration Cloud), JCS (Java Cloud Service) and Fusion Cloud (SaaS). We have tried to integrate the third party system from our CRM fusion application. We have built some pages using DCS - VBCS (Digital Customer Service - Visual Builder Cloud Service), based on some event in the screen the data from DB cloud needs to push to third party system. (Data resides in multiple tables. We have to build some complex joins) 

    We have identified two approach.

    1. Create custom java program in JCS, it will fetch the data from DBCS and form the request which is requested by third party system and call the third party API. This custom program deployed as Rest API. We will invoke this API from our VBCS screen.

    2. Create API using ORDS (DBCS). Create connections of ORDS API & third party API. Create one integration to integrate ORDS API & third part API in OIC. We will invoke OIC API from our VBCS screen.

    Let me know which one is best approach. 

    Thanks,

    Mohan

    Best Comment

    Sunny Chugh

    Hi Mohan

     

    here it is

    A message is defined as up to 50Kb of in-and-out transmission from/to the Oracle Cloud Service. Any message over 50Kb in size must be counted as multiple messages, with each 50Kb or portion thereof counting as equivalent to one message (e.g., 210Kb would be counted as 5 messages). One concurrent user for the process automation feature is equal to 400 messages. One concurrent user for the Visual Apps feature is equal to 100 messages. Any combination of message input, message output, concurrent users, or messages sizes may be utilized concurrently, but must not exceed the maximum quantity of 5,000 Messages per Hour that You set when You create an instance for the Oracle Cloud Service.


    Regards

    Sunny

    Comment

     

    • Sunny Chugh

      Hi

      I would suggest to go with 2nd approach where traceability is more, also VBCS and OIC connectivity works very well.

      OIC is stateless with orchestration capabilities, easy to handle and monitor.

       

      regards

      Sunny

    • Mohana Gopal Selvam

      Hi Sunny,

      Thanks for your inputs.

      Do you have any idea about the cost implication? Since we are planning to hit this service multiple times and we have many services (Around 20 + ) kind of this.

      Each service is fetching the data from different tables. Do we need to create separate connection & integration for each ORDS API? 

      Thanks,

      Mohan

    • Sunny Chugh

      Hi Mohan

      OIC works with Number of 20K Messages Per Hour Packs , when we provisioned it

      you can look more at cost estimator

      https://cloud.oracle.com/en_US/cost-estimator

      on the number of DB Connections , i am checking once so will get back

       

      regards

      Sunny

       

    • Mohana Gopal Selvam

      Hi Sunny,

      Each OIC transaction is counted for the billing, since we are going to call this service multiple times per day?

      Thanks,

      Mohan

    • Sunny Chugh

      thats true as per my understanding, but if you have so many processes and there is pricing issues then may be you can go with java option (JCS)

      only thing which i dont like JCS is you have to write lot of code and then maintaince is bit tricky, sasy suppose there is some issue, how you will trace it?

      you have to make sure you have proper tracing mechnism developed with JCS

      regards

      Sunny

       

       

       

    • Mohana Gopal Selvam

      Hi Sunny,

      Thanks for your response. Could you explain what is meant 5000 messages / hour?  Is it mean, we can invoke 5000 API call?

      We are going to build one API in ICS, which is going to call one ORDS call and 2 external system call. Is it counted 3 API call or one ICS call?

      Starter environment including Integration with SaaS and Technology Adapters and Visual Apps Builder with 1 Message Pack of up to 5000 messages / hour. Oracle takes care of management, backups and patching

      Thanks,

      Mohan

       

    • Sunny Chugh

      Hi Mohan

       

      here it is

      A message is defined as up to 50Kb of in-and-out transmission from/to the Oracle Cloud Service. Any message over 50Kb in size must be counted as multiple messages, with each 50Kb or portion thereof counting as equivalent to one message (e.g., 210Kb would be counted as 5 messages). One concurrent user for the process automation feature is equal to 400 messages. One concurrent user for the Visual Apps feature is equal to 100 messages. Any combination of message input, message output, concurrent users, or messages sizes may be utilized concurrently, but must not exceed the maximum quantity of 5,000 Messages per Hour that You set when You create an instance for the Oracle Cloud Service.


      Regards

      Sunny

    • Mohana Gopal Selvam

      Thanks Sunny.