I am trying to fetch the data from SOQL Database using sales force connector server Package.
When I tried to define column metadata I can see data in dataset but when I use RCP without defining columns Job is getting successful but in dataset all values are coming as blank.
Anyone knows the reason and solution for the same.
Just to bump up the thread..we are facing the exact issue as OP only difference is Datastage Version 11.3 and IBM yet to fix the issue, we plan to go with another PMR from our end...
Accept that some days you're the pigeon and some days you're the statue.
You did catch the fact that the "bug" they are going to fix is removing the RCP button/checkbox as it is not valid with SF, yes? Not making it work somehow. Just double-checking. Or perhaps you can check to see if perhaps it should / will be supported now...
-craig
"You can never have too many knives" -- Logan Nine Fingers
Right... Not supported means it's not an issue. You would need to open a request for enhancement (RFE) saying that you need the feature added for some reason.
Choose a job you love, and you will never have to work a day in your life. - Confucius