Hi all,

I have 300 ssrs reports and need to integrate with netezza code

In detail:

I need to replace sql code to neteezza code for 300 reports.Instead of doing manually.

Is any automated tool avaiable to integrate neteeza code with ssrs reports.?

Thanks in advance  

The answer to your question depends on what Database you are using right now. Since change of queries/procedures will be related to the DB that you use rather than SSRS, which will just display the result set for you.

From what I know, Netezza has got some version of PL-SQL, so you will need to change everything and make it work in PL-SQL.

Hi karthi,

Thank you for your question.

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

Thank you for your understanding and support.

Best regards,
Qiuyun Yu

Hi karthi,

If you just want to replace the sql code to neteezza code, maybe you can consider using reporting service web service to deal with them in batch.
https://msdn.microsoft.com/en-us/library/reportservice2010.datasetdefinition.query(v=sql.110).aspx
However as Saket pointed please make sure the SQL used by the neteezza  is  compatible with T-SQL.