I am working on a new BI project for a medium sized corporation. Right now there is no Analytical infrastructure in place and the reporting is done manually in Excel. There are a few different data sources (from different systems like Billing) that need to be integrated to perform the reporting and analytics. Some of them are data dumps that need some custom conversions to get into a database ready form. These have a large number of columns. These need to be processed, required columns filtered and aggregations done etc. Typically there's about 50 GB of data produced daily and will be inserted to the existing tables each day.
We've identified that an analytical database like Vertica can be worth looking into. We don't have any prior experience with non-OLTP databases. My understanding is that Vertica (and other like it) are read-optimised and good for analytical tasks. My question is how does it fair at the initial stage where the raw data are loaded and processed? Should we use a traditional OLTP database like Oracle for that and then use the Vertica for Star Schema, Dimensional modelling type datastore? Is Vertica suited for ETL scenarios?
How is a typical architecture of this kind of scenario?