# About Data Pipelines

Congrify offers a no-code solution for integrating PSP reports directly into your Database setup. This is currently available with Snowflake. 

Customers can access raw PSP data from multiple tables and data sources with no integration effort required. The connection between Congrify's and the customer’s Snowflake databases is fully automated, ensuring synchronization without manual intervention. 

Built on Snowflake’s secure sharing functionality, the connection ensures both data safety and ease of access. This setup simplifies the process of leveraging PSP data for advanced analytics and reporting. Here is how Shares work in Snowflake (https://docs.snowflake.com/en/user-guide/data-sharing-provider)

# Connecting with Snowflake

There is a three-step process to activate data ingestion with Snowflake:

1. **Configure your payment service provider** with Congrify.

2. **Congrify configures the Snowflake connector for the dedicated customer:**
   - **Create a separate database** in Snowflake for the customer.
   - **Set up the schema** based on required Payment Service Providers (PSPs) and available reports.
   - **Create the data share** with selected reports and connectors, ensuring all data is aligned with the customer's needs.

3. **Approve the data share** with Snowflake by both Congrify and the customer.

Once live, the data will synchronize **daily**, ensuring up-to-date reporting. The setup process from Congrify’s side typically takes **less than a day**.

Additionally, having a **Data Processing Agreement (DPA)** in place between Congrify and the customer is required for **compliance and data protection**.


# Available PSPs and Reports

The following PSPs connections are currently available in Data Pipelines and sharing with Snowflake:
- Adyen
- Braintree
- Chase Payment Tech
- Izyco (Pay)
- PayPal
- PaySafeCard
- PayU
- Satispay
- Worldline

## Available PSP Report tables

Here’s a list of all tables categorized by supported PSPs. If you're looking to integrate a different PSP into your Data Pipeline connector, please reach out to Congrify’s team for assistance.

| PSP              | Report                                                           |
|------------------|------------------------------------------------------------------|
| ADYEN            | DISPUTE_REPORT                                                   |
| ADYEN            | EXCHANGE_RATE                                                    |
| ADYEN            | MERCHANT_INVOICE_MONTHLY                                         |
| ADYEN            | PAYMENT_ACCOUNTING_REPORT                                        |
| ADYEN            | RECEIVED_PAYMENTS_REPORT                                         |
| ADYEN            | SETTLEMENT_DETAILS_REPORT                                        |
| ADYEN            | THREEDS_AUTHENTICATION_REPORT                                    |
| BRAINTREE        | DISPUTE_REPORT                                                   |
| BRAINTREE        | SETTLEMENT_SUMMARY_REPORT                                        |
| BRAINTREE        | TRANSACTION_REPORT                                               |
| CHASE_PAYMENTECH | AUTHORIZATION_DETAIL_FINANCIAL_REPORT                            |
| CHASE_PAYMENTECH | CHARGEBACKS_RECEIVED_REPORT                                      |
| CHASE_PAYMENTECH | CHARGEBACK_ACTIVITY_EXCEPTION_REPORT                             |
| CHASE_PAYMENTECH | DEBIT_AUTHORIZATION_AGING_FINANCIAL_REPORT                       |
| CHASE_PAYMENTECH | DEPOSIT_ACTIVITY_SUMMARY_FINANCIAL_REPORT                        |
| CHASE_PAYMENTECH | DEPOSIT_ACTIVITY_TRANSFER_SUMMARY_FINANCIAL_REPORT               |
| CHASE_PAYMENTECH | DEPOSIT_DETAIL_FINANCIAL_REPORT                                  |
| CHASE_PAYMENTECH | DISCOVER_CHARGEBACK_SUMMARY_FINANCIAL_REPORT                     |
| CHASE_PAYMENTECH | ECP_RETURNS_EXCEPTION_REPORT                                     |
| CHASE_PAYMENTECH | EXCEPTION_DETAIL_FINANCIAL_REPORT                                |
| CHASE_PAYMENTECH | FINANCIAL_ACTIVITY_SUMMARY_FINANCIAL_REPORT                      |
| CHASE_PAYMENTECH | FUNDS_TRANSFER_ACTIVITY_FINANCIAL_REPORT                         |
| CHASE_PAYMENTECH | INTERCHANGE_DOWNGRADE_SUMMARY_FINANCIAL_REPORT                   |
| CHASE_PAYMENTECH | INTERCHANGE_QUALIFICATION_DETAIL_FINANCIAL_REPORT                |
| CHASE_PAYMENTECH | INTERCHANGE_QUALIFICATION_SUMMARY_FINANCIAL_REPORT               |
| CHASE_PAYMENTECH | MASTERCARD_EXCESSIVE_CHARGEBACK_FINANCIAL_REPORT                 |
| CHASE_PAYMENTECH | MERCHANT_FX_RATE_FILE_INFORMATIONAL_REPORT                       |
| CHASE_PAYMENTECH | REJECT_SUMMARY_FINANCIAL_REPORT                                  |
| CHASE_PAYMENTECH | RETRIEVAL_DETAIL_EXCEPTION_REPORT                                |
| CHASE_PAYMENTECH | SERVICE_CHARGE_DETAIL_FINANCIAL_REPORT                           |
| CHASE_PAYMENTECH | SUBMISSION_LISTING_FINANCIAL_REPORT                              |
| CHASE_PAYMENTECH | TRANSACTION_SUMMARY_FINANCIAL_REPORT                             |
| CHASE_PAYMENTECH | VISA_FRAUD_ADVICE_REPORT                                         |
| CHASE_PAYMENTECH | VISA_MISUSE_OF_AUTHORIZATION_FEE_DETAIL_FINANCIAL_REPORT          |
| IYZICO           | BALANCE_REPORT                                                   |
| IYZICO           | CUTOFF_REPORT                                                    |
| IYZICO           | DISPUTE_REPORT                                                   |
| IYZICO           | INVOICE_REPORT                                                   |
| IYZICO           | SETTLEMENT_REPORT                                                |
| IYZICO           | TRANSACTION_REPORT                                               |
| PAYPAL           | DISPUTE_DETAIL_REPORT                                            |
| PAYPAL           | SETTLEMENT_REPORT                                                |
| PAYPAL           | TRANSACTION_DETAILS                                              |
| PAYSAFECARD      | SETTLEMENT_REPORT                                                |
| PAYU             | SETTLEMENT_REPORT                                                |
| PAYU             | TRANSACTION_REPORT                                               |
| SATISPAY         | TRANSACTION_REPORT                                               |