Connect to local database to test Snaplogic pipelines

[dkifle]

This example uses MySQL installed on developer’s laptop

1. Install MySql DB on you local machine
2. Login to you ISP’s router
3. Enable port forwarding fro the specific port - (the default for MySQL is 3306)
4. Login to Snaplogic
5. 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.
6. 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.