Patterns

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

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

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

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

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

Sopra HR to Cornerstone - Worker Sync

Created by Jocelyn Arcega, SnapLogic. Master Data synchronization of workers between Sopra HR and Cornerstone. Configuration Sopra HR authorization is non standard, in the body of the messageCornerstone authorization is OAuth2 client_credentials S...

Sopra HR to Cornerstone - Job Sync

Created by Jocelyn Arcega, SnapLogic. Master Data synchronization of jobs from Sopra HR to Cornerstone. Configuration Sopra HR authorization is non standard, in the body of the messageCornerstone authorization is OAuth2 client_credentials Sources:...

Sopra HR to Cornerstone - Org-Unit Sync

Created by Jocelyn Arcega, SnapLogic. This pattern is a a Master Data synchronization pipeline between 2 HR applications: Sopra HR and Cornerstone. It uses REST Snaps for integrating with both. Configuration Authorization with Sopra HR is non stand...

SnapLogic - Integration Nation

Forum Posts