DataDirect

Access Canopy data through direct database connection

Data Direct

Introduction

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:

APIDataDirect
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?

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

Checking data freshness

DataDirect data is typically refreshed every hour. To identify the time of the last refresh and the state it represents, you can check for the most recent related record in the refresh_history:

select 
  table_name,
  last_updated_at 
from data_direct.refresh_history;

Whatโ€™s Next

We recommend reading the following: