Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Anchor
top
top

Table of Contents
classcontents

Setup

Styleclass
ClasstopLink

top

Redshift Settings

Section
Column
width40%

1. Log in to Amazon Web Services (AWS).

2. Open the Services menu at the top of the page, click on Redshift within the Database category.

Column
width60%

Location

Section
Column
width40%

While on the Amazon Redshift page it's important to select the closest location to your users. This will generally result in the fastest response times.

3. Click on the Location currently in use next to your name at the top right of the page.

4. Select the location closest to you.

Column
width60%

Create Cluster

Section
Column
width40%

5. While still on the Amazon Redshift page, click on the Launch Cluster button.

From here you will be walked through a setup process where you define and configure the cluster.

Column
width60%

Cluster Details

Section
Column
width40%

On this step you will need to define the following:

  • Cluster Identifier
  • Database Name
  • Database Port
  • Master User Name
  • Master Password

Each option is documented on the page.

6. Configure the cluster details and click the Continue button.

Column
width60%

Node Configuration

Section
Column
width40%

Here you will need to define the number and types of nodes. Each option is documented on the page.

7. Define the Type and Number of Nodes. Click Continue.

Column
width60%

Additional Configuration

Section
Column
width40%

Finally, there are some additional configuration items you can define, depending on the your network and security requirements. Each option is documented on the page.

8. Click the Continue button.

Column
width60%

Review & Launch

Section
Column
width40%

On the final step you are able to review all the configuration options you've applied in the previous steps.

9. Click the Launch Cluster option to finish.

Column
width60%

View Clusters

Section
Column
width40%

You will now be presented with a message informing you that your cluster is being created.

10. Click the Close button to return to a list of available clusters.

Column
width60%

Cluster Name

Section
Column
width40%

Click on the name of your cluster in order to view its properties.

Column
width60%

Cluster Details

Section
Column
width40%

Here you will be able to view all the details related to your cluster, including items important for Yellowfin use:

  • Custer Name
  • End Point
  • Port
  • Database Name
  • Master User Name
  • Public IP

Make a note of the above values.

Column
width60%


Yellowfin

Styleclass
ClasstopLink

top

Login

Section
Column
width40%

1. Login to your Yellowfin instance.

2. Click on the Administration link in the main navigation bar and select Admin Console.

Column
width60%

Add Data Source

Section
Column
width40%

3. Expand the Data Sources list in the centre panel of the Admin Console.

4. Click on the Add button to create a new connection.

Column
width60%

Data Source Details

Section
Column
width40%

Here you will need to provide a range of information to tell Yellowfin what the connection is, and how to access the database.

5. Define the Data Source Details, Security, and Connection Pool options based on your requirements.

See Source Connection Parameters for more information.

Column
width60%


Connection Details

Section
Column
width40%

6. In order to connection to your Redshift cluster, define the following:

  • Connection Method: JDBC
  • Authentication: Standard Authentication
  • Database: Amazon Redshift
  • Include schema in SQL: (ticked)
  • Host: this is the Public IP or Endpoint information (either can be used, depending on the security settings you applied) found on your Cluster Details page earlier.
  • Port: this is the Port found on your Cluster Details page earlier.
  • Database: this is the Database Name found on your Cluster Details page earlier.
  • User Name: this is the Master User Name found on your Cluster Details page earlier.
  • Password: this is the password you entered while configuring your cluster earlier.
  • Schema: None

7. Test the connection and click Save.

Column
width60%

You are now ready to add data to your Cluster and build reports.

horizontalrule
Styleclass
ClasstopLink

top