Services and tools compatible with Netezza Performance Server
Deployment options: Netezza Performance Server for Cloud Pak for Data SystemNetezza Performance Server for Cloud Pak for DataIBM Netezza Performance Server for Cloud Pak for Data as a
Service
Learn about the services and tools that are compatible with Netezza Performance Server with support from Cloud Pak for Data.
The following table lists the services and tools that can be installed on Netezza Performance Server.
Note: All services and tools listed are available to install or connect to through Netezza Performance Server. A
check mark indicates an available installation.
| Service or tool | Netezza for Cloud Pak for Data as a Service | Netezza for Cloud Pak for Data System 1.0.X | Netezza for Cloud Pak for Data System 2.0.X | Netezza for Cloud Pak for Data |
|---|---|---|---|---|
| SQL language drivers (available on all deployments) | ✔ | ✔ | ✔ | ✔ |
| Anaconda Repository for Cloud Pak for Data | ✔ | |||
| Apache Superset | ✔ | ✔ | ✔ | ✔ |
| Cognos Analytics | ✔ | ✔ | ✔ | ✔ |
| DataStage | ✔ | ✔ | ||
| InfoSphere Information Server | ✔ | ✔ | ||
| Redash | ✔ | ✔ | ✔ | ✔ |
| Third-party SQL administration tools | ✔ | ✔ | ✔ | ✔ |
| Watson Knowledge Catalog | ✔ | ✔ | ||
| Watson OpenScale | ✔ | ✔ | ✔ | ✔ |
| Watson Query | ✔ | ✔ | ||
| Watson Studio | ✔ | ✔ | ✔ | ✔ |
AI services and tools
- Watson Knowledge Catalog
- Use Watson Knowledge Catalog to manage catalogs with the support of a data governance framework and data protection.
- Watson OpenScale
- Use Watson OpenScale to analyze and monitor your AI and the decisions made to mitigate bias and drift.
- Watson Query
- Use Watson Query to cache and access distributed data more efficiently, without data replication or movement.
- Watson Studio
- Use Watson Studio to create analytics projects and collaboratively work on data. You can choose the tools that you need to analyze and visualize data, to cleanse and shape data, to ingest streaming data, or to create and train machine learning models.
Analytics services and tools
- Cognos Analytics
- Use Cognos Analytics to create and share stunning visualizations of self-service analytics, which are infused with AI and machine learning.
- DataStage
- Use DataStage as an intuitive graphical interface to design and run data flows. DataStage supports extract, transform, and load (ETL) and extract, load, and transform (ELT) patterns.
- InfoSphere Information Server
- Use the InfoSphere Information Server to integrate data to easily understand, monitor, cleanse, and transform data.
Developer services
- Anaconda Repository for Cloud Pak for Data
- Use Anaconda Repository for Cloud Pak for Data to manage open source packages that used in Jupyter Notebooks and JuptyterLab and store your own propriety packages.
Developer edition
- IBM Netezza Developer Network
-
Note: The Emulators for IBM Netezza Developer editions (version 11.x) have been removed due to licensing issues.
Drivers
The following specifications and drivers are used to implement the international standards for
SQL CLI in different environments.
- Open Database Connectivity (ODBC)
- Use ODBC as a Microsoft™ specification for an API that constitutes an implementation of the international standards for the SQL CLI within the C and C++ programming environments.
- JDBC
- Use JDBC to define an API for the Java™ programming environment that Java™ programmers use to access relational databases and issue SQL statements.
- OLE DB
- Use OLE DB as a higher-level replacement for ODBC to support a wider variety of non-relational databases that do not necessarily implement SQL (for example, object databases and spreadsheets).
- .NET
- Use .NET Framework to include the Framework Class Library (FCL) and enable applications to run in the Common Language Runtime (CLR). These applications can directly access data sources such as Netezza Performance Server.
- Go Driver
- Use the Go driver with the Go language database/sql package to interface with Netezza Performance Server for Cloud Pak for Data in the Go programming environment.
- SQL Alchemy
- Use SQL Alchemy to implement SQL and object-relational mapping in the Python programming environment.
Open-source tools
- Apache Superset
- Use Apache Superset to explore and visualize your data in various forms, including graphs, dashboards, and geospatial charts.
- Redash
- Use Redash to edit, analyze, and visualize your data.
Third-party SQL administration tools
- AquaData Studio
- Use AquaData Studio to visually build data queries, analyze data, edit SQL code, and model entities that can be converted into SQL scripts.
- Coginiti Pro
- Use Coginiti Pro to build pipelines and data models, analyze data across platforms, and train models. Coginiti Pro can also catalog SQL objects and make them easily reusable, with a searchable catalog and SQL history.
- Dbeaver
- Use Dbeaver to migrate schemas and data, analyze and visualize data, manage database connections, and as a SQl editor. Dbeaver has many extensions for integration with Excel, Git, and others.
- NexusDB
- Use NexusDB to create and manage databases, tables, and SQL queries and use multi-level security to keep data safe on servers and networks.
- SQuirreL SQL
- Use SQuirreL SQL to view the structure of a JDBC compliant database, browse data in tables, and issue SQL commands in a Java™ environment.
- Tableau
- Use Tableau to use a drag-and-drop format to prepare, analyze, and share your data with governance.
- WinSql
- Use WinSql to connect to various databases, run static or dynamic queries, generate test data, and visualize database designs. WinSQL can also integrate with MS Excel.