clarrivey
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Sftp fingerprint
We have experienced this problem before, but, unfortunately, I don’t remember how we resolved it. I am trying to sftp a file and I am getting the following error: Error Fingerprint[0] = efp:java.io.GjmU0h9N How do I go about establishing an sftp so that I can create the fingerprint when I do not have direct access to the SnapLogic servers???3.4KViews0likes2CommentsRe: Using union in Execute SQL snap
Hi Kory, Thanks, the union all worked. As for the design perspective, I am not sure I understand how to do that. Given the example I supplied, would I break that into 2 separate SQL Execute statements with the first being select ‘Last_Name’||chr(09)||‘First_name’ alias_name from sys.dual and the second being select rtrim(spriden_last_name) from spriden||chr(09)||select rtrim(spriden_first_name) from spriden and the just having the second one as input into the CSV Formatter and using the alias_name and clicking the show header box? If that is not what you meant, could you please further elaborate? Thanks, Chris2.8KViews0likes0CommentsUsing union in Execute SQL snap
I have an Execute SQL where I wan to add column names to my output file before adding the data. For example: select ‘Last_Name’||chr(09)||‘First_Name’ from sys.dual union select rtrim(spriden_last_name) from spriden||chr(09)||select rtrim(spriden_first_name) from spriden If I do this, I get an output of: Alastname Afirstname Blastname Bfirstname . . . Last_Name First_Name . . . Zlastname Zfirstname when in fact, what I want is Last_Name First_Name Alastname Afirstname Blastname Bfirstname . . . Zlastname Zfirstname Anyone have a clue as to how to get this???3.8KViews0likes5CommentsWriting files to on-premise servers
I am trying to write a file that gets created in a pipeline to one of our on-premise servers (i.e. sftp://ourschool:22/directory/filename.txt) and am getting the following error message: Unable to create filesystem object for sftp://ourschool:22/directory/filename.txt, Reason: Failed to get SFTP session connected Has anyone had any luck with this. I am trying to login with Basic Auth (username and password).4.1KViews0likes5Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
