Many data sources, like public APIs, are simple to set up without requiring any IT work. However, for your production databases, like Postgres or MongoDB, it’s advised to not keep your database connections publicly available. Password-protecting your databases is a good start for protecting you against unauthorized access, but we recommend you also block connections from unrecognized sources on the network level using a firewall or AWS security groups.

  • To allow Panoply to access your data through your network or firewall, see IP Whitelisting.
  • To allow Panoply to access your data through your AWS Relational Database Services (RDS) PostgreSQL database, see AWS Security Groups.

IP Whitelisting

All of Panoply’s data sources always use the same range of IP addresses to access your database. In order to still allow Panoply to access your database, you can whitelist the following range of IP addresses in your firewall/network configuration:

  • -, or in CIDR notation use:
  •, or in CIDR notation use:

AWS Security Groups

To allow Panoply to access your database instance in AWS:

  1. Create a Security Group with an Inbound rule.
  2. Specify your database type.
  3. Set the protocol type to TCP.
  4. Set the port to the appropriate port number for your connection.
  5. Set the Custom range to the CIDR value for Panoply:

To learn more about AWS Security Groups, see Amazon EC2 security groups for Linux instances.

For PostgreSQL, the configuration would look like this:

Getting started is easy! Get all your data in one place in minutes.
Try Free