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 the "Uploading the Database Driver" section in Driver Management.

Connection Information Collection

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

• IP address and port number of the server where the database is located

• 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, click Create, and select 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 the data connection module. For details, see Data Connection Permission Overview.

2. Select the Amazon Redshift database, as shown in the following figure.

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

Note:

You can modify other advanced settings as needed. For details, see the "Advanced Settings" section 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 database tables cannot be accessed from FineBI.

Reason:

Simply put, database tables can be divided into two categories: 

1. Standard Table/View: You can directly access these tables by adding database tables in FineBI; 

2. External Table: You cannot access these tables by adding database tables in FineBI, but you can access them through SQL queries (by writing SQL statements directly).

Database tables that are missing in FineBI  are possibly external tables (not standard tables/views). Since FineBI's database mapping only includes standard tables/views, you cannot access the external tables directly in FineBI.

Solution:

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