I have an Operational Datastore (ODS) instance consisting of several relational databases that are populated daily from exports from the OLTP databases. I use SSIS 2012 for this.
The databases in the ODS are replicates of the databases in the OLTP.
I also hold web analytics etc in the ODS and I will be combining data from all these sources for MI reporting and also for data analysis and visualization through a BI dashboard.
There won't be much data to start off with, but I want to build the system for future use when there will be more data.
Do I build a datawarehouse from the ODS databases, or do I build datamarts, or do I create logical views on top of the ODS databases that can be used by MI reporting and BI tools?
I think performance at this point in time will be met by simple logical views. Is this wise or do I invest my time in designing a proper datawarehouse from the ODS now?
Also, should I import data from the ODS into the datawarehouse using Analysis Services? Is this the correct use of it?
Thanks for any help offered.