#Redshift in sqlpro how to
#Redshift in sqlpro install

Select the DSN name which you have created and click on OK.Ī prompt asking for credentials will pop-up. If the client computer can connect to the Amazon Redshift database, you will see the following message:Įxtracting the data from the Amazon Redshift Database for Power BI Desktop.įrom the Power BI Desktop console. Type the password that corresponds to the database user account. Type the user name for the database user account that you want to use to access the database. Type the name of the Amazon Redshift database. By default, Amazon Redshift uses 5439, but you should use the port that the cluster was configured to use when it was launched. Type the port number that the database uses. You can find this information in the Amazon Redshift console on the cluster’s details page. Specify the endpoint for your Amazon Redshift cluster. You can use any name that you want to identify the data source later when you create the connection to the cluster. Tab if you want to configure the driver for all users on the computer, or the User DSN tab if you want to configure the driver for your user account only. , and then type your administrator credentials if you are prompted to do so. If you installed both drivers, you'll have a folder for each driver. If you installed the 64-bit driver, the folder is named Amazon Redshift ODBC Driver (64-bit). If you installed the 32-bit driver, the folder is named Amazon Redshift ODBC Driver (64-bit).

Menu, in your list of programs, locate the driver folder or folders.

#Redshift in sqlpro install

Note: If you have installed Power BI(64-bit) make sure to install the Amazon Redshift ODBC Driver (64-bit) and for Power BI (32-bit) install Amazon Redshift ODBC Driver (64-bit).

SQL client tools use this data source to connect to the Amazon Redshift database.

#Redshift in sqlpro how to

Over this blog, I would like to address on how to install the Amazon Redshift Driver on Windows Operating System and how to configure the Data Source Name(DSN) to be used with Power BI.Ĭreating a System DSN Entry for an ODBC Connection on Microsoft Windows.Īfter you download and install the ODBC driver, you need to add a data source name (DSN) entry to the client machine.