We are trying to get the salesforce.com adapter to work in a similar fashion as the data loader tool in SAP BODS.
We need to load/update data into salesforce every 15 mints on a daily basis from the OLTP system.
Each Salesforces table has ID, Name, CreatedBYID columns thats generated by salesforce.
We tried to insert row by leaving the columns , but no data gets inserted.
We tried to put null, we get an error.
What values do we give to map the columns?
Is there a way to feed data into salesforce without making web services calls or pull all data from SDFC into staging and then feed the adapter with inserts.
I think you already posted this question earlier, can you provide the complete version of DS ?
what is the error you are getting ? why do you think it’s happening because of the mapping that you are doing for these columns ?
if the field cannot be created in that case what ever value you set DS Adapter will not pass that field value to SFDC, are these the only columns in you table ? are you passing the correct values to the SFDC for rest of the columns ?
enable the trace for the SFDC Adapter and check the log for details of data that DS is sending to Adapter, the adapter log will be in %LINK_DIR%\adatpers\log folder