Data Warehouse Studio is a software development platform that enables enterprises to reduce the costs and development times of data warehouse and data integration projects by 50% to 70%.
Data Warehouse Studio enables software architects, data modelers, and business analysts to contribute directly to the outcome of data warehouse and business intelligence projects. Using Data Warehouse Studio’s graphical user interface, these domain experts define business rules, data mappings, desired coding patterns, and other design elements. Once these requirements and technical specifications have been entered in Data Warehouse Studio’s central repository, the platform automatically generates 99-100% of the SQL and ETL code required for the project, eliminating the need for hand-coding.
By automatically generating code for data warehouses and other BI projects, Data Warehouse Studio reduces development times, labor costs, and the risks of software bugs or security vulnerabilities.
Data Warehouse Studio integrates with widely used database, ETL, and Big Data technologies including:
- Informatica
- DataStage
- Talend
- Netezza
- Teradata
- Snowflake
- Microsoft SQL Server
- Oracle
- DB2
- PostgreSQL
- Amazon RedShift
- XtremeData
- MySQL
- Hive
- Pig Latin
For most projects, Data Warehouse Studio completely eliminates the need to manually code ETL or SQL processes.
Data Warehouse Studio is a design time technology that provides a single integrated platform for all project participants to capture requirements and technical specifications. With specifications centrally stored, DWS can quickly and automatically generate code in the customer’s technology of choice
Features
> Unified metadata-based platform for all DW activities
> ETL and SQL code generation
> Automated code promotion
> Process management framework
> Exceptions tracking
> Automated generation of documentation, reports, data lineages, and BI universes
> Customization of code generation patterns
Benefits
> Accelerated data warehouse implementation
> Automation of time-consuming activities
> Support for applying Agile development practices to DW and BI projects
> Reduced costs and time-to-market
> Reduced risks of software bugs and security vulnerabilities
> Increased transparency