- #Amazon redshift jdbc driver connection how to
- #Amazon redshift jdbc driver connection install
- #Amazon redshift jdbc driver connection drivers
- #Amazon redshift jdbc driver connection verification
- #Amazon redshift jdbc driver connection windows
You install the Amazon Redshift ODBC driver on client computers accessing an Amazon Redshift data warehouse.Įach computer where you install the driver must meet a Install the Amazon Redshift ODBC driver on Windows, see Amazon Redshift ODBC Connector Installation and Configuration Guide.
#Amazon redshift jdbc driver connection how to
For information about how to configure logging on To help troubleshooting, configure logging. For informationĪbout how to configure TCP keepalives on Windows, see Amazon Redshift ODBC Connector Installation and Configuration Guide.
#Amazon redshift jdbc driver connection windows
For more information, see Troubleshooting connection issues inĬonfigure TCP keepalives on Windows to prevent connections from timing out. If the client computer fails to connect to the database, you can troubleshoot You see the following message: Connection If the client computer can connect to the Amazon Redshift database, Windows" in Amazon Redshift ODBC Connector Installation and Configuration Guide.Ĭhoose Test. For more information, see "Configuring Data Type Options on Under Data Type Options, specify values for data For more information, see "Configuring Logging Options on Windows" in In Logging Options, specify values for the For more information, see "Configuring Additional Options on Windows" inĪmazon Redshift ODBC Connector Installation and Configuration Guide. Under Additional Options, specify options on how to return query results to your SQLĬlient tool or application.
#Amazon redshift jdbc driver connection verification
Verification on Windows" in Amazon Redshift ODBC Connector Installation and Configuration Guide. Information about using SSL on Windows, see "Configuring SSL Production environments and when secure data exchange is required, In a testĮnvironment, you might use prefer. Under SSL Settings, specify a value for theĬhoose a mode for handling Secure Sockets Layer (SSL). On Windows" in Amazon Redshift ODBC Connector Installation and Configuration Guide.
For informationĪbout authentication options, see "Configuring Authentication Options to configure standard or IAM authentication. Under Authentication, specify the configuration The Amazon Redshift Getting Started Guide, enter The name that you chose during the launch process. If you launched yourĬluster without specifying a database name, enter DatabaseĮnter the name of the Amazon Redshift database. Use the port that the cluster was configured to use PortĮnter the port number that the database uses. More information, see Configuring connections in Amazon Redshift. Information in the Amazon Redshift console on the cluster's details page. Specify the endpoint for your Amazon Redshift cluster. For example, if you followed theĪmazon Redshift Getting Started Guide, you might typeĮxampleclusterdsn to make it easy to remember theĬluster that you associate with this DSN. Want to identify the data source later when you create theĬonnection to the cluster. Under Connection Settings, enter the followingĮnter a name for the data source. Third-party application that is certified for use with Amazon Redshift and thatĬhoose the System DSN tab to configure theĭriver for all users on the computer, or the UserĭSN tab to configure the driver for your user accountĬhoose the Amazon Redshift ODBC driver, and then chooseįinish. Only use a driver other than these if you're running a
#Amazon redshift jdbc driver connection drivers
Use the following procedure to download the Amazon Redshift ODBC drivers for Windows See the Amazon Redshift ODBC connector installation and configuration guide. For information about minimum system requirements, Each computer where you install the driver must meet a list of You install the Amazon Redshift ODBC driver on client computers accessing an Amazon Redshiftĭata warehouse. Install and configure the Amazon Redshift PWD= insert_your_admin_user_password_here įor information about how to get your ODBC connection, see Finding your cluster connection If you want to use an ODBC connection, take the following steps. įor installation and configuration information for Amazon Redshift ODBC drivers, see the Amazon Redshift ODBC connector installation and configuration guide. Further updates will not be released, except for urgent security patches.įor the latest information about ODBC driver functionality and prerequisites, see Amazon Redshift ODBC driver release notes.
The 32-bit ODBC drivers are discontinued. However, if your client tool doesn't support JDBC,įollow the steps in this section to configure an ODBC connection.Īmazon Redshift provides 64-bit ODBC drivers for Linux, Windows, and macOS X operating systems. If your client tool supports JDBC, you mightĬhoose to use that type of connection rather than ODBC due to the ease ofĬonfiguration that JDBC provides. Your client computer or Amazon EC2 instance.
Third-party SQL client tools and applications. You can use an ODBC connection to connect to your Amazon Redshift cluster from many
0 kommentar(er)
