SQLLoader sFTP connection with slash in password work-around

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi All,

I’m working on a new implementation of ISC, and we are attempting to use the SQLLoader connector to aggregate from a CSV file from the authoritative source. Company policy dictates that we setup an sFTP site in Azure Blob storage. When attempting to test this connection using a userid/password, the password that was generated by Azure has two non-consecutive forward-slashes “/” in the password. This appears to be causing ISC throw a connection failure error while displaying the part of the password before the first / in clear text. Is there any way to escape these characters in the password so the value can be passed correctly on the sFTP command, or do I need to get a different password? Keep in mind that Azure is generating these passwords, there is no way for us to dictate what the password contains. Is it possible to use SSH passkeys in place of the password in the SQLLoader connector?

Thanks for any help you can provide.

Mike Frank

2

I would consider opening up a Support ticket for this, as it seems to be more of a bug, than something that would have a work around. I would contact your CSM also to bring this to their attention.

3

I agree, it does seem like a bug, I’ll bring it up with our CSM. In the interest of closing this out, I was able to get the admin to generate a new password without slashes in it, and it’s working fine now.

Thanks!

Mike