cancel
Showing results for 
Search instead for 
Did you mean: 
jrasmussen1
Community Member

Querying Hosted Data Management with SQL Server

Hi All,

I'm currently trying to set up an environment to query the Canvas Data hosted in Redshift via the credentials provided. Our reporting specialist is currently using SQL Server, and specifically SSRS, to generate reports. Does anybody have any experience with connecting to the Redshift instance in Hosted Data Management via SSMS and/or SSRS? If so, how did you go about getting that connection working?

Best,

Jonathan Rasmussen

Software Developer I

College of Southern Idaho

jrasmussen@csi.edu

208-732-6846

1 Reply
oxana
Explorer II

Does your SSMS and/or SSRS support ODBC as a data source? You can connect to Redshift via ODBC.