In this comprehensive demo, Patrick O’Halloran, a Solutions Architect at WhereScape, showcases the incredible productivity gains achieved with WhereScape’s 3D design tool and RED builder tool.
In this video, you’ll discover:
– How to connect to various data sources, including ODBC, JDBC, flat files, JSON, XML, CSV, fixed-width files, and REST APIs.
– Profiling and discovering data connections to understand and define your source system. – Creating and managing Data Vault designs, including conceptual and logical models.
– Assigning attributes to columns and using automation to generate Hubs, Satellites, and Links.
– Building and deploying fully documented data warehouses using load and stage tables.
– Preparing for RED to create physical databases, generating DDL and DML scripts, and executing them to create and update tables.
– Running jobs to populate data and generate documentation for your data warehouse.
Watch as Patrick demonstrates the entire process, from connecting data sources to deploying a fully documented data warehouse, using practical examples to highlight the power and flexibility of WhereScape’s tools.
