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


67 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
  31. 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
    123movies

    ReplyDelete
  32. http://www.chloros.in/sem-services.html
    I am fully satisfied with the information you have posted. Good job. Keep posting:)
    http://www.chloros.in/customized-erp-solutions.html

    ReplyDelete
  33. 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.

    ReplyDelete
  34. 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

    ReplyDelete
  35. 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.

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

    ReplyDelete
  37. 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

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

    ReplyDelete
  39. 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

    ReplyDelete
  40. 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

    ReplyDelete
  41. 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

    ReplyDelete
  42. 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

    ReplyDelete
  43. 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

    ReplyDelete
  44. 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

    ReplyDelete
  45. 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

    ReplyDelete
  46. thank you for sharing this content..online marketing

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

    ReplyDelete
  48. 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

    ReplyDelete