Designing and Running Pipelines

MS SQL Bulk Insert

is there a way to perform a bulk insert operation to insert data into MS SQL? currently we have a pipeline that has about 3.5M records / documents. It takes a long time to insert all of these into SQL using the execute snap b/c I believe its performi...

Resolved! Dynamic filename in s3

hi all, I have a pipeline which writes a pdf to s3 bucket but the problem is that the filename has to be dynamic. But i cant get the filename as prior to s3 filewriter I have a document to binary snap. Hence the the variable in which i store the name...

Soap execute with mtom enabled

Scenario :- Trying to perform a SOAP Execute to send attachments as PDF and XML using the MTOM transmission as mentioned in the document below. https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1437963/SOAP+Execute The scenario works correctl...

Best way to derive values in cross reference file

Hi, I have a requirement where I need to derive a value from cross reference file.(* means any value) Ex: Cross reference file data A B C D 1 * 12 2222 2 a 22 1111 3 b * 2323 4 * 13 1315 4 c * 1332 Example Input file- Need...

If One of the document fail to Insert in DB then All document in Batch failed

Hello Experts! My Oracle database account batch size is set to 50 and if error is in single record entire batch is getting error out with error message of first record where as other 49 records are valid records without erroneous data (tried and test...

Resolved! How to get the sequence for a group of values

Like how to get AddressNO group by the same IDs like below?

Deployment Architecture

We are in the process of implementing SnapLogic and I wanted to reach out to the community to find out if you could share some information on how your setup your environment. This is in terms of Project Spaces, Groups, Migrations to QA/Prod, etc. We ...

Anyone got a SOAP Execute against a Workday Tenant Working?

Any help much appreciated in this regard in terms of sample envelopes you can share or validated WSDL, currently using v28.1 which doesn’t validate in XMLSpy although it seems to work with SOAPUI Yours, Adrian

SnapLogic - Integration Nation

Forum Posts

MS SQL Bulk Insert

Resolved! Dynamic filename in s3

Soap execute with mtom enabled

Best way to derive values in cross reference file

If One of the document fail to Insert in DB then All document in Batch failed

Resolved! How to get the sequence for a group of values

Deployment Architecture

Anyone got a SOAP Execute against a Workday Tenant Working?

Send multiple files from file writer snap to http ...

Nest the document under another document

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data