You are not logged in.
I am having a rather perplexing issue with a Salesforce extract that I am hoping someone can help me with. I am attempting to extract the Contact table in my SF account to an amazon RDS database (MySQL 5) for use with BIRTonDemand. The talend extract reports the correct number of rows in the table (3546) however the resulting table in MySQL has only 3446. I extracted the data from SF using the apex data loader and compared it to the MySQL data and the missing rows are all consecutive (based on the date created in SF) between 11/13/09 and 10/27/10. There are 146 rows in the contacts table that were created after that that extract fine.
I am not getting any key violations or any errors during the job that would suggest there was some problem with the table.
So I'm stumped. Does anyone have any ideas?
Last edited by BRM (2011-10-12 00:18:43)
you could try a tMySQLCommit linked with a on sub job ok from the load. Depends on whether the table is innodb.
The other thing to do is link a tLogRow to the mysql output on a reject link. That will show if there are any rejects.
Last edited by janhess (2011-10-12 17:50:49)