At the moment I have three different sources where my data are. 1. A Dataprovider, 2. inhouse access DB and 3. Salesforce. Now I want to build a datawarehouse (using ms software) where I want to store the data and create reportings via e.g asp.net mvc or excel. Since we have really small datasets (all together is about 500mb saved in csv) I am working on a concept to avoid the huge sql server. My idea up till now is
- create a db schema where I can store all my data in.
- write code to get the data from the datasources into classes
- get the data into entity framework and write the data into the database (this should happen every 24 hours or at button click)
- set a reporting module that gets data from the entity framework and creates reports
my problem is that I am not sure if this works at all. Is it possible to update the data every 24 hours via the entity framework?