ContributionsMost RecentMost LikesSolutionsUtility Pattern - Dynamic DB Account and SQL Query Construction Dynamic DB Account and SQL Query Construction.slp (16.6 KB) Author @ssanikop SAP BW Pattern Contributed by @rdharnikota Configuration Snaps used: JSON Generator, Mapper Downloads READ BW DSO Dynamic Parser.slp (16.8 KB) SAP IDOC Patterns IDoc Listener To Router In Memory Micro Service.slp (10.4 KB) IDoc Listener To Router In Memory Micro Service - Ultra.slp (16.1 KB) IDoc STATUS to ECC For Each Micro Service.slp (8.4 KB) Creating a ServiceNow Incident from a JIRA Issue Contributed by @rdharnikota This pipeline gets the details of a specified JIRA issue and creates an incident in ServiceNow. Configuration The first Mapper maps the JIRA issue ID and the issue comments to the ServiceNow incident. Other fields are also manually set in the Mapper. Either update the values or map the fields that you need to carry over. Sources: JIRA issue Targets: ServiceNow incident Snaps used: JIRA Get, Mapper, Router, ServiceNow Insert, ServiceNow Update Downloads Create SNOW Incident from JIRA.slp (8.8 KB) Utility Patterns - Date Manipulations using JavaScript Date Manipulation Using Java Script.slp (6.4 KB) Author @ssanikop Canonical Patterns Canonical (JSON) to Vertica.slp (9.0 KB) Canonical (XML) to SFTP.slp (12.7 KB) Canonical (XML) to Vertica.slp (13.3 KB) Author @vish Redshift Patterns Simple -Oracle to Redshift.slp (4.3 KB) Join Oracle-SFDC to Redshift Bulk.slp (8.0 KB) Tableau Ingest from Salesforce Created by @vish This pipeline uses SOQL to gather information from a Salesforce account and sends it to Tableau Configuration Sources: Salesforce Account Targets: Tableau Snaps used: Salesforce SOQL, Tail, Salesforce Lookup, Structure, Conditional, Sequence, Mapper, Tableau REST Downloads Salesforce to Tableau.slp (14.1 KB) Anaplan Ingest Patterns WD to Anaplan.slp (14.7 KB) SAP to Anaplan.slp (20.9 KB) Salesforce to Anaplan.slp (17.3 KB) Author @vish Architecture: Multi-Geo Deployment Author @pkona Adjust to a non-AWS infrastructure