5 ms·
Why would you use ERP instead of a regular SQL database? edit Got a lot of vote downs. This was a genuine question from someone completely ignorant on what ERP
by crimsonalucard 6y ago
Why would you use ERP instead of a regular SQL database?
edit Got a lot of vote downs. This was a genuine question from someone completely ignorant on what ERP is. Not trying to say that SQL is better, but I'm asking this because I'm ignorant of what ERP is and the description makes it appear as if it's a database.
What's the difference? would be better wording I guess.
- _bxg1 6y agoBecause it's your business logic. And your GUI builder. And your tax system. And your legal report generator. Etc.
- hnick 6y agoYes I've heard that often businesses mould themselves to the software, rather than the other way around. The argument is that decades of exposure means that, if not entirely optimal, it at least represents competent processes for running a very large and complicated business. Rolling your own multinational tax compliance in SQL would be madness.
- cutler 6y agoTry getting your average office worker to deal with an SQL database directly. No chance unless it only has a single table. A database without an interface tailored for a specific purpose is useless for office staff. I know this from experience having once tried to get office staff using pgAdmin to update the shiny new database I had designed for them.
- _bxg1 6y agoWhat's funny is that this is what SQL was originally designed for. That's why it reads so much like English. Of course, CLIs were too.
- thelibrarian 6y agoWhy would you use an ecommerce platform instead of a regular SQL database?
- beckingz 6y agoWhen you're doing eCommerce.
- thelibrarian 6y agoMy point exactly.
- crimsonalucard 6y agoSo basically ERP is an app not far off from your standard domain specific web app that sits on top of a database. Why was this not mentioned before?
- youdonthavekids 6y agoWasn't mentioned before because nobody owes you an education and you've managed to massively oversimplify with your definition. If you really want to boil it down to basics. It's a database, an application layer (usually Java) and a front end. It usually covers thousands upon thousands of business processes and is used by most large companies to manage the core of their business processes. The global economy would grind to a halt tomorrow if SAP or Oracle were to disapear.
- crimsonalucard 6y ago>Wasn't mentioned before because nobody owes you an education and you've managed to massively oversimplify with your definition. Stop talking. Nobody gives a fucking shit about anything you have to say.
- njharman 6y agoBecause the ERP solution comes with a gaggle of sales people, sales eng, and bizdev folks to convince your co's decision makers that it is best thing since butter. SQL doesn't.
- youdonthavekids 6y ago"SQL doesn't"... you are correct, SQL can't figure out how much tax you need to pay across 9 tax jurisdictions. SQL can't tell me the best way for my warehouse picking robots to move across the floor based on the layout of the warehouse and what others products are being picked right this second plus over the next few minutes. The list is really endless of what SAP will do and SQL won't. It would take decades to replicate what SAP does.
- SamuelAdams 6y agoI mean I guess you can throw all that functionality in a bunch of triggers but that would slow down your database to a crawl every time one record updated.
- NDizzle 6y agoHave the triggers publish to service broker!
- youdonthavekids 6y agoBrain dead response.
- crimsonalucard 6y agoshut the hell up.
- youdonthavekids 6y agoTO rebuild SAP's manufacturing and finance capabilities into your own system would take many many years and cost large sums of money, you are then stuck supporting a custom solution forever and you'll be forever behind your competitors, your industry trends and whatever new tax or other legislation that needs adding to you system. This isn't nodejs and MySQL mate.
- astine 6y agoI don't know about SAP in particular, but ERP solutions frequently use SQL on the backend. I work with Microsoft Dynamics and it's just a SQL database with a special front-end for constructing workflows. I suspect Oracle ERP would be similar and have Oracle on the backend as well.