Create runtime Redshift connection

[miguelenguica]

Hi,

Can you share a runtime example of how to create a AWS redshift connection? What's the provider name? I've tried the following with 'PostgreSQL' and 'Redshift' under the ProviderName property, without success. Your help doesn't list all the possible values for it.

Code: Select all

 data_connection:= TUniConnection.Create(nil);
 data_connection.ProviderName:= 'Redshift';
 data_connection.Server:= 'dw.*****.com';
 data_connection.Port:= 5439;
 data_connection.Username:= '*****';
 data_connection.Password:= '**********;
 data_connection.Database:= 'my_data';
 data_connection.LoginPrompt:= False;
 data_connection.Connect;

I'm using UniDAC v7.3.1

[MaximG]

We checked the code fragment you sent and found no problems. In our test environment, we successfully connected to Amazon Redshift by selecting 'Redshift' as the value of the data_connection.ProviderName property.
This value should be specified when working with this cloud service. Details about the ProviderName property are available at:
https://www.devart.com/unidac/docs/deva ... ername.htm

Please explain which error you get when trying to establish connection in the way you indicated. Also, make sure that Amazon Redshift is available in your environment (anti-virus, firewall, etc.)