Salesforce ODBC - null-able columns marked as not null?
Your ODBC driver reports some columns as not null-able and then sends rows containing null values for them:
- Calendar.Name
- DuplicateRule.Language
- EntityDefinition.LastModifiedById
- FeedComment.HasEntityLinks
- FlowDefinitionView.LastModifiedDate
- Folder.Name
- ForecastingUserPreference.ForecastingDisplayedTypeId
- Group.Name
- ListView.CreatedById
I'm trying to execute queries like those to copy the complete current state into a local table without having to manually create a mirroring structure on my local database:
- SELECT * INTO [FeedComment] FROM OPENQUERY(SF_PRODUCTION,'SELECT * FROM [FeedComment]');
Which then depending on the data in the connected Salesforce Org fail for the mentioned tables with Error #7342 Severity 16:
> An unexpected NULL value was returned for column
"[MSDASQL].HasEntityLinks" from OLE DB provider "MSDASQL" for linked
server "SF_PRODUCTION". This column cannot be NULL.
Could you please mark those columns as null-able in your ODBC driver?