Patterns
Pipeline patterns help you get a head start on pipeline building.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Dynamic Data Pivot

Created by @dwhite An example of how to perform a dynamic pivot on data that needs to be pivoted. The traditional Pivot Snap is static and has to be configured per set of data (Ex. in pipeline). This pipeline shows how one can perform a pivot operat...

dwhite by Employee
  • 1804 Views
  • 1 replies
  • 2 kudos

Data Orchestration Process with Asynchronous Response

Created by @dwhite A sample pattern one could use to trigger a large data orchestration process with several steps (synchronous and parallel) that has an asynchronous response at the start so the calling process will not wait. Response contains a Sn...

dwhite by Employee
  • 1411 Views
  • 0 replies
  • 0 kudos

Active Directory get User Data Endpoint

Created by @dwhite Enter a base DN and an AD username to use LDAP search to find a specific user. Run as a trigger task endpoint or as a child pipeline. Configuration Enter the base dn to look for users in via the “baseDn” parameter. Enter the AD ...

dwhite by Employee
  • 1443 Views
  • 0 replies
  • 1 kudos

RabbitMQ Consumer to MySQL

Created by Chris Ward, SnapLogic This pipeline consumes messages from a RabbitMQ queue and writes them to a MySQL Database and acknowledges or rejects the message dependent on the delivery. It could be used for a use case where theres need to stream...

dmiller by Admin
  • 2047 Views
  • 0 replies
  • 0 kudos

Pipeline Directory Generator

Created by Chris Ward, SnapLogic This pipeline generates a Google Sheet containing key information relating to all Pipelines within a customers org. This allows customers to maintain both a consolidated & up to date view of all Pipelines within a sp...

dmiller by Admin
  • 1237 Views
  • 0 replies
  • 0 kudos

Pardot Prospect Import

Created by Chris Ward, SnapLogic This pattern provides the ability to integrate with Pardot’s async batch APIs allowing customers to import Prospects into their Pardot instance. Sources: SQL Server. Can be changed to another source by swapping out t...

dmiller by Admin
  • 934 Views
  • 0 replies
  • 0 kudos

Oracle to Redshift - Dynamic Metadata

Created by Chris Ward, SnapLogic This Pipeline replicates table data obtained from an Oracle database and upserts the data into Redshift. Firstly, the Parent Pipeline reads the Source and Target schema & tables and a where clause used to filter the ...

dmiller by Admin
  • 1448 Views
  • 0 replies
  • 0 kudos

Azure SQL to Salesforce Upsert

Created by Chris Ward, SnapLogic This pattern connects to an Azure SQL database to perform a query data and then Upserts the results to an object in Salesforce. Both error and successful records are written to a log file within SLDB. The pattern cou...

dmiller by Admin
  • 1067 Views
  • 0 replies
  • 0 kudos
SnapLogic Trust Site
Visit Trust.SnapLogic.com for real-time visibility into system performance and availability.
SnapLogic Documentation
Visit our documentation for detailed information on functionality and features.
  • New site
  • Original documentation site
  • Top Kudoed Authors