Our first example is a query of our Opportunity table in SFDC.

NOTE: Enter your own valid SFDC info (for the Salesforce.com TableName, UserName, and Password) to query your SFDC objects.

select ‘From SALESFORCE >>>>>> ‘ as row_source, Id, AccountId, StageName, Amount, CloseDate, OwnerId, CreatedDate

from SFDC(SOQL=‘select Id, AccountId, StageName, Amount, CloseDate, OwnerId, CreatedDate from Opportunity where CreatedDate >= 2014-01-08T22:38:04Z and StageName = ”Closed Won”’,

UserName=‘username‘,

Password=‘password‘,

Environment=‘Production’);