At their core, PSD2 (Payment Services Directive) and PSD3 redefine how payments work in Europe. They challenge financial institutions, PSPs, and TPPs to think bigger: to create systems that are secure, transparent, and innovative while protecting consumers and enabling competition. Here’s the big picture:
The answer: CrateDB. A distributed SQL database that scales effortlessly, analyzes data in real time, and handles both structured and semi-structured data like a pro. It’s built to meet the demands of PSD2 and PSD3. Let’s break it down.
The future of payments is secure by design. CrateDB makes it happen with real-time processing and fraud detection.
Example: Storing SCA Events in CrateDB
Every login attempt, device detail, and geolocation needs to be stored securely and queried instantly. With CrateDB:
CrateDB can process millions of these events per second, enabling real-time fraud analysis.
Learn More: CrateDB Real-Time Performance
Matching IBANs with account names is crucial to prevent fraud. CrateDB handles large-scale joins across datasets.
Example: IBAN Verification Query
This query executes instantly—even on billions of records—thanks to CrateDB’s distributed SQL engine.
Learn More: CrateDB for Fraud Detection
APIs are the bridge between banks and TPPs. CrateDB ensures secure, fast, and reliable data exchange.
Example: Real-Time Consent Management
CrateDB stores and updates customer consent data in real time, empowering PSPs to provide transparency through a dashboard.
Learn More: CrateDB API Use Cases
Sharing data across PSPs is a cornerstone of PSD3. CrateDB’s distributed architecture ensures data is always available and replicated securely.
Example: JSON Data for Open Banking APIs
CrateDB supports semi-structured JSON, making it perfect for storing and querying TPP-related data.
Learn More: CrateDB and JSON
Give consumers what they deserve: clear, detailed transaction data. CrateDB enables real-time storage and querying for transparency.
Example: Storing ATM Charges
Dynamic dashboards built with CrateDB + Kibana help display this information to consumers instantly.
Transactions don’t just happen—they tell a story. CrateDB’s time-series capabilities help you analyze every detail.
Example: Monitoring Transactions in Real Time
And with tools like Grafana, CrateDB powers dashboards that display anomalies instantly.
Learn More: CrateDB Time-Series Analytics
Compliance isn’t optional—it’s a necessity. CrateDB logs every action and event for full traceability.
Example: Audit Log
CrateDB ensures these logs are immutable, meeting strict compliance requirements.
Learn More: CrateDB and Log Analysis