BODS is reading partial data when CDC option is enabled at salesforce datastore level

[Former Member]

Hello All,

I am working on a POC where we are supposed to integrate sales force data with MS SQL Server.

Case 1:

We disabled CDC option at datastore level and imported the tabe(in this case we are getting same number of columns from source table) and able to load complete data  into the target table.

Case 2:

Here we are facing problem. We enabled CDC option and imported the table(in this case we are getting three extra columns than the source table i.e DI_SEQUENCE_NUMBER, DI_OPERATION_TYPE and SFDC_TIMESTAMP). In CDC Options tab, for CDC subscription name we are supplying one value. When we execute the job only partial records are reading from salesforce and loading into the target(whatever is reading from source are getting loaded into the target).

Dataflow design: Source Table(salesforce table) --> Query Transformation --> Target Table.

Thanks in advance.

Regards,

Ravi

[Former Member]

CDC will enable to capture change records at the source table , so please un-check Delete / recreate tables options in your target table.