Last post Dec 15, 2014 06:35 AM by johnjohn123123
Dec 15, 2014 06:35 AM|johnjohn123123|LINK
I am working on an asp.net MVC CRM web application and I am using entity framework as the data access tool. My problem is that I want to get a list of all our customers from an external system, to use them inside my application. I have these three points
that govern my architecture approach:-
I prefer to store a copy of the customers list inside my DB, as this will allow me to apply, sorting, filtering, and search easier and faster. And also if the external system went down, my own system will not get affected.
The current External system might be replaced by our company in the future.
The current external system does not provide any web APIs to retrieve the customer list.and i have to query its Db directly.
So I am thinking of the following approach:-
So can anyone advice about my current approach I am thinking of, Or there are another approaches I can consider?