Configuring the Adapter for Amazon Redshift for Extended Bulk Load
Extended Bulk Load can be configured for both the ODBC and JDBC versions of the Adapter for Amazon Redshift. Extended Bulk Load requires the AWS CLI (Command Line Interface) to be installed and configured on the server node, according to vendor instructions. Once it is installed and configured:
- Your Redshift DBA must set an ID with the Amazon IAM role that permits read/write to the AWS S3 bucket destination. As a result, an encrypted Account ID, Role Name, and Role Profile is generated.
- On the WebFOCUS Reporting Server browser interface Get Data page, under Server Data Sources, right-click the configured Amazon Redshift adapter, and click Configure Bulk Load.
- Accept the default Connection Name.
- For Protocol, select AWS (Role-Based Access Control).
- For Bucket Name, enter the AWS S3 destination to which data will be uploaded.
- Enter Account ID, Role
Name, Access Key ID, Secret Access Key, and RDS Import Role Name in the
appropriate entry fields.
Note: Account ID, Role Name, Access Key ID, and Secret Access Key are needed to write stage data to the AWS S3 bucket. RDS Import Role Name is needed for authorization to run the Redshift COPY SQL command, which loads data from AWS S3 to a Redshift table.
- Configure and test a connection for Fixed Format files.
To confirm that Extended Bulk Load is configured correctly, right-click the configured Amazon Redshift connection, and click Test Bulk Load.