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.
Table 1. Installability of services and tools
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.

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.