disable: SSL is disabled and the connection is not encrypted.The following sslmode values from the client connection are supported: ODBC DSNs contain an sslmode setting that determines how to handle encryption for client connections and server certificate verification. Connect via SSL Īmazon Redshift supports Secure Sockets Layer (SSL) connections to encrypt data and server certificates to validate the server certificate that the client connects to. The Redshift cluster is now visible on Navicat, alongside every other database it is connected to. Go back to your browser, open the AWS console, go to Redshift and select your cluster:Ĭopy the endpoint, port, database name and username into the relevant fields in Navicat, along with the password you created when you setup the cluster:Ĭlick "Test Connection" to check that it is working. With the exception of the password, these are all available directly from the AWS UI. We now need to enter the host name, port, database, username and password. Open Navicat, select "Connection" -> "PostgreSQL" to establish a new connection: (Especially where those queries are being hand crafted rather than generated by the client itself so that the user can make sure any SQL is Redshift-compatible.) We've found that many other Postgres clients generally do work with Redshift for most queries. Only specific versions of these drivers work with Redshift. Note: Redshift can be accessed using PostgreSQL JDBC or ODBC drivers. In this tutorial, we will connect using Navicat, a database querying tool which we recommend (30-day trial version are available from the Navicat website). Directly connect Īmazon has helpfully provided detailed instructions for connecting to Redshift using SQL Workbench. There are two ways to connect to your Redshift cluster.
0 Comments
Leave a Reply. |