Designing and Running Pipelines

Useful Third Party Utilities

None of these tools are “official” or truly supported. If it breaks, you get to keep the pieces. Disclaimer aside: I need help writing JSON Path Expressions First, re-evaluate why you are writing a JSON Path Expression. Try using a mapper, or severa...

Connect to local database to test Snaplogic pipelines

This example uses MySQL installed on developer’s laptop Install MySql DB on you local machineLogin to you ISP’s routerEnable port forwarding fro the specific port - (the default for MySQL is 3306)Login to SnaplogicCreate a MySQL account and Fill in ...

Aggregation of IDs for IN clause in a Delete DB Snap

When a Database Delete (Example: SQL Server Delete) snap is used, the snap goes through each of the entries in the incoming document and makes one roundtrip to the database to delete the pertinent record. Whilst it could be argued that this is not th...

Restaurants bill software

This is an experiment pipeline to generate the Restaurant’s bill according to the ordered items vs menu. Here’s the image of the pipeline and attached is the pipeline. Restaurants bill software_2017_02_18.slp (16.7 KB)

Configuring SnapLogic Hive Account for Hive on HortonWorks HDP (No Kerberos)

Below are steps to configure the Hive Account in SnapLogic to connect to a Hive Database on HortonWorks Step 1: Go to Product Downloads | Cloudera and download the HortonWorks JDBC Driver for Apache Hive Step 2: If Kerberos is not enabled on HortonWo...

Ultra Pipeline blogs

Please click on the links below to learn about the Ultra Pipeline Tasks (Blog posts) Designing Ultra Pipelines Designing Ultra Pipelines: Types of Views Designing Ultra Pipelines: Error and Exception Handling Ultra Pipelines: Performance, Management ...

Rolling back a Snap Pack version

SnapLogic has quarterly Platform and Snap releases. If any of your pipelines stop working due to a new version of a Snap Pack right after a major release, please follow the steps below: Submit a SnapLogic Support ticket.Go to elastic.snaplogic.com Go...

What to do if a Groundplex node is unable to register to the control plane

CHECKPOINT : Is there a proxy between the groundplex node and the Control Plane? Outbound connectivity to the Control Plane can be tested using the following curl command: On Linux JCCs, $ curl -v https://elastic.snaplogic.com:443 On Windows JCCs, ...

SnapLogic - Integration Nation

Forum Posts

Useful Third Party Utilities

Connect to local database to test Snaplogic pipelines

Aggregation of IDs for IN clause in a Delete DB Snap

Restaurants bill software

Configuring SnapLogic Hive Account for Hive on HortonWorks HDP (No Kerberos)

Ultra Pipeline blogs

Rolling back a Snap Pack version

What to do if a Groundplex node is unable to register to the control plane

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...

groupby field and count

IF Statement in Expressions Library file

Create Expression Library from Excel data

Can't paginate using Post HTTP CLIENT Snap

How to formulate expresssion

Creating unique ID's and repeating