Here's a step-by-step guide on how to configure a Generic JDBC Account in SnapLogic to connect to your local PostgreSQL 14.7 Docker instance:
---
🐘 Connecting to Local PostgreSQL via Generic JDBC in SnapLogic
⚠️ Important Pre-requisite: Groundplex Required
Since your PostgreSQL is running locally via Docker, you must use a Groundplex (a locally-installed Snaplex node). A Cloudplex cannot reach your local machine's network. Make sure your Groundplex is running and can reach the Docker container.
---
Step 1: Download the PostgreSQL JDBC Driver JAR
Download the PostgreSQL JDBC driver from the official site:
👉 [https://jdbc.postgresql.org/download/](https://jdbc.postgresql.org/download/)
- Recommended: postgresql-42.7.2.jar (Java 8 compatible)
- Upload this JAR to your SnapLogic Shared folder via the Manager.
---
Step 2: Create a Generic JDBC Account
1. In the Designer, drag any Generic JDBC Snap onto the canvas and open it.
2. Go to the Account tab → click Add Account.
3. Select Generic JDBC Account as the account type.
---
Step 3: Configure the Account Settings
Fill in the following fields:
| Field | Value |
|---|---|
| JDBC Driver JAR | Select the uploaded postgresql-42.7.2.jar |
| JDBC Driver Class | org.postgresql.Driver |
| JDBC URL | jdbc:postgresql://<your-host>:5432/<your-database> |
| Username | Your PostgreSQL username (e.g., postgres) |
| Password | Your PostgreSQL password |
🔧 For the JDBC URL — Docker Considerations:
Depending on how your Docker container is set up, use the appropriate host:
| Scenario | Host to use |
|---|---|
| Groundplex running on the same machine as Docker | localhost or 127.0.0.1 |
| Groundplex running inside Docker on the same network | Use the container name or Docker bridge IP (e.g., 172.17.0.x) |
| Groundplex on a different machine | Use the host machine's IP address |
Example URL:
jdbc:postgresql://localhost:5432/mydb
---
Step 4: (Optional) Add URL Properties
If you encounter connection timeout issues, add these under URL Properties:
| URL Property Name | URL Property Value |
|---|---|
| socketTimeout | 10 |
---
Step 5: Validate the Account
Click Validate to test the connection. If successful, click Apply.
---
🛠️ Common Troubleshooting Tips
- Driver not found: Make sure the JAR is uploaded to SnapLogic's file system and correctly referenced in the account.
- Connection refused: Ensure your Docker container exposes port 5432 (e.g., -p 5432:5432 in your docker run command) and that no firewall is blocking it.
- Multiple JDBC accounts: If you have other JDBC accounts with broken drivers, they can cause all JDBC connections to fail. Fix or remove broken drivers and restart the JCC node.
---
Let me know if you need help with any specific step or run into an error! 🚀
