More information, see Configuring connections in Amazon Redshift.Įnter the port number that the database uses. 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 Use the following procedure to download the Amazon Redshift ODBC drivers for Windows See 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 The following is an example ODBC URL: Driver= If you have a firewall, ensure that this port The port number that you specified when you The password for the user account to connect to Permission, not an Amazon Redshift permission, although you can use theĪdmin user account that you set up when you launched the The endpoint of the Amazon Redshift cluster. The name of the 32-bit ODBC driver: Amazon Redshift (x86). The name of the 64-bit ODBC driver to use: If you want to use an ODBC connection, take the following steps. įor installation and configuration information for Amazon Redshift ODBC drivers, see 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Īmazon 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)
