Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Field is missing in object in SQL, but available when using DataLoader

Hi

Tried to find answer online but none of solutions provided were applicable to my problem here.

I'm pulling data from Salesforce server using DBAmp. Just upgraded to latest version of software hoping that this would be any different, but problem persist.

I'm currently running DMAmp version 3.9.1.0, on Windows Server 2012, Running SQL Server: Microsoft SQL Server 2012 - 11.0.5058.0 (X64).

I can see object Called Location in Salesforce using SysAdmin profile.
User created for connecting to SQL server to this org is in the same profile, with the same permissions.

On the object I can see field caller Location, as per ScreenShot below:

When I'm querying this object using DataLoader (from Salesforce) I can see this field being exported into CSV file without any issues.

But when I try to pull this field from SQL I cannot see this field at all, neither by replicating table down to SQL, or calling directly to linked server.

SQL server is using login I've used to pull this via DataLoader, so permissions are definitely not an issue (as DataLoader is pulling field correctly).

According to Salesforce documentation this datatype is handled differently so I'm guessing that's where the problem is.

I can access fields derived from this one (Longitude and Latitude), but not this field directly and this is causing issues currently.

Can someone help with this one?

//EDIT: link to salesforce info about datatype:
https://help.salesforce.com/articleVi...
1 person has
this problem
+1
Reply