Amazon Redshift is an Internet hosting service and data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.
Below you will find details on how to configure the K3 Redshift Adaptor to connect an Amazon Redshift instance.
Redshift Target Adaptor
The K3 Amazon Redshift Target Adaptor supports pushing data to an Amazon Redshift database. The following instructions will walk you through how to set up the Redshift Target adaptor.
1. Enter the connection information and click the Test button
Assuming the connection information is correct a success message will be shown. If you have successfully tested the connection click the OK button.
||Enter the Database Server and database useing the following format:
||Enter a user that has permissions to ready from the Redshift database which you will be connecting to.
||Enter a password for the user provided in the DB User field.
2. Click the Build Query Button
Clicking Build Statement starts the process of building the SQL Insert Statement to push data into the Redshift database previously configured.
3. Select the table to insert into
The Statement Builder screen allows you to select a table to insert into without manually writing any SQL. Select the table to insert into, from the list of tables in the drop-down list.
4. Select the columns K3 should insert data into
Selecting the columns will build an insert query using those columns and create the target field list in K3. You are able to see the query and modify that query by clicking "Customize Query". Using "Customize Query" is only recommended for advanced users. Once you have selected the desired columns, click OK.
5. Review the Insert
Once you complete the field selection process and click save the Insert statement will be displayed. At this point, the adaptor is configured. Please be aware that you must configure the source adaptor and name the route before moving on.
If you ever need to adjust the Insert statement you can click Edit Statement. This will bring you back into the column selection process.
Note: The columns identified in the Column selection will be available to add to the Target Field list when you initially attempt to add fields.