We also charge a derivative fee based on that, so this is an intricate process to get right. These are all things that determine the cost of the transaction and the fees charged by Visa, Mastercard, Amex and other credit agencies. When merchants batch in their sales at the end of the day, the system qualifies the nature of the transaction by checking things like if the transaction was made online or from a card reader via a chip, magnetic strip, or a rewards card. Part of our value add is to pay our merchant customers ahead of the credit agencies. Horizon takes care of qualification, billing, and settling merchant payments. Payments from merchants came in from a legacy third-party mainframe payment gateway and landed in Horizon as flat files. We had two monolithic legacy apps, Horizon and Compass, running off the same Clearent database. So when we started this effort, we were fully on-premises. So Zach, to put this effort into context, can you help us understand where you were coming from? Their new Compass Online Reporting Suite gives their customers unprecedented and concurrent access to sales transaction data stored on Azure SQL Hyperscale for near real-time views of revenue, sales trends, and much more. In fact, they’ve recently completed an app and data modernization effort using Azure SQL Database Hyperscale. Now key to this has been connecting their back-end payment fulfillment system with their transaction reporting system. And since their inception in 2005, they’ve built several intelligent solutions to reduce credit card processing fees and significantly speed up the fulfillment of credit card payments with next day funding. They process over 500 million transactions per year. So if you’re new to Clearent by Xplor, they’re a US-based payment solution provider that enables merchants and retailers to accept credit card payments from anywhere.
So today, I’m joined by Zach Fransen, who’s the VP of data and AI at Xplor. From their approach with micro-batching to continuously bring in billions of rows of transactional data from their on-premises payment fulfillment system at scale, as well as their optimizations for near real-time query performance using clustered columnstore indexing for data aggregation and much more. – Up next, we meet with credit card processing firm Clearent by Xplor to see how they built a fast, scalable merchant transaction reporting system on Azure SQL Database Hyperscale. Keep getting this insider knowledge, join us on social:
Clearent data guardian series#
We are Microsoft’s official video series for IT. Learn more about Clearent by Xplor and what they’re doing with Hyperscale at įor more guidance on implementing Azure SQL Database Hyperscale, check out In his nightly video address, recorded on a train after a visit to the flood zone, Zelenskiy thanked Ukrainian troops and repeated Kyiv’s earlier claims of military success around the city of Bakhmut.04:53 - Near real-time reporting/micro-batchingġ0:34 - Query speed ups - clustered column store indexingġ1:45 - What’s next for Clearent by Xplor? He said it was becoming a global problem as contaminated flood waters flowed into the Black Sea. “Obviously, the Kakhovka reservoir has been turned into a huge graveyard for millions of living beings.” Volodymyr Zelenskiy visits flooded Kherson as evacuations continue – video “Tens of thousands of birds and at least 20,000 wild animals are at risk of death,” the Ukrainian president said. Volodymyr Zelenskiy held an online meeting with environmental activists from around the world to establish an expert group to rally support to help recover from the ecological disaster caused by the dam’s destruction.
The Russians were just waiting for the right day to blow it up.” Ukraine reported last year that the station was mined.
He added: “They brought hundreds of kilograms of explosives there. The station was blown up from the inside.” “To destroy the plant from the outside, at least three aircraft bombs, each of 500kg, would have had to be dropped on the same spot. “The plant was designed to withstand a nuclear strike,” Syrota told the Guardian in an interview in Kyiv.
0 kommentar(er)
