pkoppishetty
Former Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
Get check object data from NetSuite and move data into Redshift
Created by @pkoppishetty This pipeline pattern is designed to get the check object data from NetSuite and move the data into Redshift data warehouse. Configuration Sources: NetSuite check Targets: Redshift table Snaps used: Mapper, NetSuite Search, JSON Splitter, Redshift Bulk Load Downloads Integration Pattern from NetSuite to Redshift.slp (8.8 KB)2.4KViews0likes0CommentsIntegration pattern from Oracle to Salesforce
Created by @pkoppishetty This pipeline pattern updates data in Salesforce whenever a new record is pushed into Oracle RDBMS. In this example, for each new record that is added into the Oracle table “employee_details”, a new object record is created in Salesforce. Configuration Sources: Oracle employee_details table Targets: Salesforce account Snaps used: Oracle Select, Salesforce Read, Join, Mapper, Salesforce Create Downloads Integration pattern from Oracle to Salesforce.slp (14.9 KB)2.4KViews0likes0CommentsPattern to ingest data from Google Storage into Google BigQuery using AVRO file format
Created by @pkoppishetty This pipeline is designed for transferring data from a local machine to Google Storage, and then loading data into Google BigQuery using a data source as Google Storage. Configuration Make sure- Upload type is:- “Upload existing files from Google Cloud Storage” and file paths:- “file format”:“AVRO”, “file path”:“gs://gcs_cloud_1/data/leads.avro” Sources: Local machine, Google Storage Targets: Google BigQuery Snaps used: File Reader, File Writer, Google BigQuery Bulk Load (Cloud Storage) Downloads Pattern to ingest data from Google Storage into Google BigQuery using AVRO file format.slp (5.6 KB)3.3KViews0likes0CommentsMove data from AWS S3 to Snowflake Data Warehouse
Created by @pkoppishetty The pipeline pattern moves data from AWS S3 to Snowflake Data Warehouse. The pattern contains a Directory Browser (to retrieve the file list from S3), Snowflake Execute, and Snowflake Bulkload Snaps (to load the corresponding files into Snowflake). Configuration File Reader Preview Snowflake Bulkload Output Table Data from Snowflake Select Snap Sources: AWS S3 Targets: Snowflake Snaps used: Snowflake Execute, Directory Broswer, File Reader, Snowflake Bulk Load, Snowflake Select Downloads Integration pattern for moving data from AWS S3 to Snowflake datawarehouse.slp (14.2 KB)4.6KViews0likes1Comment