Network
Data Engineering
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Preparation
Cloud Integration
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
DiscoveryIQ
Cloud Data Wizard
Informatica for AWS
Informatica for Microsoft
Cloud Integration Hub
Complex Event Processing
Proactive Healthcare Decision Management
Proactive Monitoring
Real-Time Alert Manager
Rule Point
Data Integration
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Replication
Data Services
Data Validation Option
Fast Clone
Informatica Platform
Metadata Manager
PowerCenter
PowerCenter Express
PowerExchange
PowerExchange Adapters
Data Quality
Axon Data Governance
Data as a Service
Data Explorer
Data Quality
Data Security Group (Formerly ILM)
Data Archive
Data Centric Security
Secure@Source
Secure Testing
Master Data Management
Identity Resolution
MDM - Relate 360
Multidomain MDM
MDM Registry Edition
Process Automation
ActiveVOS
Process Automation
Product Information Management
Informatica Procurement
MDM - Product 360
Ultra Messaging
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
Knowledge Base
Resources
PAM (Product Availability Matrices)
Support TV
Velocity (Best Practices)
Mapping Templates
Debugging Tools
User Groups
Documentation
English
English
English
Español
Spanish
Deutsch
German
Français
French
日本語
Japanese
한국어
Korean
Português
Portuguese
中文
Chinese
Log Out
Cloud Data Integration Connectors
Current Version
Current Version
H2L
Amazon Redshift Connectors
Cloud Data Integration Connectors Current Version
Cloud Data Integration Connectors Current Version
All Products
Rename Saved Search
Name
* This field is required
Overwrite saved search
Confirm Deletion
Are you sure you want to delete the saved search?
Table of Contents
Search
No Results
Preface
Part 1: Introduction to Amazon Redshift connectors
Amazon Redshift connectors
Amazon Redshift connectors overview
Secure Agent and Amazon Redshift integration
Connector comparison
Mapping functionality
Source functionality
Target functionality
Connector use cases
Synchronization task use case
Mapping and mapping task use case
Mapping task with Oracle CDC sources use case
Elastic mapping use case
Part 2: Data Integration with Amazon Redshift V2 Connector
Introduction to Amazon Redshift V2 Connector
Amazon Redshift V2 Connector overview
Amazon Redshift V2 Supported Task Types
Introduction to Amazon Redshift
Amazon Redshift Spectrum overview
External schema and external table
Administration of Amazon Redshift V2 Connector
Configure Amazon Redshift for SSL
Prerequisites to configure SSL with the serverless runtime environment
Prerequisites to configure client-side encryption with the serverless runtime environment
Prerequisites to configure SSE-KMS encryption for elastic mappings
Create a minimal Amazon IAM policy
IAM authentication
Temporary security credentials using AssumeRole
External ID
Temporary security credentials policy
Temporary security credentials using AssumeRole for EC2
Rules and guidelines for using the temporary security credentials
Amazon Redshift Spectrum prerequisite tasks
Amazon Redshift V2 connections
Amazon Redshift V2 connections overview
Amazon Redshift V2 connection properties
Configuring proxy settings
Configuring proxy settings on Windows
Configuring proxy settings through Secure Agent Manager
Configuring the proxy settings through JVMOptions
Configuring proxy settings on Linux
Amazon Redshift V2 sources and targets
Amazon Redshift V2 sources
Amazon Redshift staging directory for Amazon Redshift V2 sources
Data encryption in Amazon Redshift V2 sources
Unload command
Unload command options
Source partitioning
Amazon Redshift V2 targets
Amazon Redshift staging directory for Amazon Redshift V2 targets
Data encryption in Amazon Redshift V2 targets
Server-side encryption for Amazon Redshift V2 targets
Client-side encryption for Amazon Redshift V2 targets
Copy command
Copy command options
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 V2 Connector
Amazon Redshift V2 objects in mappings
Amazon Redshift V2 sources in mappings
Rules and guidelines for configuring SQL query
Adding multiple source objects
Rules and guidelines for adding multiple source objects
Amazon Redshift V2 targets in mappings
Rules and guidelines for creating a target
Rules and guidelines for configuring override target query
Amazon Redshift V2 lookups in mappings
Unconnected Lookup transformation
Configuring an unconnected Lookup transformation
Enabling lookup caching
Rules and guidelines for configuring lookup transformations
Mapping task with Oracle CDC sources example
Elastic mapping example
Process SQL queries using an SQL transformation
Process SQL queries and stored procedures using an SQL transformation
Configuring a stored procedure
Rules and guidelines for stored procedures
Dynamic schema handling for mappings and elastic mappings
Rules and guidelines for dynamic schema handling for mappings and elastic mappings
Configuring key range partition
Bulk processing for write operations
Migrating a mapping
Migrating a mapping overview
Use the same object path for the migrated mapping
Use a different object path for the migrated mapping
Migration options
Parameterization rules
Rules and guidelines for migrating a mapping
Upgrading to Amazon Redshift V2 Connector
Upgrade the connection type
Connection switching example
Advanced properties retained after the switch
Rules and guidelines
Amazon Redshift pushdown optimization
Amazon Redshift pushdown optimization overview
Pushdown optimization types
Data Integration behavior with source and full pushdown optimization
Pushdown optimization scenarios
Configuring optimization for an Amazon Redshift V2 mapping task
Pushdown optimization using an Amazon Redshift V2 connection
Pushdown compatibility
Supported functions for Amazon Redshift V2 mappings
Supported operators for Amazon Redshift V2 mappings
Supported transformations for Amazon Redshift V2 mappings
Supported features for Amazon Redshift V2 mappings
Supported features for Amazon S3 V2 source
Optimizing full pushdown for multiple targets
Previewing pushdown optimization
Configuring optimization for an Amazon Redshift V2 mapping task
Rules and guidelines for pushdown optimization
Rules for full pushdown optimization in mappings that read from and write to Amazon Redshift
Rules and guidelines for functions
Rules and guidelines for Router transformations
Rules and guidelines for Lookup transformations
Pushdown optimization using the Amazon Redshift ODBC connection
Configuring Amazon Redshift ODBC connection
Configuring Amazon Redshift ODBC connection on Windows
Configuring Amazon Redshift ODBC connection on Linux
Creating an ODBC connection
Configuring optimization for an Amazon Redshift ODBC mapping task
Configuring an unconnected Lookup transformation
Cross-Schema pushdown optimization
Configuring cross-schema optimization for an Amazon Redshift V2 mapping task
Configuring a custom query or an SQL override for the Amazon Redshift source object
Supported functions and operators for Amazon Redshift mappings
Supported transformations for Amazon Redshift ODBC mappings
Rules and guidelines for pushdown optimization
Data type reference
Data type reference overview
Amazon Redshift and transformation data types
Troubleshooting
Troubleshooting overview
Troubleshooting for Amazon Redshift V2 Connector
Part 3: Data Integration with Amazon Redshift Connector
Introduction to Amazon Redshift Connector
Amazon Redshift Connector overview
Amazon Redshift supported task types and object types
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 connections overview
Amazon Redshift connection properties
Configuring proxy settings
Configuring proxy settings on Windows
Configuring proxy settings through Secure Agent Manager
Configuring the proxy settings through JVM Options
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
Data encryption in Amazon Redshift sources
Client-side encryption for Amazon Redshift sources
Unload command
Unload command options
Partitioning
Amazon Redshift targets
Amazon Redshift staging directory for Amazon Redshift targets
Analyze target table
Data encryption in Amazon Redshift targets
Server-side encryption for Amazon Redshift targets
Client-side encryption for Amazon Redshift targets
Retain staging files
Copy command
Copy command options
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 objects in mappings
Amazon Redshift sources in mappings
Configuring key range partitioning
Amazon Redshift targets in mappings
Amazon Redshift lookups in mappings
Amazon Redshift objects in template-based mapping tasks
Amazon Redshift sources in mapping tasks
Amazon Redshift targets in mapping tasks
Amazon Redshift pushdown optimization
Amazon Redshift pushdown optimization overview
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 pushdown optimization
Configuring cross-schema optimization for an Amazon Redshift mapping task
Rules and guidelines for functions in pushdown optimization
Data type reference
Data type reference overview
Amazon Redshift and transformation data types
Troubleshooting
Troubleshooting overview
Troubleshooting for Amazon Redshift Connector
Troubleshooting Amazon Redshift connection
Amazon Redshift Connectors
Amazon Redshift Connectors
Back
Next
Preface
Preface
Use
Amazon Redshift Connectors
to learn about
Amazon Redshift
and
Amazon Redshift V2 Connectors.
Use Part I to know the overview and the functionality comparison between Amazon Redshift V2 and Amazon Redshift connectors. Use Part II and Part III to learn about the functionality available for Amazon Redshift connectors.
Updated May 13, 2022
Download Guide
Send Feedback
Resources
Cloud Connectivity Homepage
Communities
Knowledge Base
Success Portal
Back to Top
Back
Next