---
name: netezza-ssl_certificate
title: Steps to acquire SSL certificates for netezza
description: ''
last-updated: 2025-10-30
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/netezza?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

{:external: target="_blank" .external}
{:shortdesc: .shortdesc}
{:screen: .screen}
{:pre: .pre}
{:table: .aria-labeledby="caption"}
{:codeblock: .codeblock}
{:tip: .tip}
{:note: .note}
{:important: .important}

# Steps to acquire SSL certificates for netezza
{: #step_acq_sslcert}

This guide outlines two methods to acquire SSL certificates for secure connection to a Netezza instance.

## Download certificate from console admin profile
{: #method1_acq_cert_profile}

The simplest way to download the SSL certificate is directly from the console profile section:

1. Log in to the Netezza Performance Server console.
2. Navigate to the **Console Profile** section.
3. Click the **Download Certificate** option.
4. The `certificate.crt` file downloads automatically to your system.

This method provides a pre-configured certificate file that is ready to use for secure connections.

### Use certificate to connect to netezza
{: #use_certi_conn_nps}

Use the `certificate.crt` file with the `nzsql` utility:

```bash
$ nzsql -h xxxxxxxx -db system -securityLevel onlySecured -caCertFile certificate.crt -u admin -pw XXXXX

Welcome to nzsql, the IBM Netezza SQL interactive terminal.

Type:  \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL enabled connection. Cipher: TLS_AES_256_GCM_SHA384, bits: 256, protocol: TLSv1.3

SYSTEM.ADMIN(ADMIN)=> \q
```

You now have the `certificate.crt` file ready. This file can be shared with the customer for secure access.