Integration of IBM Netezza with Strategy
The Strategy Secure Enterprise Platform supports integration with Netezza database as a data warehouse with Strategy Intelligence Server running on Windows and Linux operating systems. Integration with Netezza includes the following features to improve reporting performance
- The Multi-Pass SQL Engine translates analytical questions into optimized queries using multiple passes of SQL. This method is faster and more agile than traditional single-pass SQL.
- Push-down analytics leverages excess database processing power by using database specific syntax to process calculations at the database level.
- Precision tuning of queries via an extensive set of VLBD settings can be applied at the report, application, or project level.
- The multi-source engine enables connectivity to data stored across multiple enterprise data assets.
- The transaction engine pushes new or updated data back to underlying databases.
