If the client computer can connect to the Amazon Redshift database, the following message appears: In Advanced Options, specify values for the logging option and other options.Ĭhoose Test. Results to your SQL client tool or application. In the Cursor tab, specify options on how to return query In the Proxy tab, specify any proxy connection setting. However, for production environments and when secure data exchange is required, use verify-ca or verify-full. In a test environment, you might use prefer. Under the Authentication section, specify the configuration options to configure standard or IAM authentication.Ĭhoose SSL Options and specify a value for the following: Authentication modeĬhoose a mode for handling Secure Sockets Layer (SSL). If you followed the Amazon Redshift Getting Started Guide, enter dev. Otherwise, use the name that you chose during the launch process. If you launched your cluster without specifying a database Depending on the port you selected when creating, modifying or migrating the cluster, allow access to the selected port.Įnter the name of the Amazon Redshift database. You can find this information in the Amazon Redshift console on the cluster'sĬonfiguring connections in Amazon RedshiftĮnter the port number that the database uses.
Specify the endpoint host for your Amazon Redshift cluster. You might type exampleclusterdsn to make it easy to remember the cluster that you associate with this DSN. For example, if you followed the Amazon Redshift Getting Started Guide, Under the Connection Settings section, enter the following information:Įnter a name for the data source. The Amazon Redshift ODBC Driver DSN Setup window opens. The Create New Data Source window opens.Ĭhoose the Amazon Redshift ODBC driver (圆4), and then choose Finish. Or the User DSN tab to configure the driver for your database user account only.Ĭhoose Add.
Tab and locate the following driver folder:Ĭhoose the System DSN tab to configure the driver for all users on the computer, In the ODBC Data Source Administrator, choose the Driver Make sure that you choose the ODBC Data Source Administrator that has the same bitnessĪs the client application that you are using to connect to Amazon Redshift. In the Start menu, type "ODBC Data Sources." Choose ODBC Data Sources.
0 kommentar(er)
