Export Sql to Excel

Hello,

We need to geerate an excel starting from a Table on our DB.

I've downloaded and installed the last version of Excell Tools that includes the Smart Service Export Sql to Excel, but for sure I am doing something wrong because it doesent'work.

This is the error message "There is a problem with task “Export SQL to Excel” in the process “nuovaProvaExcel”. The following error was raised by the Export to Excel function: null
Problem: An error occurred in executing an Activity Class.
Recommended Action: Examine the activity class to correct the error and then resume.
Priority of this problem: High Priority "

and this is the configuration of the Smart Service:

JNDI Name: ="java:/jdbc/PirelliOrcaleDS"
Sheet Number: 0
SQL: ="SELECT * FROM V_RM_RO_EUR"

All other field were left blank.

Can anyone suggest a solution?

Thanks

OriginalPostID-230761

  Discussion posts and replies are publicly visible