•  Part I: Introduction to Amazon Redshift connectors
  •  Introduction to Amazon Redshift connectors
    •  Secure Agent and Amazon Redshift integration
  •  Connector comparison
    •  Mapping functionality
    •  Source functionality
    •  Target functionality
  •  Task Examples
    •  Synchronization task use case
    •  Mapping and mapping task use case
    •  Mapping task with Oracle CDC sources use case
    •  Use case for a mapping in advanced mode
•  Part II: Data Integration with Amazon Redshift V2 Connector
  •  Introduction to Amazon Redshift V2 Connector
    •  Amazon Redshift V2 Connector assets
    •  Introduction to Amazon Redshift
    •  Amazon Redshift Spectrum overview
  •  Connections for Amazon Redshift V2
    •  Prepare for authentication
    •  Create a minimal Amazon IAM policy
    •  Configure IAM authentication
    •  Configure an assume role for Amazon Redshift
      •  Generate temporary security credential policies for Amazon Redshift
      •  Generate temporary security credentials using AssumeRole for EC2
    •  Configure an assume role for Amazon S3 staging
      •  Generate temporary security credentials using AssumeRole for Amazon S3 staging
      •  Generate temporary security credentials using AssumeRole for EC2
    •  Enable encryption
    •  Connect to Amazon Redshift
      •  Before you begin
      •  Connection details
      •  Authentication types
      •  Related links
    •  Proxy server settings
    •  Configure SSL
      •  Configure SSL with the serverless runtime environment
    •  Configure client-side encryption with the serverless runtime environment
    •  Configure SSE-KMS encryption for mappings in advanced mode
    •  Amazon Redshift Serverless connectivity
    •  Requirements to use Amazon Redshift Spectrum
    •  Private communication with Amazon Redshift
    •  Private communication with Amazon S3
    •  VPC peering between the serverless runtime environment and Amazon Redshift
  •  Amazon Redshift sources and targets
    •  Amazon Redshift V2 sources
      •  Read from Amazon Redshift with or without staging
      •  Data encryption in Amazon Redshift V2 sources
      •  Unload command
      •  Source partitioning
    •  Amazon Redshift V2 targets
      •  Amazon Redshift staging directory for Amazon Redshift V2 targets
      •  Data encryption in Amazon Redshift V2 targets
      •  Copy command
      •  Analyze target table
      •  Retain staging files
      •  Vacuum tables
      •  Recovery and restart processing
      •  Preserve record order on Write
      •  Octal values as DELIMITER and QUOTE
      •  Success and error files
  •  Mappings and mapping tasks with Amazon Redshift
    •  Before you begin
      •  Create an external schema and table for Amazon Redshift Spectrum
    •  Amazon Redshift V2 objects in mappings
      •  Amazon Redshift V2 sources in mappings
      •  Rules and guidelines for reading data
      •  Rules and guidelines for configuring SQL query
      •  Adding multiple source objects
      •  Amazon Redshift V2 targets in mappings
      •  Amazon Redshift V2 lookups in mappings
      •  Mapping task with Oracle CDC sources example
      •  Mapping in advanced mode example
      •  SQL transformation
      •  Dynamic schema handling for mappings
      •  Configuring key range partition
      •  Bulk processing for write operations
      •  Optimize the staging performance for a mapping
  •  Migrating a mapping
    •  Use the same object path for the migrated mapping
    •  Use a different object path for the migrated mapping
      •  Migration options
      •  Rules and guidelines for migrating a mapping
  •  Upgrade the connection type
    •  Connection switching example
    •  Advanced properties retained after the switch
    •  Rules and guidelines
  •  SQL ELT with Amazon Redshift V2 Connector
    •  SQL ELT configuration options
      •  Create a mapping in SQL ELT mode
      •  Enable SQL ELT optimization for a mapping task
    •  SQL ELT query preview
    •  Mappings in SQL ELT mode for Amazon Redshift
      •  Sources in mappings in SQL ELT mode
      •  Targets in mappings in SQL ELT mode
      •  Transformations in mappings in SQL ELT mode
      •  Functions in mappings in SQL ELT mode
      •  Operators in mappings in SQL ELT mode
      •  Rules and guidelines in mappings in SQL ELT mode
    •  SQL ELT optimization for mapping tasks
      •  SQL ELT optimization types
      •  SQL ELT optimization scenarios
      •  SQL ELT compatibility
      •  Configuring SQL ELT optimization
      •  Transformations for Amazon Redshift V2 mappings
      •  Features
      •  SQL ELT optimization for multiple targets
      •  Determine the order of processing for multiple targets
      •  Clean stop a SQL ELT optimization job
      •  Rules and guidelines for SQL ELT optimization
  •  Data type reference
    •  Amazon Redshift and transformation data types
    •  Rules and guidelines for data types
  •  Troubleshooting
    •  Troubleshooting for Amazon Redshift V2 Connector
