Managing the Amazon Redshift Connector
The Composer Amazon Redshift connector lets you access the data available in Amazon Redshift storage using the Composer client. The Composer Amazon Redshift connector supports Amazon Redshift version 1.0.1.
Before you can establish a connection from Composer to Amazon Redshift storage, a connector server needs to be installed and configured. See Managing Connectors and Connector Servers for general instructions and Connecting to Amazon Redshift for details specific to the Amazon Redshift connector.
After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Composer v6 Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Creating Dashboards.
Amazon Redshift support for specific Composer features is shown in the following table.
Key: P - Supported; O - Not Supported; N/A - not applicable
Amazon Redshift returns whole numbers for aggregates on columns of type DECIMAL and NUMERIC types which have a 0 scale (in other words, 0 decimal places).
Verify the MTU Size of Composer
Before you can establish a connection between Amazon Redshift and Composer, you must verify that the size of the maximum transmission unit (MTU) on your Composer server is set to 1500.
The MTU size determines the maximum size, in bytes, of a packet that can be transferred in one Ethernet frame over your network connection. If your MTU size is too large for the connection, you might experience incomplete query results, your query might hang, or the connection might be dropped altogether. For more information, see this AWS documentation link: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-drop-issues.html.
To review the MTU value, use the
$ ip addr show eth0
If you need to edit the MTU value and set the size to 1500, use the following
$ ip link set dev eth0 mtu 1500
Configure and Reference the JDBC Driver
The Amazon Redshift connector requires a JDBC driver to be configured before you connect. You can download the driver from the vendor's site. If you are upgrading, keep in mind you need to configure the JDBC driver- see Upgrade the Composer v6 Server. For more information, see Adding a JDBC Driver. The JDBC Driver for Redshift has more than one jar file that needs to be downloaded: be sure to place the files in the same location to avoid any issues.
When setting up your Amazon Redshift connection, you need to specify the JDBC URL. You can find the URL on the
Configuration tab of a cluster under
Cluster Database Properties. The format varies slightly based on the type of database being connected. For Amazon Redshift, use the following format:
. If authentication has been set up, provide the user name and password