Review on Datavault Builder by Cornelius Mosley
Review of datavalue builder - amazing software & highly recommended!
I like that it allows me to build an entire DW without having any knowledge or experience in SQL Server, SSIS etc., which makes my job easier as well since this software handles most things for you! There are some features/tools missing but they have said there will be more updates soon so hopefully those tools get added too along with other new ones once released (which should help speed up development). It's not free though - can't afford right now unfortunately :( But if your looking into building data warehouses then definitely give them try out first because their support team has been very helpful when we had questions about using datavalue builder vs our own custom scripts written by ourselves :) We're solving business problems related specifically around customer service center analytics & reporting needs within Salesforce CRM environment.
- Easy use friendly GUI
- Full automation capabilities
- Can do complex formulas via drag n drop formula editor + also allow simple formulae writing directly through excel import functionality.
- Extremely flexible mapping rules allowing full control over ETL processes.
- Data warehouse maintenance is easy due its builtin DB schema management capability where user just need update database table script before importing back newly created tables from Excel file during run time execution phase; thus no changes needed at all between different runs even
- There are disadvantages
