Read data from a file in SnapLogic Database, transform the data in Workday and load data into SQL Server

Created by @sreddi

This pipeline pattern extracts data from the SnapLogic Database file, transforms the data in Workday and loads the data into a target, such as a SQL Server.


File Reader Snap

Filter Snap

Mapper Snap

SQL Bulk Load Snap

Sources: JSON file in the SnapLogic Database
Targets: Workday Read to Staffing, SQL Server Bulk Load to Create New Table
Snaps used: File Reader, JSON Parser, Filter, Mapper, Workday Read, SQL Server Bulk Load


Workday_PM.slp (13.0 KB)