Establishing a Connection 

Redshift Connection String

The following connection string is required to establish Redshift database connection with Lyftron

Server=[Servername];Username=[Username];Password=[Password];Database=[Databasename];Port=5439

Connecting to Redshift

The following connection properties are required in order to connect to data.

• Server: The host name or IP of the server hosting the Redshift database.
• Port: The port of the server hosting the Redshift database.

You can also optionally set the following:

• Database: The default database to connect to when connecting to the Redshift Server. If this is not set, the user's default database will be used.

You can obtain these values in the AWS Management Console:

1. Open the Amazon Redshift console (http://console.aws.amazon.com/redshift).
2. On the Clusters page, click the name of the cluster.
3. On the Configuration tab, obtain the properties from the Cluster Database Properties section. The connection property values will be the same as the values set in the ODBC URL.

Connect Using Standard Authentication

 To authenticate using standard authentication, set the following:

• User: The user which will be used to authenticate with the Redshift server.
• Password: The password which will be used to authenticate with the Redshift server.

Connect Using SSL Authentication

You can leverage SSL authentication to connect to Redshift data via a secure session. Configure the following connection properties to connect to data:

• SSLClientCert: Set this to the name of the certificate store for the client certificate. Used in the case of 2-way SSL, where truststore and keystore are kept on both the client and server machines.
• SSLClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.
• SSLClientCertSubject: The subject of the TLS/SSL client certificate. Used to locate the certificate in the store.
• SSLClientCertType:; The certificate type of the client store.
• SSLServerCert: The certificate to be accepted from the server.

Connect Using SSO Authentication

Alternatively, you can connect to Redshift data using single sign-on (SSO). Configure the following connection properties to connect to data:

• SSOProvider: The name of the SSO provider you are trying to authenticate. The following options are available: OKTA, OneLogin, and ADFS.
• SSOLoginUrl: Set this to the login url associated with the SSO provider.
• SSOUser: The username of the SSO Provider used to authenticate the user.
• SSOPassword: The password of the SSO Provider used to authenticate the user.

Redshift QuickStart Steps

Step1: Go to Connections --> Click on Add Connection --> Add the connection name

 Step2: Provide the connection details --> Click on test connection --> if no error then connection. is successful

Step3: Go to the Database --> Click on add Database --> Give Database name --> Choose the existing connection that we have made in Step2 --> Click next to Import Metadata--> Choose the tables to import --> Click create --> Now your Redshift database is ready for the pipeline

Step4: Click on the migrate data button --> Choose your source dataset to import --> Click next --> Choose the tables to migrate --> Choose import --> Choose the tables that you want to replicate to Redshift --> Click on Replicate to a target table --> Choose schema --> Choose table name -->Click Update --> Click on the management tasks --> Click on load data

Steps5: Query your data by dragging and dropping the tables that's been loaded by your pipeline