My perspective is traditional RDBMS (Oracle), and retrieving data with a reporting tool like Business Objects or straight SQL Nothing too fancy, just dump to Excel. But JOINing a lotta tables.
We're migrating to SF but our analytics team still needs to pull all manner of data. Right now using SOQL using Workbench - this is painful imo.
Einstein doesn't seem like the right tool for us. It's set up for fancy dashboards and such, but that's not what we need to do.
SOQL is extremely limited imo. For example, I have two healthy queries that each "join" to several other tables. But I want to JOIN my two healthy tables, in the same manner one could JOIN to VIEWS fom Oracle. But I don't think SOQL allows that.
Plus, I don't think standard Salesforce reporting is going to work, although I haven't tried it out. But it just not seem like the way to do all of our reporting (data pulls).
For example, SOQL doesn't have logical LEFT JOINs, as I understand it. Say I have student(contacts), applications, and sports recruiting. In Oracle, I would start with STUDENTS, then LEFT JOIN to both applications and sports recruiting.
But in SOQL, it looks to me like you START with the "leaf" (sports recruiting), then work you way to the branch (applications) and THEN to the "root" (STUDENTS).
- so you wouldn't be able to count the number students with no applications nor the number of students with no sports recruiting.
So is my only architecture option is to suck the data out of SF into a traditional RDBMS and then JOIN everything (normally)?
Hope this makes sense.