DWiz is a data warehouse automation tool for the creation, loading, maintenance, and modular augmentation of data warehouses and data marts. By using this tool, you can dramatically reduce the development time needed for these tasks--especially in the ETL (extract-transform-load) processes required for both your end-user data warehouse database and the intermediate staging database.
There is a yearly subscription fee but the subscription fee for the first two months is waived. After that, the first year's subscription fee is $4200.
Typical competitors charge $40,000 for each license, with a minimum purchase of two licenses. Their typical yearly maintenance fee is $8,000 for each license, so their minimum cost during the first year starts at $96,000.
DWiz is a powerful solution that can be used successfully on huge databases, huge tables, and complex sources. The generated code is both efficient and maintainable.
To reach a much bigger market. By making DWiz so affordable and so easy to use by in-house staff, we bring data warehousing within easy reach of countless more companies and organizations.
And yet more than two-thirds of all data warehouse projects are considered failures, even those with big budgets and high-priced consultants. Use DWiz as an investigative tool to prototype a strawman during the conceptualization stage of your megabuck project. Even if you decide afterwards to continue with the multi-megabuck approach, it is quite likely that the knowledge you glean from the strawman prototype could be used to cut through smoke and mirrors, and reduce the overall cost of the future project.
In most cases, the design and use of a company's existing operational databases is much trickier than the design of the data warehouse itself--and a much bigger factor in the construction of the ETL. Not to say that consultants aren't useful, but that your in-house staff is usually more important. Many consulting quotes and contracts will require guaranteed free access to "subject-matter experts". Who are the subject-matter experts?...those are your in-house staff, who either way will play the pivotal role in development of your warehouse--because they best know how your existing operational systems work, how to get the data, and how the data can best be used.
This should be a question you ask before you award a contract, especially considering that the servers are often in another country.
Yes. Data Warehouse Wiz creates SQL Server Integration Services (SSIS) packages and/or SQL Server Stored Procedures for your processes, without any dependence on a custom framework. These solutions work equally well in the Cloud or snuggled in your own local server rack.
GOOD, you shouldn't be! DWiz generates sourcecode for you, but generates readable (and editable) source for Sql Server and SSIS/BIML. Nothing of your ETL process is hidden from you, and there are no hidden proprietary routines. Your ETL processes can be scheduled as Sql Jobs or Scheduled Tasks, independent of DWiz. You will continue to use DWiz to save development time when you add data marts, change schemas, augment functionality, etc.
Yes, you have full access to, and control of, the generated source code for the ETL processes. You can even modify it as you wish, although this should not be necessary... DWiz includes many powerful features to write the source code for you. Being able to see exactly what DWiz writes--with no hidden parts--is a great benefit that we are proud to provide.
YES! After you use DWiz to design your data mart/data warehouse and to develop the ETL processes that feed and maintain your DW, your ETL processes will run independently of DWiz, even after the subscription period expires.
Well, ah, yes. Hmm. However, you will be so pleased that you will want to get a DWiz subscription to save yourself time/money/stress during the inevitable expansion of your data warehouse.