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 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. Visit our Support page to get instant support from experienced professionals, fast and detailed responses, user engagement and interaction, frequent builds with bug fixes, and much more.You can use an ODBC connection to connect to your Amazon Redshift cluster from many Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.Įvery operation with Amazon Redshift becomes significantly faster using such capabilities of our driver as Local data caching, connection pooling, query optimization and much more. Our ODBC driver is a standalone installation file that doesn't require the user to deploy and configure any additional software such as a database client or a vendor library. Thus allowing any desktop and web applications to connect to Amazon Redshift from various environments and platforms that support ODBC. In addition, we provide support for Advanced Connection String parameters. The driver provides full support for common ODBC interface: We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any Amazon Redshift and ODBC data types. Moreover, with our driver you can perform bulk updates to Amazon Redshift by combining SQL statements into batches, thus simplifying and speeding up large data modification to Amazon Redshift. SSH protocol is one of the most reliable protocols for data encryption. ![]() You can also connect to Amazon Redshift securely via SSH tunnel. ![]() Work with Amazon Redshift securely using SSL connection options provided in our driver along with the support for SSL protocol. That improves performance of your applications, their quality, reliability and especially the deployment process. Direct Connection gives your applications an unrivalled advantage - connection to Amazon Redshift directly via TCP/IP without any additional libraries or client tools. Direct Connectionĭatabase applications based on our solution get an opportunity to establish a connection to Amazon Redshift directly. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with Amazon Redshift fast, easy and extremely handy.Īvailable in both installer formats, MSI and EXE. Devart ODBC Driver for Amazon Redshift provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Amazon Redshift from Windows, macOS, Linux, both 32-bit and 64-bit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |