Designing and Running Pipelines

For important values storage

I have some important values that I dont want anybody including me can see as plain text and further I can use those values in any snap. So what is the recommendations to store those values?

Resolved! Setting up SFTP connection to download file

I am new to SnapLogic and currently learning how to use SnapLogic. At this moment, I am looking for some guidance how to create a pipeline that logs into a remote FTP server via SFTP and download a file to my share folder. I already created a SSH Acc...

Do we need JDK installed to use JDBC snap?

I have on-prem groundplex. We need to connect mainframe Db2 database. I heard we can do that by using JDBC select snap. In order to use JDBC snaps, do we need JDK installed in our machine?

JDBC connection error - Db2

Trying to set account for connecting to Mainframe DB2 database using JDBC Select snap with the below information. I received below error. Can someone help me to fix this.? Failed to validate account: Failed to retrieve a database connection. Cause: [...

Need to do lookup on multiple tables without using join

I have 30 tables to lookup on 30 respective columns, In case of other ETL tool we had lookup as a function to do it independently in a single transform. In snaplogic, I am not sure how to do it. I can combine all 30 into a single lookup table like So...

Resolved! Replace All Case Insensitive Based on Incoming Value

Hello. I am having some issues getting “replace” to work the way I want; kindly have a look. This works: $Name.replace(/ron/gi, “Ronald”) So does this: $Name.replace($OldName, $NewName) But, I want the above to also work with the “gi” option but it d...

Netsuite - dynamically passing the object name

I saw in Netsuite I can pass the object statically like below reference screenshot marked yellow, is there any way I can dynamically pass the object name like with ‘=’?

SnapLogic - Integration Nation

Forum Posts

For important values storage

Passing Cdata to xml

Resolved! Setting up SFTP connection to download file

Do we need JDK installed to use JDBC snap?

JDBC connection error - Db2

Need to do lookup on multiple tables without using join

Resolved! Replace All Case Insensitive Based on Incoming Value

Netsuite - dynamically passing the object name

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings