dkifle
Former Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
Look up addresses from multiple databases
Created by @dkifle This pipeline pattern is used to read records of student information and lookup and compile the address of each student based on whether or not the student is a domestic or international student. Configuration Sources: CSV data, Oracle, SQL Server (CSV Generator can be replaced by any student information system.) Targets: Oracle and Redshift tables Snaps used: CSV Generator, Router, Oracle and SQL Server Lookup, Mapper, Union, Copy, Oracle Merge, Redshift Insert Downloads Look Up Student Address.slp (19.0 KB)2.1KViews0likes0CommentsConnect to local database to test Snaplogic pipelines
This example uses MySQL installed on developer’s laptop Install MySql DB on you local machine Login to you ISP’s router Enable port forwarding fro the specific port - (the default for MySQL is 3306) Login to Snaplogic Create a MySQL account and Fill in the account properties. for hostname, type in you local machine’s IP address (Google what’s my IP) . Choose the default port number 3306 for MySQL or the same port number you specified on step 3. Click Validate. If the accounts validates, they you can proceed and create you pipeline. If not make sure the port forwarding is enabled and the local MySQL DB is started.3KViews0likes0Comments