Recently we upgraded our repositories to BODS 4.2 SP5 in our DEV environment. It did not allow me to create a target object to Salesforce. Looks like something changed in 4.2 Salesforce Adapter.
There is no Create New Instance(Target) option. This datastore was checked out with filtering option from our upgraded central repository to our local repository. As we are yet to upgrade our production local repository we have not upgraded the local repository. I will try to create a new SFDC Adapter datastore.