Prerequisites for backups and restores on AWS

Deployment options: Netezza Performance Server for Cloud Pak for Data

Before you can do backups and restores on AWS, complete the prerequisite steps.

Procedure

  1. Create an S3 bucket without public access.
    You can find more details here.
  2. Create an IAM policy with a specific s3 bucket resource access.
    Replace arn:aws:s3:::placeholder with your s3 bucket ARN in the following template and use it to create the IAM policy.
    {
        "Version": "2012-10-17",
        "Statement": [
            {
                "Sid": "VisualEditor0",
                "Effect": "Allow",
                "Action": "s3:ListBucket",
                "Resource": "arn:aws:s3:::placeholder"
            },
            {
                "Sid": "VisualEditor1",
                "Effect": "Allow",
                "Action": [
                    "s3:PutObject",
                    "s3:GetObjectAcl",
                    "s3:GetObject",
                    "s3:GetObjectTagging",
                    "s3:PutObjectTagging",
                    "s3:DeleteObject",
                    "s3:PutObjectAcl"
                ],
                "Resource": "arn:aws:s3:::placeholder/*"
            }
        ]
    }
  3. Create a user Access type of Programming access without the AWS Management Console Access.

    Do not enable the MFA (Multi Factor Authentication).

  4. Use the API key in the Netezza Performance Server dashboard for storing the database backup.