Can anyone explain the difference between the Redshift connector components and the Postgresql connector components? If there is a difference, how are the redshift connector components optimized for RDS. Thanks, Brian
Hi
Amazon Redshift is based on PostgreSQL 8.0.2, but Amazon Redshift and PostgreSQL have a number of very important differences, some of PostgreSQL feature, datatype and function are not supported in Amazon Redshift, you can read the difference between Amazon Redshift and Postgresql in this
page. In Talend, Redshift connector and Postgresql connector are two different connectors are respectively used to integrate Amazon Redshift and PostgreSQL.
Shong
While creating a connection with the Redshift connector, there is no option to enable SSL. How can I do that? Also, is the Amazon Redshift driver used to connect to Redshift?