Snowflake Integration
IXOPAY Payments Intelligence 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 IXOPAY Payments Intelligence'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:
- Configure your payment service provider with IXOPAY Payments Intelligence.
- IXOPAY Payments Intelligence 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.
- Approve the data share with Snowflake by both IXOPAY Payments Intelligence and the customer.
Once live, the data will synchronize daily, ensuring up-to-date reporting. The setup process from IXOPAY Payments Intelligence’s side typically takes less than a day.
Additionally, having a Data Processing Agreement (DPA) in place between IXOPAY Payments Intelligence 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
- iyzico (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 IXOPAY Payments Intelligence’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 |