Connect to Amazon Redshift

Avinash

Discussion

Hi:

Has anybody connected Outsystems to Amazon Redshift database? We have not been able to do so.
Any help is appreciated.

09 Sep 2015

Ricardo Silva

What have you tried? What were your results?

The OutSystems Platform does not support natively Amazon Redshift database. However, Amazon Redshift appears to be based on PostgreSQL. Have you tried using the (user built) PostgreSQL database plugin ?

I'm the author and I would be interested in knowing any difficulty you had while trying to connect to an Amazon Redshift database, if you have tried using the ardoPostgreSQL plugin.

10 Sep 2015

Avinash

Hi Ricardo:

My outsystems admin tried the following

In the server field, I tried:

1: logidwa.cmj8jk61oxi0.us-west-2.redshift.amazonaws.com

2: logidwa.cmj8jk61oxi0.us-west-2.redshift.amazonaws.com:5439

3: postgresql://logidwa.cmj8jk61oxi0.us-west-2.redshift.amazonaws.com:5439

4: postgresql://logidwa.cmj8jk61oxi0.us-west-2.redshift.amazonaws.com:5439/dwa?tcpKeepAlive=true

In the database field I entered:

dwa

In the Username and Password fields, I entered the values that you sent to me.

The errors that came back were all similar to:

Connection String test failed: Failed to establish a connection to 'logidwa.cmj8jk61oxi0.us-west-2.redshift.amazonaws.com:5439'.

10 Sep 2015

Ricardo Silva

Where are you trying to configure this? Can you please share a screenshot?

11 Sep 2015

Avinash

HI Ricardo:

Attached is the screen shot

image (3).png

11 Sep 2015

Ricardo Silva

Ok, you are using my PostgreSQL connector.

The current version doesn't seem to work very well with redshift due to an incompatibility in the version of the npgsql library which I use to connect to the database.

However, it seems that newer versions of the library work. I have tested and was able to connect to it. I will do some further testing to better understand the implications. I hope to be able to come up with more information during the weekend, where I'll be able to pick this up.

11 Sep 2015

Ricardo Silva

Hello Avinash,

The latest release of ardoPostgreSQL adds preliminary support to Redshift.

Feel free to test it out. Please bear in mind the limitations I mention on the release notes.

12 Sep 2015

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines