Data Connection to Amazon Redshift

Version

Application Scenario

This document introduces how to connect to the Amazon Redshift database in FineBI.

Version/Driver

Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management.

Connection Information Collection

Before connecting the database, you need to collect the following information:

• IP address and port number of the database server

• Username and password of the database

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

Note:

 If you are not the admin, you can configure data connections only after the admin assigns you the permission on Data Connection Management. For details, see Data Connection Permission Overview.

2. Find the Amazon Redshift icon, as shown in the following figure.

3. Select Custom from the Driver drop-down list, select the driver uploaded in section "Version/Driver", and enter the connection information collected in section "Connection Information Collection."

Note:

You can optionally modify other advanced settings. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

4. Click Click to Connect Database, and select the required schema after successful connection. (If no schema is selected, the default schema will be used.) Finally, save the data connection, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

Problem:

Some data tables cannot be accessed from the database (DB).

Reason:

In short, database tables can be divided into two categories.
1. Standard Table/View: FineBI can directly access the tables of this type from the DB.
2. External Table: FineBI cannot access the tables of this type from the DB, but can access them through SQL (by writing SQL statements directly).

Since some tables in the DB are possibly of the External Table type, which are inconsistent with the tables of the Standard Table/View type in FineBI, you cannot access these tables directly from the DB.

Solution:

You can access these data tables through SQL (by writing SQL statements directly).