•  Part III: Data Integration with Amazon Redshift Connector
  •  Introduction to Amazon Redshift Connector
    •  Amazon Redshift Connector assets
    •  Introduction to Amazon Redshift
    •  Amazon Redshift Connector example
    •  Administration of Amazon Redshift Connector
      •  Configure Amazon Redshift Connector for SSL
      •  Create a minimal Amazon IAM policy
      •  IAM authentication
  •  Amazon Redshift connections
    •  Amazon Redshift connection properties
    •  Configuring proxy settings
      •  Configuring proxy settings on Windows
      •  Configuring proxy settings on Linux
  •  Amazon Redshift sources and targets
    •  Amazon Redshift sources
      •  Amazon Redshift staging directory for Amazon Redshift sources
      •  Server-side encryption for Amazon Redshift sources
      •  Client-side encryption for Amazon Redshift sources
      •  Unload command
      •  Partitioning
    •  Amazon Redshift targets
      •  Amazon Redshift staging directory for Amazon Redshift targets
      •  Analyze target table
      •  Data encryption in Amazon Redshift targets
      •  Retain staging files
      •  Copy command
      •  Field mappings
      •  Vacuum tables
    •  Working with large tables
    •  Octal values as DELIMITER and QUOTE
    •  Success and error files
  •  Synchronization tasks with Amazon Redshift
    •  Amazon Redshift sources in synchronization tasks
    •  Amazon Redshift targets in synchronization tasks
    •  Amazon Redshift lookups in synchronization tasks
    •  Rules and guidelines for synchronization tasks
    •  Synchronization task example
  •  Mappings and mapping tasks with Amazon Redshift
    •  Amazon Redshift sources in mappings
      •  Configuring key range partitioning
    •  Amazon Redshift targets in mappings
    •  Amazon Redshift lookups in mappings
    •  Amazon Redshift objects in mapping tasks
      •  Amazon Redshift sources in mapping tasks
      •  Amazon Redshift targets in mapping tasks
  •  Amazon Redshift SQL ELT optimization
    •  Supported functions and operators for Amazon Redshift mappings
    •  Configuring Amazon Redshift ODBC connection
      •  Configuring Amazon Redshift ODBC connection on Windows
      •  Configuring Amazon Redshift ODBC connection on Linux
      •  Creating an ODBC connection
    •  Cross-schema SQL ELT optimization
      •  Configuring cross-schema SQL ELT optimization for an Amazon Redshift mapping task
    •  Rules and guidelines for functions in SQL ELT optimization
  •  Data type reference
    •  Amazon Redshift and transformation data types
  •  Troubleshooting
    •  Troubleshooting for Amazon Redshift Connector
    •  Troubleshooting Amazon Redshift connection

Part I: Introduction to Amazon Redshift connectors

Troubleshooting Amazon Redshift connection

CDI_REDSHIFTV2_PREPARE_FOR_AUTHENTICATION

CDI_REDSHIFTV2_AMAZON_IAM_POLICY

CDI_REDSHIFTV2_IAM_AUTHENTICATION

CDI_REDSHIFTV2_ASSUMEROLE_REDSHIFT

CDI_REDSHIFTV2_ASSUMEROLE_S3STAGING

CDI_REDSHIFTV2_ENABLE_ENCRYPTION

AMAZON_RSV2_CONN

AMAZON_RSV2_CONN-CONN_NAME

AMAZON_RSV2_CONN-CONN_DESC

AMAZON_RSV2_CONN-CONN_TYPE

AMAZON_RSV2_CONN-AGENTGROUPID

AMAZON_RSV2_CONN-AUTHENTICATIONTYPE

AMAZON_RSV2_CONN-AUTHENTICATIONTYPE-DEFAULT

AMAZON_RSV2_CONN-JDBCURL

AMAZON_RSV2_CONN-USERNAME

AMAZON_RSV2_CONN-PASSWORD

AMAZON_RSV2_CONN-USEEC2ROLETOASSUMEROLE

AMAZON_RSV2_CONN-IAMROLEARN

AMAZON_RSV2_CONN-AWSACCESSKEYID

AMAZON_RSV2_CONN-AWSSECRETACCESSKEY

AMAZON_RSV2_CONN-S3ENDPOINTTYPE

AMAZON_RSV2_CONN-INTERFACE ENDPOINT-S3ENDPOINTDNSNAME

AMAZON_RSV2_CONN-STSVPCENDPOINTTYPE

AMAZON_RSV2_CONN-INTERFACE_ENDPOINT-STSENDPOINTDNSNAME

AMAZON_RSV2_CONN-KMSVPCENDPOINTTYPE

AMAZON_RSV2_CONN-INTERFACE_ENDPOINT-KMSENDPOINTDNSNAME

AMAZON_RSV2_CONN-EXTERNALID

AMAZON_RSV2_CONN-REGION

AMAZON_RSV2_CONN-CONNECTIONENVIRONMENTSQL

AMAZON_RSV2_CONN-MASTERSYMMETRICKEY

AMAZON_RSV2_CONN-CUSTOMERMASTERKEYID

AMAZON_RSV2_CONN-AUTHENTICATIONTYPE-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-CLUSTERIDENTIFIER

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-DATABASENAME

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-REDSHIFTIAMROLEARN

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-REDSHIFTACCESSKEYID

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-REDSHIFTSECRETACCESSKEY

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-DATABASEGROUP

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-EXPIRATIONTIME

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-AUTOCREATEDBUSER

CDI_REDSHIFTV2_PROXY_SERVER_SETTINGS

CDI_REDSHIFTV2_CONFIG_SSL

CDI_REDSHIFTV2_CLIENT_ENCRYPTION_SERVERLESS

CDI_REDSHIFTV2_SSE_ENCRYPTION_ADVANCED_MODE

CDI_REDSHIFTV2_SERVERLESS_CONNECTIVITY

CDI_REDSHIFTV2_PREREQ_REDSHIFT_SPECTRUM

CDI_REDSHIFTV2_PRIVATE_COMMUNICATION

CDI_REDSHIFTV2_VPC_PEERING_SERVERLESS

AMAZON_RS_CONN