In this step, SQL Server database administrators and database developers can see how they can easily define and create Linked Server to Amazon Redshift databases for a connection Redshift cluster nodes. If you see "Successfully connected to the data source!" success message, then we can launch SQL Server Management Studio and define Linked Server to Amazon Redshift database as shown in following step.Ĭreate SQL Server Linked Server to Connect to Amazon Redshift Database In authentication area, since I use databases username and password for connection, I typed the user name and password of the database user.Īfter all configuration in DSN setup for the Amazon Redshift ODBC Driver is completed, press Test button. In "Database" textbox, enter the name of the target database that you want to connect to in the cluster. Port is by default 5439 for Amazon Redshift connection. If the Amazon Redshift endpoint is public available and if you don't have a firewall policy preventing you to the Redshift database, you can use the public IP or DNS name in server textbox too. Then type the private IP address of your Amazon Redshift cluster in "Server" input area. Switch to System DSN tab and press on add button to create a new ODBC data source.įrom the available lists of drivers, choose Amazon Redshift driver for database connection to Redshift cluster lead node.ĭefine a name for your Amazon Redshift ODBC data source in "Data Source Name" textbox. Launch ODBC Data Source Management application with Run as Administrator option. When the setup is completed, you can define the ODBC connection to Amazon Redshift Cluster as in following stepĬreate ODBC Data Source for Amazon Redshift Database The setup wizard will lead you through the installation. msi setup file for the Redshift database ODBC driver exists, and run the setup by executing the AmazonRedshiftODBC64-1.msi file. You can launch Command Prompt with Run as Administrator option and navigate to the folder where the. msi installation file download is completed, execute the setup with an administrator account. Later when the Amazon Redshift ODBC driver. I download 64-bit ODBC driver for Amazon Redshift database. Open a web browser and navigate to the AWS official documentation for ODBC driver downloads. In this tutorial, I will show how Amazon Redshift ODBC drivers can be used to connect Redshift database from SQL Server instances using Linked Servers. In a previous AWS tutorial I have shown download JDBC driver for Amazon Redshift and connect from SQL Workbench tool. To connect to Amazon Redshift database, developers can use ODBC drivers as well as JDBC drivers. Download and Install ODBC Drivers for Amazon Redshift
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |