I am facing same issue when I am trying to connect to Oracle Eloqua using ODI. I am able to successfully test the connection through Datadirect Cloud though. I am using right now the trial version of Datadirect Cloud Services. I don't see Advance tab on my data Sources???
@amrish I think you posted in a heroku thread by mistake and I asked the forum mod to move this to DataDirect cloud. For ODI, are you following a specific tutorial? Are you looking for in advanced tab in DataDirect Cloud or ODI?
We do have a lot of experience with this and look forward to your reply.
Check out my world famous blog on data connectivity