Our Thinking

This is a forum to share our thoughts and get your feedback.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form

Modification Tracking in Oracle CRM On Demand

Posted by on in Oracle CRM On Demand
  • Font size: Larger Smaller
  • Hits: 1206
  • 0 Comments
  • Subscribe to this entry
  • Print

Often, there is a need for applications that integrate with CRM Platforms to know when objects get modified/created/deleted in the CRM systems. A simple use case is let's say there is a minor territory re-alignment and the accounts get redistributed. How would the reps in the field know about the new accounts that got added to the their respective territories? From a User Experience standpoint, this should happen without the rep having to take any explicit action on the device, which is pretty challenging.  Of course, we can do a full refresh periodically but that would be dumb and inefficient. 

There are multiple integration patterns that support such use cases in CRMOD. The concept of Modification Tracking is a good mechanism to address such requirements.

In this blog, I thought I'd highlight how we are using Modification Tracking for on the order capture apps we are developing.

 

1. We had to get the administrator of the POD to enable this feature using the admin settings.

2. Then, we had written a Java wrapper on top of the Modification Tracking WSDL to be able to consume it within our applications.

3. Our Quartz scheduler constantly pools CRMOD for any new records based on a set frequency and if there are new records after the last sync, we get them from the Modification Tracking web service and update a database in our middle tier. The pieces of information we get from the services are

  • What Object got changed.
  • What Time was it created/updated.
  • What Operation got executed on the object.

We get the records from the service and upload a database in the middle tier.

 

The iOS code on the ipad constantly pools the middle tier with a timestamp and checks for any changes and our server returns a  JSON response like this:

{

 account : {

                          insert : [

                                           {

                                            accountId : "",

                                            ...... All the account related fields

                                         }

                                   ],

                           update : [

                                            {

                                               accountId : "",

                                              ...... All the account related fields

                                           }

                                          ],

                            deleted : [

                            {

                              rowId : "" // Just RowId

                          }

                                        ]

              },

Repeat for Other Objects

 

 

Now the client (iPad) has all the information w.r.t to the changes and can create/update/delete local database as needed.

 

 

This is just Version 1.  We will continue to enhance the logic in the next version. 

0

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest
Guest Tuesday, 19 June 2018

Archive

January
February
March
May
July
August
September
October
November
December
January
February
March
June
August
September
November
December
January
March
April
May
June
August
October
November
December
January
February
March
April
May
June
July
November
December

US Offices

4229 Lafayette Center Drive., Suite # 1880, Chantilly, VA 20151

Mobile: 703.868.6393

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

India Office

Focal CXM Private Limited, #802-A,
8th Floor, “THE PLATINA”, BIT - II,
APHB, Gachibowli, R.R. District,
Hyderabad, Telangana-500032

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Go to top