We have a home-grown Oracle ERP system and an Oracle Data Warehouse, and now are migrating to Salesforce (and Big Objects).
I am posting this in Oracle community hoping to find someone with an Oracle perspective and maybe knows Salesforce a bit.
My main questions / comments are:
- Big Objects has a limitation of 100 tables, this seems to be terribly limiting (and does not compute to an Oracle person)
- plus we don't have Big Data, we have little data
- For an ERP with little data, why couldn't a 2nd Salesforce database (org) be set up as the Data Warehouse?
- All other DW solutions are for Big Data: Azure, AWS, Google Cloud Dataflow, etc.
- if we learned the new ERP in regular SF, we'd just start writing reports out of that (and likely use Einstein Analytics to do so).
- So the data would flow from Salesforce ERP to Big Objects to Einstein
- And I'm like, "why not just report out of regular SF?" - we don't have Big Data.
Currently, Oracle ERP flows to an Oracle DW, which is roughly similar to the ERP, just a few changes, it's slightly de-normalized, etc. But if there are 100,000 student records in the ERP, there's 100,000 in the DW, so basically the same.
We use traditional tools to report from the Oracle DW, such as PL/SQL Developer, Business Objects, etc. No dashboards, just list-based reporting, some crosstabs, etc.
The general plan is to use Einstein as the reporting tool, so the data would move from Big Objects to Einstein, meaning we really won't use Big Objects to report from, it's just a place to house Big Data.