The wizard factory leverages our Conductor tool to make all data ingest, enrichment, correlation and lifetime management activities very simple.
Simply put : The Wizard Factory helps make all the difficult data integration tasks easy.
A key capability for customers is the ability to manage and enhance the solution through the addition of new or updated sources of data. The Wizard Factory provides pre-built tools that take the manual effort out of acquiring, loading and enriching new data, creating and managing data models, creating summaries and extracts and managing the overall data life cycle of the system. All of these wizards leverage the product’s robust database support including Hadoop/Hive, MPP Databases (Amazon RedShift, Actian, IBM Netezza, Pivotal Greenplum, Teradata, Vertica) as well as standard databases (MS SqlServer, Oracle, Postres, MySql).
Give the power to your users with visual tools that virtually eliminate coding. We’ve spent years trimming and implementing the hard stuff for you so you can get the job done in just a few steps. We have a rich library of database agnostic helper functions that can be accessed from a visual interface and run across multiple databases. Reuse and save money. Create dynamic transformations and preview within the designer with just one click.
Using our Wizards, a complete solution can be launched in a single day. For real, read on…
The DB Extract wizard simplifies the process of extracting data from any source system for loading into your Warehouse. It can connect to any supported database platform – once, or on a regularly scheduled basis. It easily extracts a data set directly to the landing zone for loading into the warehouse. The Wizard can also help build the extract query with a point-and-click interface, while still supporting advanced users with complex SQL if needed.
The Input Wizard automates the process of loading data into the warehouse. By supporting both local data files, as well as files on the Landing Zone, the Input Wizard can handle a broad range of business scenarios from one-off projects using desktop data to regularly occurring large feeds spanning hundreds of thousands of files and billions of records. Input Wizard automatically analyzes the input file data and proposes a staging table structure with complete data typing support. The proposed structure can be edited at will, giving the user full control over the table structures while shielding them from the complexities of the underlying database. Finally, Input Wizard can schedule the load process to run once, or on a recurring schedule, automatically load balancing as needed for large / high-volume environments.
The Unify Wizard picks up where the Input Wizard leaves off, automating the process of moving the loaded data to a star schema with fact and dimension tables. The Unify Wizard uses a drag-and-drop interface to make it easy to setup data flow mappings and transformations from source to target. It will even create the fact and dimension tables automatically and then build the necessary workflows to handle continuous processing of fact records and dimensions as well. Business rules can also be applied during unification to ensure that all data loaded is accurate standardized and semantically correct.
The Output Wizard is used to build M2M (machine to Machine) interfaces or tabular reports where an output file (or email) needs to be created based on a query run against any of the warehouse data. As with all Wizards, this can be a one-time or a regularly scheduled event. The Output Wizard even takes care of compressing the output file and delivering it via email or making if available via FTP/SFTP or network share.
Finally, the Data Lifetime Wizard takes care of managing the process of archiving/purging data based on customizable retention intervals. This ensures that the data warehouse does not grow beyond the limits of the database platform, ensuring that all reports run off a known and consistent data set.