pavan
Former Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
MySQL to Snowflake
Created by @pavan Moving relational data (order) in MySQL to Snowflake data warehouse, and later can run analytics on how many orders were fulfilled. Configuration Sources: MySQL Order Targets: Snowflake Snaps used: MySQL, Mapper, Snowflake Bulk Load Downloads MySQL to Snowflake.slp (5.8 KB)2.5KViews0likes0CommentsMove data from a relational database into Teradata
Created by @pavan This pattern pipeline migrates data from a relational database, like MySQL, to Teradata. Configuration Note: Sample database and table names are used within the Snaps to give you an idea on expected values. Replace them with your system information. Sources: MySQL table Targets: Teradata Snaps used: MySQL Select, TPT Load, Teradata Execute Downloads 4.8_TPT FLoad.slp (5.3 KB)2KViews0likes0CommentsEncrypt and decrypt sensitive data in a source
Created by @pavan This pipeline pattern will encrypt fields passed as JSON docs using a defined transform type (AES), and decrypts and gives back the original message. This pattern is useful for encrypting sensitive messages (credit card info, SSN, patients name, DOB etc). Configuration Within the JSON Generator, replace “Enter certificate here” with your own certificate. Sources: JSON Targets: JSON Snaps used: JSON Generator, Encrypt Field, Mapper, Decrypt Field Downloads Encrypt & Decrypt Fields.slp (9.1 KB)8.1KViews0likes6CommentsCreate opportunities in Microsoft Dynamics CRM and create invoice in Workday if sale occurs
Created by @pavan This pipeline pattern is used to automate the opportunity to sale process. By using this pipeline, opportunities or orders are created in Microsoft Dynamics CRM and then automatically triggers the creation of an invoice in Workday if a sales occurs. Configuration Sources: Microsoft Dynamics CRM Invoice Targets: Workday Revenue Management Snaps used: Mapper, Microsoft Dynamics CRM Create, Microsoft Dynamics CRM Read, Workday Write Downloads 4.9_MS Dynamic CRM to Workday.slp (8.4 KB)3.2KViews0likes0Comments