Designing and Running Pipelines

Error when reading from SQLMX database via JDBC connector

I am working on a pipeline to pull data from a SQL Server database and insert into a SQLMX database. I got this pipeline working, but it fails after the first run as it’s trying to insert records that already exist. My thought was to use a pipeline l...

Pipeline execution timeout

I have subpipelines started via the Pipeline Execute snap in a parent that runs continuously (not Ultra) as a listener. There may be long periods of no documents flowing through the parent to the subpipeline. The subpipeline contains a DB snap that h...

Pipeline Execute and Oracle Stored Procedure

Hi! I have a pipeline that has a Pipeline Execute snap(PESnap), which calls in a simple pipeline to load an excel to an Oracle table, and an Oracle Stored Procedure snap, which calls a Stored Procedure to update a table T1 and a few other snaps. Thes...

Hosting a SOAP Service with SnapLogic

A common question we get at SnapLogic is how to host a SOAP Service. One of our Solutions Engineering team solved this with Ultra Pipelines. See attached the PDF for details.Creating Soap Services Using Ultra Pipelines.pdf (718.6 KB)

Resolved! How the database excute works to have the best performance?Tips?

Hi, I am using Oracle/SQL execute snaps a lot to run some complicated queries. Can someone explain to me: In my case, my query would return 100000+ documents/rows, what I found is that during the execution, the oracle/sql execution snap will first o...

Pipeline Scheduling task

Hi, One odd thing I have found when I schedule my task Say it is 2:00pm EST and I want to schedule a weekly task, starting from today @4:00pm EST and repeat every Monday 4:00pm EST. If I create such task, it will not start until next Monday 4:00pm E...

Is it possible to host Soap service in SnapLogic

Hello, I have client requesting Soap service instead of Rest API. Curious, Is it possible to expose Soap service using SnapLogic. Thanks, Prakash

RedShift Bulk upsert execute irrespective of data coming or not after router snap

Hi, I have a parent child pipelines in which I am trying to use multiple Bulk Upsert snaps, as my target tables has different number of columns making unique/primary keys, some tables has only 1 column as PK some has 2 etc. To achieve this I am using...

SnapLogic - Integration Nation

Forum Posts

Error when reading from SQLMX database via JDBC connector

Pipeline execution timeout

Pipeline Execute and Oracle Stored Procedure

Hosting a SOAP Service with SnapLogic

Resolved! How the database excute works to have the best performance?Tips?

Pipeline Scheduling task

Is it possible to host Soap service in SnapLogic

RedShift Bulk upsert execute irrespective of data coming or not after router snap

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

How to dynamically update an account?

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