locked
Query Updated rows from view

    Domanda

  • 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

    domenica 28 gennaio 2018 05:41

Tutte le risposte

  • 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

    • Modificato MGCRM lunedì 29 gennaio 2018 13:40
    lunedì 29 gennaio 2018 13:34
  • 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

    martedì 30 gennaio 2018 01:35