Skip to main content
This guide walks you through connecting your first external data source to Cano Analytics. Whether you’re linking a PostgreSQL database, a cloud warehouse like BigQuery, or a SaaS tool like Stripe, the process follows the same straightforward steps — you’ll be running cross-source queries in minutes.

​
Connect Your Data Source

1

Open Data Sources settings

In the Cano Analytics app, navigate to Settings → Data Sources from the left sidebar.
2

Add a new source

Click the + Add Data Source button in the top-right corner of the Data Sources page.
3

Select your source type

Browse or search the integration list and click the source you want to connect — for example, PostgreSQL, Snowflake, or Stripe.
4

Enter connection credentials

Fill in the credentials required for your source type:
  • Databases & Warehouses — provide the host, port, database name, username, password, and SSL mode.
  • SaaS Integrations — authenticate via OAuth (you’ll be redirected to the provider’s login) or paste in an API key, depending on the integration.
See the example form values for PostgreSQL below.
5

Test the connection

Click Test Connection. Cano attempts to reach your source using the credentials you entered and reports back whether the connection succeeded. If the test fails, double-check your credentials and make sure Cano’s egress IPs are allowlisted in your firewall (see the note below).
6

Save the source

Once the connection test passes, click Save to add the source to your workspace.
7

Configure your sync schedule

After saving, you’re prompted to set a refresh schedule — choose how often Cano should sync data from this source. See Configuring Data Refresh and Sync Schedules for the full list of options.

​
PostgreSQL Connection Example

The form below shows a typical set of values when connecting a PostgreSQL database:
PostgreSQL Connection Form
Create a dedicated read-only database user for Cano Analytics. This limits the permissions Cano needs and makes it easy to audit or revoke access later.

​
IP Allowlisting

If your database or warehouse sits behind a firewall, you need to allowlist Cano Analytics’ static egress IPs so that connection tests and scheduled syncs can reach your host.The full, up-to-date list of egress IPs for your region is available at Settings → Data Sources → Egress IPs inside the Cano Analytics app. You can also contact [email protected] to request the current IP list for your region.

​
Credential Security

All connection credentials you enter — including passwords and API keys — are encrypted at rest using AES-256 encryption. Credentials are never logged or exposed in the Cano interface after the initial save. You can rotate them at any time from Settings → Data Sources → Edit Source.

​
Next Steps

Once your source is connected, explore what you can do with it: