Designing and Running Pipelines

Single pipeline to call multiple pipelines

Hi, I need to design a scheduled task, such that each pipeline executes one after other. Either i can visit each pipe line and schedule them individually.(Currently doing this) Is there any other way where i can design a single pipeline where it call...

Convert Base64 to HEX

I am working on a Snaplogic pipeline to copy data from Oracle to Snowflake. A few tables at source have BLOB column which needs to be copied. Snaplogic sees them as “Base64 encoded data” but Snowflake needs the data in HEX format. I would like to kno...

How to make a generic pipeline Oracle => SQL Server

Hello, I would like to build a generic pipeline to load data from an Oracle DB to a SQL Server DB. I have more than 100 queries to load, so I would like to be able to call the pipeline with the Select (from Oracle) and the destination table as parame...

How to expose pipeline with basic authentication

Hi, How to expose pipeline with basic authentication, (not with Bearer token, need to use id and password). Thanks

Create table with datatypes from source but ONLY selected columns

I noticed the functionality to create a second output on SELECT from database and connect that to the second input on INSERT so that the destination table can be automatically created with the correct data types. Unfortunately I only want to select a...

File Writer - Append to Excel

Hoping someone can help. I have a pipeline that executes a SQL, uses a file writer to put the result set in an excel (call it excel #1) and then emails Excel #1 as an attachment. All works good. WHAT I NEED TO DO: have another excel file (call it...

JSON Payload issues

I’ve come across an issue where the REST post works using a JSON generator, but when we receive the JSON from the pipeline and post it, the call fails. The JSON payload is exactly the same between the JSON generator and what we receive, yet we cannot...

Accessing temp table Snaplogic creates in Snowflake?

Is it possible to access the temp table Snaplogic creates in Snowflake? Need to do some deletes and the delete snap takes a lot of time and resources. I would like to delete using a join to the temp table instead of individual transactions if possib...

SnapLogic - Integration Nation

Forum Posts

Single pipeline to call multiple pipelines

Convert Base64 to HEX

How to make a generic pipeline Oracle => SQL Server

How to expose pipeline with basic authentication

Create table with datatypes from source but ONLY selected columns

File Writer - Append to Excel

JSON Payload issues

Accessing temp table Snaplogic creates in Snowflake?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...