Design Query - Pull data from a third party data source and show it on UI

Question

We have to design a system where we have an application which will show data. The source of data is a third party Db which exposes apis to fetch data out of it. We have our db - Sql server where we will store this data. From the UI of the application , whenever we want , we can pull this data from this third party tool by a button click. Question is - whenever there is a button click to pull data, should the data from this third party tool first go and store in our Sql db and then we should fetch this onto our UI. Or data should be fetched directly onto UI first , instead of storing in DB first and then later on Save button click this should get stored in our DB.

Answer 1

Think about the following points

• Do you have permissions to copy this data in your database ?
• Do you even want to keep a copy of this data in your database ? (because the original might have changed from your copy, etc.)
• Can you afford to not have this data surfacing in your app when (and if) the 3rd party database is down ?
• Are you getting a performance advantage if you copy the data in your app's db ?