About Download Amazon Redshift
Amazon Redshift supports Amazon ODBC Redshift drivers on Windows and Linux systems. You must install the Amazon ODBC Redshift 64-bit driver based on your system requirement.Note: Informatica certifies Amazon Redshift ODBC driver version, AmazonRedshiftODBC-64-bit-1.4.8.1000-1.x86_64, to use for SQL ELT optimization.Configuring Amazon Redshift ODBC connection on WindowsBefore you establish an ODBC connection to connect to Amazon Redshift on Windows, you must configure the ODBC connection.Perform the following steps to configure an ODBC connection on Windows:1Download the Amazon Redshift ODBC drivers from the AWS website. You must download the Amazon Redshift ODBC 64-bit driver.2Install the Amazon Redshift ODBC drivers on the machine where the Secure Agent is installed. 3Open the folder in which ODBC data source file is installed. 4Run the odbcad32.exe file.The ODBC Data Source Administrator dialog box appears.5Click System DSN.The System DSN tab appears. The following image shows the System DSN tab on the ODBC Data Source Administrator dialog box:6Click Configure.The Amazon Redshift ODBC Driver DSN Setup dialog box displays. The following image shows the Amazon Redshift ODBC Driver DSN Setup dialog box where you can configure the Connection Settings and Credentials section:7Specify the following connection properties in the Connection Settings section:PropertyDescriptionData Source NameName of the data source.ServerLocation of the Amazon Redshift server.PortPort number of the Amazon Redshift server.DatabaseName of the Amazon Redshift database.Note: You must specify the Server, Port, and Database values from the JDBC URL.8Specify the following credentials in the Credentials section:PropertyDescriptionUserUser name to access the Amazon Redshift database.PasswordPassword for the Amazon Redshift database.Encrypt Password ForEncrypts the password for the following users:- Current User Only- All Users of This MachineDefault is Current User Only.9Click Test to test the connection in the Amazon Redshift ODBC Driver DSN Setup box.10Click OK.The Amazon Redshift ODBC connection is configured successfully on Windows.After you configure the Amazon Redshift ODBC connection, you must create an ODBC connection to connect to Amazon Redshift.For more information about how to create an ODBC connection to connect to Amazon Redshift, see Creating an ODBC connectionConfiguring Amazon Redshift ODBC connection on LinuxBefore you establish an ODBC connection to connect to Amazon Redshift on Linux, you must configure the ODBC connection.Perform the following steps to configure an ODBC connection on Linux:1Download the Amazon Redshift ODBC drivers from the AWS website. You must download the Amazon Redshift ODBC 64-bit driver.2 Install the Amazon Redshift ODBC drivers on the machine where the Secure Agent is installed. 3Configure the odbc.ini file properties in
Key features of the Download Amazon Redshift that are enabled through these drivers include:
- Introduction to Amazon Redshift - Amazon Redshift
- Connecting to Amazon Redshift - Amazon Redshift
- Notebooks in Amazon Redshift - Amazon Redshift
- Performance data in Amazon Redshift - Amazon Redshift
- Behavior changes in Amazon Redshift - Amazon Redshift
- What is Amazon Redshift Serverless? - Amazon Redshift
- What is Amazon Redshift? - Amazon Redshift - docs.aws.amazon.com
Create Amazon Redshift ConnectionsToad Data Point allows you to create a connection to an Amazon Redshift database using ODBC connectivity.Note: You must have Amazon Redshift ODBC driver 1.3.1.1000 (or later) installed before a native connection is created.To install the Amazon Redshift ODBC Driver Download and install the ODBC Driver from the Amazon Redshift Web site.To create a new connectionClick on the Connections toolbar (ALT+F+N). Select Amazon Redshift from the Group list box. In the Create New Connection window configure the connection parameters.General Tab Description Driver nameUncheck the Use data source name checkbox and select Amazon Redshift (x64) Driver or Amazon Redshift ODBC Driver (x64) depending on the installed version.UserEnter the username for your Amazon Redshift account.PasswordEnter the password for your Amazon Redshift account.DatabaseEnter the name of the Database you would like to connect to or choose from the drop-down list.ConnectionStringAdd the connection string for the Redshift cluster in the ConnectionString field.Add the password string to the PWD= setting in the ODBC URL and paste the ODBC URL to the ConnectionString field:Driver={Amazon Redshift ODBC Driver (x64)};Server=<server>;Database=<database>;UID=<user>;PWD=<password>;Port=5439Click Connect to save the connection and immediately connect to the database or click Save to save the connection without connecting to the database. Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About. Understand Toad Connections Switching Connections in Toad Troubleshoot SQL Server® Issues Create ODBC ConnectionsToad Data Point allows you to create a connection to a database that supports an ODBC
