Devart Forums

Posted: **Tue 25 Sep 2018 09:26**

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

Posted: **Thu 27 Sep 2018 13:49**

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.)

Devart Forums

Create runtime Redshift connection

Create runtime Redshift connection

Re: Create runtime Redshift connection