#1 2020-09-30 05:34:24

abhinav
Member
Registered: 2020-09-30
Posts: 6

Connection with Redshift

version using RS3.3.0-6030-2020-09-25-11-16-41-reportserver-ce


Unable to connect the report server with my redshift data source please help me in doing this.

Thanks in Advance

Offline

#2 2020-09-30 07:41:21

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Connection with Redshift

Hi abhinav,

did you take a look here: https://reportserver.net/en/guides/admi … tasources/ ?
4.2. Amazon Redshift

If this is not working, what exactly is not working? what error do you get?

Regards,
Eduardo

Offline

#3 2020-10-12 05:45:09

abhinav
Member
Registered: 2020-09-30
Posts: 6

Re: Connection with Redshift

While connecting to the amazon redshift I got the issue as the driver is missing, installed the driver that error is resolved, now when I'm trying to add JDBC URL and password in the data source section and click on test connection it is showing connection failed. The major issue is not showing the reason for failure.

Offline

#4 2020-10-12 07:42:09

abhinav
Member
Registered: 2020-09-30
Posts: 6

Re: Connection with Redshift

It gets connected but unable to import data from that connection, what we have to next

Offline

#5 2020-10-12 08:13:58

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Connection with Redshift

abhinav wrote:

click on test connection it is showing connection failed. The major issue is not showing the reason for failure.

Hi abhinav,

did you click on "save" before clicking on "test connection" ?

Regards,
Eduardo

Offline

#6 2020-10-12 08:15:04

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Connection with Redshift

abhinav wrote:

It gets connected but unable to import data from that connection, what we have to next

Hi abhinav,

what exactly do you mean by "import data from a connection" ?

Can you create a simple dynamic list using this connection? If you get an error: what error do you get? (pls check the Tomcat logs)

Regards,
Eduardo

Offline

#7 2020-10-12 09:05:15

abhinav
Member
Registered: 2020-09-30
Posts: 6

Re: Connection with Redshift

I  created a connection successfully but while importing data it is showing No data found for import.

Offline

#8 2020-10-12 09:11:38

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Connection with Redshift

Hi abhinav,

the "import" button is not for importing datasource data, but for importing ReportServer objects: https://reportserver.net/en/guides/admi … nd-Export/

Pls. create a dynamic list and test this: https://reportserver.net/en/guides/admi … amic-List/

Regards,
Eduardo

Offline

#9 2020-10-13 06:53:22

abhinav
Member
Registered: 2020-09-30
Posts: 6

Re: Connection with Redshift

Hi Eduardo,

Does that mean I need to create a Dynamic list for each table?

Offline

#10 2020-10-13 07:47:00

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Connection with Redshift

Hi abhinav,

no, it depends what you need to achieve. Dynamic lists are based on a query, so if you only write "select * from mytable", this will be based on a table. But of course you can write much more complex queries.

You may want to take a look at the documentation here: https://reportserver.net/en/guides/admin/main/ , https://reportserver.net/en/guides/user/main/  especially dynamic lists here: https://reportserver.net/en/guides/user … mic-Lists/

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB