Manage the Amazon Redshift Connector
Connecting to Amazon Redshift in Visual Data Discovery
This applies to: Visual Data Discovery
The Symphony Amazon Redshift connector lets you access the data available in Amazon Redshift storage using the Symphony client. The Amazon Redshift connector supports Amazon Redshift version 1.0.
Before you can establish a connection from Symphony to Amazon Redshift storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions and Connect to Amazon Redshift in Visual Data Discovery and Troubleshoot the Amazon Redshift Connector for details specific to the Amazon Redshift connector.
After setting up the connector, create data sources that specify the necessary connection information and identify the data you want to use. See Manage Visual Data Discovery Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Data Discovery Dashboards.
Feature Support
Connector support for specific features is shown in the following table.
Key: Y - Supported; N - Not Supported; N/A - not applicable
Connect to Amazon Redshift in Visual Data Discovery
Verify the MTU Size of Symphony
Before you can establish a connection between Amazon Redshift and Symphony, you must verify that the size of the maximum transmission unit (MTU) on your Symphony 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 command:
$ ip addr show eth0
If you need to edit the MTU value and set the size to 1500, use the following ip command:
$ 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. For more information, see Add 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:
jdbc:redshift://HOSTNAME:PORT/DATABASE_NAME
. If authentication has been set up, provide the user name and password.
Connect to Amazon Redshift in Managed Dashboards and Reports
This applies to: Managed Dashboards, Managed Reports
Main article: Connect to data and view it on a dashboard
AWS account
Use your AWS account to set up Amazon Redshift and find its connection details.
Sign in to your AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.
Open the details for your cluster and find and copy the ODBC URL, which contains the connection string. For details, see Amazon Redshift's getting started guide on how to get your connection string.
Data connector settings
Once you have your connection string, you can set up a data connector in Symphony. Set Data Provider to Amazon Redshift.
Paste the Connection String, and enter the Password if not already included in the connection string.
Additional options such as Search Path for specifying schemas are available by selecting the expandable sections below. You can also select Test connection to check your connection.