Access Canopy data through direct database connection

Data Direct


After Canopy’s computation engine has run, the resulting output data can be accessed in a number of different ways.

DataDirect is the recommended method for analytical consumption of your data, meaning it is best suited for reports and business decisions as opposed to using the data for operational business processes. It is a read-only PostgreSQL database connection that allows you to query your data in bulk in near real-time.


Who would benefit the most from DataDirect?

  • Data analysts and engineers
  • Credit risk and Business Intelligence teams

DataDirect vs API Requests

DataDirect was designed to solve a few key points over the API approach:

Our APIs and CanopyOS are best suited for operational purposes.DataDirect was built with analytical and reporting purposes in mind.
E.g. when you need to know real-time information about your customer, account, individual charge/loan/payment etc.E.g. when you need to analyze and aggregate information across your portfolio.

DataDirect solves the problem of having to make multiple API calls and having to store the data off somewhere in order to query it.

Common Use Cases

Loan Tapes

Loan Tapes: Export a snapshot of your customer base and loans

Export a snapshot of your customer base and loans. By connecting DataDirect to your data warehouse, automate reports to your capital provider. Relevant data from Canopy include all customers, associated products, outstanding balances and deadlines etc.

Loan Portfolio Dashboards

Data direct: overview portfolio performance at a glance

Overview your portfolio performance at a glance. By connecting DataDirect to your BI solution, see a high-level summary of your loan portfolio. This could include the total number of active loans, the total loan amount outstanding, and any important performance indicators such as delinquency rates or default rates.

Ad-hoc SQL Queries

Data Direct: Discover new insights

Discover new business insights. By accessing DataDirect with your database app of choice (e.g. Postico), execute any SQL query to uncover new patterns in your data. The data can help you answer questions such as:

  1. Which customers are paying in full each month?
  2. What strategies produce the highest repayment rates?
  3. Where is my highest cost of servicing coming from?

Data Refresh Frequency

Currently, we refresh DataDirect with your most up-to-date data every hour.

Timing of those are recorded in a separate table, which you can query at any time.

More information is in First steps in DataDirect

What Data Is Included?

The data structure used for DataDirect closely mimics the data structure surfaced from the API.


Rule of thumb

If you can find a field in our API docs, you can find that column in DataDirect

Here is a non-exhaustive list of what data you can access through our database connection:

  • Customers
  • Accounts
  • Line Items
  • Statements
  • Amortization Schedules
  • Cards and Card Transaction Entities

See the the First steps in DataDirect for more specifics on what tables and fields are included.

How does it fit within Canopy's Platform?

For clarity, here are a few additional methods that Canopy provides for accessing your output data, their individual use cases and read/write rights:

DataDirectAPI CallsWeb HooksCanopyOSBorrower Portal
Bulk consumption of your data.Real time access to SOR.Notifications of data state change.Web interface (UI) access to SOR.White-labeled web interface (UI) for your borrowers.
Ideal for reporting and data analytics.Ideal for operational consumption.Ideal for creating event based triggers.Ideal for non-technical users internallyIdeal for driving borrower self-service (repayments, balance checking)
Read-onlyRead and WriteRead-onlyRead and WriteRead and Write

What’s Next