Designing and Running Pipelines

RDBMS - BLOB Data Type

The post below was designed for the BLOB data type in SQL Server (2014) but similar concepts should work for other data sources as well. Setup: in SQL Server Mgmt Studio CREATE TABLE [BLOBS]( [Id] [int] IDENTITY(1,1) NOT NULL, [Data] var...

How to trigger a pipeline based on incoming email

Anyone can come up with a creative way to initiate a pipeline based on an receiving an email? I would set some rules in the email account to auto route it to a sub-folder. We could have a schedule task to read the email folder but I would rather hav...

Expression library for condensing Reltio REST API response

Before 2017 Winter Release, transforming a Reltio REST API response JSON object into a simple structure can be a tedious task. The expression library feature from 2017 Winter Release can make it much easier. Encouraged by @dmiller, am sharing a pipe...

How to monitor a JCC

If you want to monitor a JCC, please follow the following instructions: Prerequisite: jmxremote_optional-repackaged-3.1.1.jar (If you compile jcc locally, you will have this library at ~/.m2/repository/org/glassfish/external/jmxremote_optional-repac...

Best way to filter out zip file __MACOSX folder entries

I have a zip file I need SnapLogic to source that was created on a Mac using Apple’s compress utility. To read the zip file, I used a ZipFile Reader snap which had no problem reading the zip file. Next I connected a XML parser snap to the ZipFile Rea...

How to disable Cache in Groundplex

To disable the cache option for downloading Snaps. Please add the below property in node properties. jcc.jvm_options = -DDISABLE_SNAP_CACHE_DELETE=True To Add this Property, please go to Manager → Shared Project → Snaplex → Click on the Snaplex name...

Groundplex or feedmaster appears in red in Dashboard

I have started my Groundplex jcc or feedmaster successfully, but it appears in red in Dashboard.

Upgrading Groundplex

I have upgraded both Groundplex1 and Groundplex2 to mrc xxx patch in Manager tab. However, in the dashboard health, it shows only Groundplex1 is upgraded, Groundplex2 remains at the old version. What could be wrong and how can we quickly fix this? We...

SnapLogic - Integration Nation

Forum Posts

RDBMS - BLOB Data Type

How to trigger a pipeline based on incoming email

Expression library for condensing Reltio REST API response

How to monitor a JCC

Best way to filter out zip file __MACOSX folder entries

How to disable Cache in Groundplex

Groundplex or feedmaster appears in red in Dashboard

Upgrading Groundplex

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...