How to use DCM with the new Salesforce Input tool?

Question

The previous tool had a username/password/token authentication but it now has DCM. However, I have no idea how to set this up, if I try to set up a Salesforce connection in the DCM window then it takes me to Windows OBDC connections where I have no idea what I am supposed to choose - all the options I've tried ask for a server address but I've never needed this previously so I don't know what I am supposed to use here.

afellows · Answer

I did manage to make it work but it took a lot of messing around and cannot see what I did now to get it working I'm afraid. Unfortunately, there is still a bug in the tool which I reported 6 months ago and was told was fixed in this version so I cannot use it and  I have gone back to v2023 of designer and the previous (non-DCM) version of the SF tool.

basubb · Answer

Has this worked for you? Every time I select "Save security token", the OK button gets disabled. Also, not sure how the ODBC would connect to my company's specific Salesforce instance which is actually <companyname>.lightning.force.com

Thanks

Basu

afellows · Answer

Thanks @NeoInfiniTech, I completely missed that in the previously linked instructions.

So I have it working with the input tool but the Salesforce Input tool doesn't seem to see the DCM connection I have just made. If I set up another one through the tool everything seems ok and I can select a table to query but it fails when trying to run it with an error code 400. Guess I'll reach out to support.

Are people just using the Input Data tool rather than the Salesforce Input tool?