Sunday, 26 November 2017

Database polling in Oracle Integration Cloud Service

In this article, we will show how to use Oracle database polling in Oracle ICS. Oracle ICS allows very straight forward solution to poll the Oracle database in comparison to SOA.

Let's see how we can achieve database polling strategy in Oracle ICS.

  • Create a database table(XX_EMPLOYEE) with below script

CREATE TABLE XX_EMPLOYEE
 (             "ID" VARCHAR2(20 BYTE),
                "NAME" VARCHAR2(200 BYTE),
                "ISNEW" VARCHAR2(10 BYTE)
 )


  • Run below script to insert some values
 insert into XX_EMPLOYEE(ID,NAME,ISNEW) values(1,'Ankur Jain','NEW')
 insert into XX_EMPLOYEE(ID,NAME,ISNEW) values(2,'Nitin','NEW')
  • Create a Oracle Database Connection in Oracle ICS. Have a look to this blog for Oracle DB connection. Make sure Role must be of Trigger type
  • Create an Orchestrated Integration
  • Drop the Oracle DB connection as a Trigger point
  • Enter Name in What do you want to call your endpoint input box and click Next
  • Click Import Tables
  • Select the DB schema in which XX_EMPLOYEE table has been created, Enter the table name and transfer to Selected Tables. Click OK button
  • We will notice the below configuration screen
  • Click on Edit button of Review the polling strategy and specify polling options and enter/select below values
    • Polling Strategy: Logical Delete
    • Logical Delete Field: ISNEW
    • Read Value: This value used to indicate the row has been processed. Enter PROCESSED
    • Unread Value: Indicate the row to be process. Enter NEW
    • Polling Frequency(Sec): Specify the polling frequency in seconds to process the new record
  • Click Next and Done
This is the only configuration required to poll the Oracle DB. Now activate the integration and check the DB rows. We'll notice that the rows has been picked by Integration and ISNEW flag values has been set to PROCESSED

Before Activate the Integration


After Activate the Integration


