Not able to retrieve data using JDBC Data source

[anuj09]

Hi All ,

I am trying to connect Snow with Oracle database using Mid Server and data source.

I am able to connect with Database but once i click on Load data in data source it runs and then end with returning no records.

There is no error message i am getting in mid-server and import set logs.

from the firewall perspective all ports are opened for snow IP address.I am not able to understand whats wrong here.

Please advise...

[santy1]

Hi Anuj,

May I know if there is any ALIAS type used in the query??

If yes problem may be with that.

"SQL Aliases do not work with JDBC Data Source imports".

Let me know if you have Alias type.

Regards,

Santhosh Kumar K