6 ms·

Hi, I'm the author. Yeah, you have a good point. Imperative programming was just the way that we were using SQL to build that system.

by a_liang 10y ago

davidcaseria 10y ago
Do you plan on using Scala and Akka Persistence in the future for the entirely event-based system? http://doc.akka.io/docs/akka/current/scala/persistence.html http://doc.akka.io/docs/akka/current/scala/persistence.html. We have been using it at the finance company I work for to maintain customer's ledgers.
- a_liang 10y ago
  It's definitely something to consider, depends on our project roadmap.
rboyd 10y ago
Thanks for the writeup! I was on the payments team at Groupon and have fond memories of the same challenges.
deleted 10y ago
[deleted]
bigger_cheese 10y ago
Did you consider an off the shelf ERP product? I've written something similar to the first part - extract raw data out of various source DB's using SQL queries then push it to our organisation's ERP product (SAP) using A2A messaging. From my view SAP is black box but it handles the actual accounting/ financial logic part i.e Ledgers, product tracking, inventory management etc. Our Accountants all seem pretty comfortable using it.
- a_liang 10y ago
  Airbnb's data models weren't initially designed to be financially reported on, and by the time we needed better financial reporting, it was too late to change those models. 90% of the work was about rethinking the way to think about all of this, what financial impact should be booked, and how it could be derived from the data. None of the ERP solutions fit our use case, and I think it would have been very difficult to integrate. We still use a general ledger to book the outputs of our new financial pipeline, but I don't think we have a traditional business model (no traditional inventory management). That's more in the finance and accounting department though, and I can't speak much to that.
- andrioni 10y ago
  I don't know the volume of transactions they have, but in my past experience with SAP it was extremely hard and expensive to implement and make it scale (1~2 years for the initial implementation and migration and 10M+ USD spent), and we weren't even that big (~3M sales orders per year). Debugging it was also a nightmare, and they still had frequent data integrity issues, even just between SAP modules.

Hi, I'm the author. Yeah, you have a good point. Imperative programming was just the way that we were using SQL to build that system.

by a_liang 10y ago

Hi, I'm the author. Yeah, you have a good point. Imperative programming was just the way that we were using SQL to build that system.

davidcaseria 10y ago

Do you plan on using Scala and Akka Persistence in the future for the entirely event-based system? http://doc.akka.io/docs/akka/current/scala/persistence.html http://doc.akka.io/docs/akka/current/scala/persistence.html. We have been using it at the finance company I work for to maintain customer's ledgers.

a_liang 10y ago
It's definitely something to consider, depends on our project roadmap.

rboyd 10y ago

Thanks for the writeup! I was on the payments team at Groupon and have fond memories of the same challenges.

deleted 10y ago

[deleted]

bigger_cheese 10y ago

Did you consider an off the shelf ERP product? I've written something similar to the first part - extract raw data out of various source DB's using SQL queries then push it to our organisation's ERP product (SAP) using A2A messaging. From my view SAP is black box but it handles the actual accounting/ financial logic part i.e Ledgers, product tracking, inventory management etc. Our Accountants all seem pretty comfortable using it.

a_liang 10y ago
Airbnb's data models weren't initially designed to be financially reported on, and by the time we needed better financial reporting, it was too late to change those models. 90% of the work was about rethinking the way to think about all of this, what financial impact should be booked, and how it could be derived from the data. None of the ERP solutions fit our use case, and I think it would have been very difficult to integrate. We still use a general ledger to book the outputs of our new financial pipeline, but I don't think we have a traditional business model (no traditional inventory management). That's more in the finance and accounting department though, and I can't speak much to that.
andrioni 10y ago
I don't know the volume of transactions they have, but in my past experience with SAP it was extremely hard and expensive to implement and make it scale (1~2 years for the initial implementation and migration and 10M+ USD spent), and we weren't even that big (~3M sales orders per year). Debugging it was also a nightmare, and they still had frequent data integrity issues, even just between SAP modules.