Query Updated rows from view RRS feed

  • Question

  • Hi All,

    We have a requirement where in to fetch data from Oracle EBS system into D365 CRM cloud environment. The data gets pulled from EBS through SQL queries on custom views. We have a BizTalk as the middleware to transport the data between 2 systems. Is there a way to fetch only records which were updated after the last schedule BizTalk process? Currently it is retrieving all data updated for the current date using query Datediff.

    Thanks in advance for your support



    Sunday, January 28, 2018 5:41 AM

All replies

  • Baren. You're retrieving data from Oracle EBS with BizTalk and then push it into Dynamics 365. Your question is about optimizing the retrieve process in Oracle. If this is correct, we cannot help you with this I'm afraid.

    If I'm wrong and it's about optimizing the D365 side then you have to look at this:

    Change Tracking: https://msdn.microsoft.com/en-us/library/dn932130.aspx?f=255&MSPPError=-2147217396

    • Edited by MGCRM Monday, January 29, 2018 1:40 PM
    Monday, January 29, 2018 1:34 PM
  • Hi,

    On the Oracle side of things your are writing an SQL query to retrieve that data. That data is then transported to CRM via Biztalk.

    You should have a date on the Oracle side which denotes the date the data was updated (by Biztalk) which can be used in your query:

    WHERE BiztalkChangeDate = MAX(BizTalkChangeDate)



    Tuesday, January 30, 2018 1:35 AM