We use IBM Netezza for querying data sets from our database. It allows users to export results to Excel as an example for further analysis.
- Data export, i.e. to Excel.
- Database views and queries monitor through Netezza monitor app.
- Cannot use functions such as pivot, which is in MS SQL Server
- Objects such as tables do not pop up automatically in the editor, users needs to navigate themselves to know the object names
Large companies 500+ with multiple analysts who needs to work simultaneously in the database.