42 comments:

  1. The article is quite appealing and attractive. We are the world's leading database supplier of email lists. We at Pegasi Media Group have with all types of companies of all the sizes and domains to provide you a wide choice with respect to the geographical location and the customer likes and dislikes.Our contact discovery services is very good at finding out the customer information which gives you the idea about what the customer wants.Database Marketing Services

    ReplyDelete
  2. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I

    like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good

    knowledge.
    Oracle Training in Gurgaon

    ReplyDelete
  3. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.Oracle Training in Chennai | Oracle Training Institute in Chennai

    ReplyDelete
  4. I am happy to see and follow your post. You are working good that is why I am always following you. Thank you.
    digital marketing company in india

    ReplyDelete
  5. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Oracle Training in Chennai
    Oracle Training Institute in Chennai

    ReplyDelete
  6. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

    oracle training in bangalore

    ReplyDelete
  7. I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.
    java training in bangalore

    ReplyDelete
  8. This is amazing and awesome,Thanks for sharing

    Oracle SOA Online Training

    ReplyDelete
  9. I enjoyed reading this blog post. It was inspiring and informative. seo services in chennai

    ReplyDelete
  10. Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, java training in noida , class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.

    By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.

    java training institute in noida
    java training in noida
    best java training institute in noida
    java coaching in noida
    java institute in noida

    ReplyDelete
  11. Sap Training Institute in Noida

    CIIT Noida provides Best SAP Training in Noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. CIIT Provides Best ERP SAP Training in Noida. CIIT is one of the most credible ERP SAP training institutes in Noida offering hands on practical knowledge and full job assistance with basic as well as advanced level ERP SAP training courses. At CIIT ERP SAP training in noida is conducted by subject specialist corporate professionals with 7+ years of experience in managing real-time ERP SAP projects. CIIT implements a blend of aERPemic learning and practical sessions to give the student optimum exposure that aids in the transformation of naïve students into thorough professionals that are easily recruited within the industry.

    At CIIT’s well-equipped ERP SAP training center in Noida aspirants learn the skills for ERP SAP Basis, ERP SAP ABAP, ERP SAP APO, ERP SAP Business Intelligence (BI), ERP SAP FICO, ERP SAP HANA, ERP SAP Production Planning, ERP SAP Supply Chain Management, ERP SAP Supplier Relationship Management, ERP SAP Training on real time projects along with ERP SAP placement training. ERP SAP Training in Noida has been designed as per latest industry trends and keeping in mind the advanced ERP SAP course content and syllabus based on the professional requirement of the student; helping them to get placement in Multinational companies and achieve their career goals.

    ERP SAP training course involves "Learning by Doing" using state-of-the-art infrastructure for performing hands-on exercises and real-world simulations. This extensive hands-on experience in ERP SAP training ensures that you absorb the knowledge and skills that you will need to apply at work after your placement in an MNC

    ReplyDelete
  12. Nice article thanks for given this information.
    Oracle Training in Delhi

    ReplyDelete

  13. Thanks for the explanation. It’s really helpful. Please keep sharing.
    Oracle Course in Delhi

    ReplyDelete
  14. Nice Blog post. Thanks for sharing great information. keep posting..

    SAP S/4 HANA training online

    ReplyDelete
  15. Learned a lot of new things from your post ,It's amazing blog

    Oracle SOA Online Course Bangalore

    ReplyDelete

  16. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your Blog.
    Mobile App Training Institutes
    iPhone Job Oriented Course

    ReplyDelete
  17. It is really informative and attractive post. I will recommend it to others . Your work is really being appreciated.
    planet-php
    Education

    ReplyDelete
  18. Quality content is the key to attract readers. And you provide just that. Good work. seo company india

    ReplyDelete
  19. Very useful information to everyone thanks for sharing, learn the latest updated Technology at Best Training institutions
    Salesforce Lightning is the latest updated technology
    Salesforce certification Training program

    Professional Salesforce CRM Training
    Salesforce Online Training in Bangalore

    ReplyDelete
  20. That's a Great Article and more useful for anyone.Thanks for sharing...
    https://www.zuaneducation.com/oracle-pl-sql-training-courses

    ReplyDelete
  21. That's a Great Article and more useful for anyone.Thanks for sharing...
    oracle course in chennai

    ReplyDelete


  22. Health Is God aims to deliver the best possible health reviews of the supplement collections and other wellness production that range from skincare to brain, muscle, male enhancement and brain health conditions. You, the user are of utmost importance to us, and we are committed to being the portal that sustains your healthy lifestyle. Visit for more- Health is God

    ReplyDelete
  23. I think this is a real great article post.Really looking forward to read more. Visit at
    Crazy Video Hub

    ReplyDelete
  24. Fantastic article to go through,I would appreciate the writer's mind and the skills he has presented this great article to get its look in better style.
    Fmovies

    ReplyDelete
  25. Nice article
    thanks for the info
    please see
    Consultants Factory provides high quality SIAM Certification trainings online. Our trainers are accredited to deliver SIAM courses
    service integration and management

    ReplyDelete
  26. It is a great job, I like your posts and wish you all the best. and I hope you continue this job well.
    NutraT line

    ReplyDelete
  27. I really enjoy the blog.Much thanks again. Really Great salesforce Online Training Hyderabad

    ReplyDelete
  28. Your thinking toward the respective issue is awesome also the idea behind the blog is very interesting which would bring a new evolution in respective field. Thanks for sharing.

    aws training in chennai

    selenium training in chennai

    ReplyDelete
  29. If there are thousands of rows returned, is there anyway to chunk this up, such as in the SOA DB adapter? This is especially important considering that OIC has a payload restriction of 10mb.

    ReplyDelete
    Replies
    1. Hi,

      If the DB is on-premise then you need to implement pagination at DB level and fetch the chunked record only.

      Regards,
      Ankur

      Delete
  30. Hey Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
    Web Design Training

    ReplyDelete