Last week I had a discussion with one of my colleagues about "Where the SharePoint external List data is stored?", Is it stored in a SharePoint list and the SharePoint is synchronizing the changes between it and the original source, or SharePoint is saving only the connection information to the source and works as a representation interface for the external data only?
If you look at the following architecture you can say that it is stored in the SharePoint
But, if you look to the following architecture for the client app integration you can say that it's not stored in the SharePoint, since the client app is synchronizing with the data source directly
Any comments will be appreciated.