Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Query Updated rows from view RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Baren

    Baren

    Sunday, January 28, 2018 5:41 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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)

    regards,

    Don

    Tuesday, January 30, 2018 1:35 AM