IBM Netezza OLE-DB Provider 7.2

IBM Netezza OLE DB Provider

The IBM Netezza OLE DB Provider is a Windows data access component that lets OLE DB–compliant applications connect to IBM Netezza data warehouses (including IBM Netezza Performance Server and IBM PureData System for Analytics). It enables tools such as Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), Excel, Access, and custom applications to query data, browse schemas, and move large datasets efficiently.

Key capabilities:

• Standards-based OLE DB connectivity for broad compatibility with Microsoft and third‑party tools
• Optimized, high‑throughput data access tailored for Netezza’s massively parallel architecture
• Support for parameterized queries, prepared statements, and schema discovery (tables, views, columns, keys)
• Secure connections (TLS/SSL) and multiple authentication options depending on your Netezza setup
• Configurable connection properties (server, database, port, credentials, timeouts, fetch size)
• Available for 32‑bit and 64‑bit Windows environments

Common use cases:

• Building ETL/ELT pipelines in SSIS or other data integration platforms
• Driving reports and dashboards from SSRS, Excel, or BI tools that support OLE DB
• Enabling custom .NET or C/C++ applications to run SQL against Netezza at scale

Basic requirements:

• Installation of the appropriate IBM Netezza client package that includes the OLE DB provider
• Network access to the Netezza host and port, plus valid database credentials
• A supported Windows environment (match 32/64‑bit with your applications)

Getting started:

1. Install the Netezza client tools that include the OLE DB provider.
2. Create a connection using a UDL file or your application’s data source settings.
3. Specify server, database, user credentials, and any advanced options (e.g., fetch size).
4. Test connectivity and run a simple query to validate performance and security settings.

IBM Netezza OLE-DB Provider is developed by IBM Netezza and is used by 2 users of Software Informer. The most popular versions of this product among our users are: 6.0, 7.0, 7.1 and 7.2.