Enter your keyword


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
 (             “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

Some Toughts (68)

  1. added on 21 Feb, 2018

    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

  2. added on 23 Feb, 2018

    Informative Blog…..Oracle training in chennai

  3. added on 24 Feb, 2018
  4. added on 25 Feb, 2018
  5. added on 10 Mar, 2018

    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

    Oracle Training in Gurgaon

  6. added on 23 Mar, 2018

    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

  7. added on 2 Apr, 2018

    Thanks for sharing
    oracle training

  8. added on 6 Apr, 2018

    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

  9. added on 16 Apr, 2018

    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

  10. added on 18 Apr, 2018

    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

  11. added on 19 Apr, 2018

    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

  12. added on 2 May, 2018

    This is amazing and awesome,Thanks for sharing

    Oracle SOA Online Training

  13. added on 3 May, 2018

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

  14. added on 9 May, 2018

    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

  15. added on 16 May, 2018

    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

  16. added on 19 May, 2018

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

  17. added on 26 May, 2018

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

  18. added on 29 May, 2018

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

    SAP S/4 HANA training online

  19. added on 7 Jun, 2018

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

    Oracle SOA Online Course Bangalore

  20. added on 7 Jun, 2018

    thanks for goodinformation
    Oracle Training in Deira, Dubai

  21. added on 8 Jun, 2018

    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

  22. added on 13 Jun, 2018
  23. added on 13 Jun, 2018

    It's really interesting Thanks for sharing

    Oracle SOA Online Training India

  24. added on 7 Jul, 2018

    It is really informative and attractive post. I will recommend it to others . Your work is really being appreciated.

  25. added on 23 Jul, 2018

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

  26. added on 26 Jul, 2018

    I read that Post and got it fine and informative. Please share more like that…


  27. added on 3 Aug, 2018

    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

  28. added on 3 Aug, 2018

    That's a Great Article and more useful for anyone.Thanks for sharing…

  29. added on 3 Aug, 2018

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

  30. added on 17 Aug, 2018

    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

  31. added on 21 Aug, 2018

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

  32. added on 22 Aug, 2018

    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.

  33. Anonymous
    added on 5 Sep, 2018

    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

  34. added on 17 Sep, 2018

    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

  35. added on 9 Oct, 2018

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

  36. added on 11 Oct, 2018

    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

  37. added on 15 Oct, 2018

    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.

  38. added on 15 Oct, 2018


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


  39. added on 17 Oct, 2018

    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

  40. added on 17 Oct, 2018


  41. added on 23 Oct, 2018

    Excellent informative blog, keep for sharing……

    java training in chennai

    selenium training in chennai

  42. added on 24 Nov, 2018

    Hello, I am thomus jons thank you for this informative post. That is a great job. Wish you more success.Thank you so much and for you all the best. Takes Down

  43. added on 28 Nov, 2018

    technically your blog is very useful oracle online training

  44. added on 18 Dec, 2018

    I am fully satisfied with the information you have posted. Good job. Keep posting:)

  45. added on 20 Dec, 2018

    It’s awesome that you want to share those tips with us. Enterprise Resource planning! It is a very useful post Keep it up and thanks to the writer.

  46. added on 11 Jan, 2019

    Nice blog, very interesting to read
    I have bookmarked this article page as i received good information from this.

    Best ERP Software in India | ERP Software Companies in India

    Cloud ERP Software in India | Low Price ERP Software in India

  47. added on 11 Jan, 2019

    If you want to play like me and not lose, you should try playing BGAOC. free gambling with us Playing here you not only win but also get a lot of fun.

  48. added on 12 Jan, 2019

    Great blog, keeping me from working about this Internet Marketing Company Near Me topic. All the Best  

  49. added on 18 Jan, 2019

    Hey Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
    best java training in coimbatore
    php training in coimbatore

  50. added on 21 Feb, 2019

    Качественный декоративный алюминиевый led профиль я обычно беру в компании Ekodio, советую.

  51. added on 5 Mar, 2019

    Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information.
    Oracle Training in Delhi

  52. added on 6 Mar, 2019

    Great blog, learned many things about email database from this blog, very information. The Email Database USA is the best place to get database in USA.
    Email Database USA
    Database Provider
    Email Marketing Database
    Email Marketing Lists
    Student Database
    B2B Database
    USA Business Database
    Small Business Database
    Worldwide Email Database

  53. added on 12 Mar, 2019

    I read your Post and thanks for Sharing a Very Nice Post and I must Say It’s Really Helpful for us
    Top 10 Best Institute for Sap Course in Delhi
    Top 10 Best Institute for Sap Course in Noida
    Top 10 Best Institute for Sap Course in Gurgaon

  54. added on 12 Mar, 2019

    Its a wonderful post and very helpful, thanks for all this information. You are including better information.
    Oracle Training in Delhi

    Oracle Training institute in Delhi

  55. added on 26 Mar, 2019

    There is Lots of Writer but Your Writing way is so good and clear So Keep Writing & Thanks for Sharing a very Informative Information
    Sap Training Institute in Delhi
    Sap Training Institute in Noida
    Sap Training Institute in Gurgaon

  56. added on 14 May, 2019

    Comfortabl y, the post is really the freshest on that deserving topic. I harmonise with your conclusions and definitely will thirstily look forward to your next updates.

    website builder for reseller

  57. added on 14 May, 2019

    Thank you for the link building list.I am going jot down this because it will help me a lot.Great blog! Please keep on posting such blog.

    private label website builder

  58. added on 14 May, 2019

    Comfortabl y, the post is really the freshest on that deserving topic. I harmonise with your conclusions and definitely will thirstily look forward to your next updates.

    white label website builder

  59. added on 14 Jun, 2019

    thank you for sharing this content..online marketing

  60. added on 28 Jun, 2019

    This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up salesforce certification

  61. added on 10 Jul, 2019

    This is very great thinks. It was very comprehensive post and powerful concept. Thanks for your sharing with us. Keep it up..
    Oracle Training in Chennai | Oracle Training Institutes in Chennai

  62. added on 18 Jul, 2019
  63. Guest
    added on 22 Aug, 2019

    How I can fetch out data from database adapter and write it into FTP file

Leave a Reply

Your email address will not be published.