Designing and Running Pipelines

Inserting timestamp string to DB2 database table

Hello, I am having trouble with writing to a db2 database table using the jdbc generic insert, or being more specific writing a timestamp format string to a timestamp column. I have to read from a csv fle and insert the rows into a db2 database tabl...

How to Have the File Reader Read the Newest File

I am building a pipeline that reads from an sftp directory and has a new file posted daily. I can access a file if I hard-code the name, but what is the syntax to get it to pick up the newest file posted each day? Each new file has a unique code numb...

Scaling groundplexes - what does the topology look like

Hi, I’m looking for documentation that explains the options around scaling groundplexes horizontally by adding more nodes to a groundplex for a setup that processes snaplogic ultra tasks. Right now, we have a single feedmaster node and a single groun...

Enriching data in a pipeline

Hi folks, Suppose I wanted to enrich data, can you please tell me an approach you would use? For example: If my pipeline starts out with an input document containing information about a person (name, age, telephone, address, etc.), then suppose the a...

File Writing at multiple source

I have a need here where I want to write a file at multiple source however I could not find multi file writer ? is there a way I can do that ? any tips ?

Snap to execute a Windows Command/Service

Hi everyone, I am working with a system on which I need to drop some data files into a Windows Server, and once the copy is done, I need to run a Batch command file / or run a Windows Service. Is there a way with Snap Logic, to inquire a Windows comm...

How to replace NULL value in Mapper

I have a file reader in my mapping. One of the column in the file contains NULL value. I am connection a mapper after the file reader. Is there any way to replace the NULL value with number? Tried using replace/replaceALL function but didn’t get the ...

How to obtain Unique records based on a column value not based on entire row values

Hi, I have a requirement where I need to obtain unique records based on a column.Unique snap doesn’t work here,as it looks on each unique record instead of a column for ex: My data looks like this e_no email country fi...

SnapLogic - Integration Nation

Forum Posts

Inserting timestamp string to DB2 database table

How to Have the File Reader Read the Newest File

Scaling groundplexes - what does the topology look like

Enriching data in a pipeline

File Writing at multiple source

Snap to execute a Windows Command/Service

How to replace NULL value in Mapper

How to obtain Unique records based on a column value not based on entire row values

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...