question

SanthoshCh-4132 avatar image
0 Votes"
SanthoshCh-4132 asked ·

SSRS with Amazon Redshift as DWH

Dear All,

We are planning to migrate our DWH from SQL Server to Amazon Redshift and analyzing all the options for our existing SSRS Reports.

We would like to know whether SSRS is compatible with Redshift as a DWH and also share your experiences what changes would be required.

Please let me know if you require any other information.

Thank you.

Best Regards,
Santhosh

sql-server-reporting-services
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI @LukasYu-msft ,

Thank you for sharing your inputs..!

We are also looking in terms of suggestions from the folks who has implemented it and knowing from performance, connection issues, what points to be taken into picture etc.

That gives us a better understanding on the plan of migration.

Best Regards,
Santhosh




0 Votes 0 ·

I has been a while have you /your college done the migration ? We'd appreciate your input and your valuable experience ! :)

0 Votes 0 ·

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered ·

Hi,

I did some research in internet, and I believe this should be possible.


Since I don't have Redshift test environment, I could not try the methods myself, but I would suggest you to try two ways :

The first road could be that to try to use Redshift ODBC to be connected to SSRS . You could see : Configuring an ODBC connection


Another way is to try this approach which is accept by previous users as described in this thread : Redshift to SSRS Connectivity issue

You could try these two see if this works for you.

Regards,
Lukas


· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Santhosh,
Thanks for your comment! We could keep this ticket open in case some experts who had Redshift experience could see this! :)

1 Vote 1 ·