One Extra Enterprise Information Warehouse And Analytics Choice

Posted by

Expensive Salesforce, haven’t I been , goal, affordable, useful business analyst? Why would you make my life harder?Business Magazine

For years, shoppers have been reaching out with the next query: If a good portion of all my enterprise information comes from SAP or Oracle enterprise functions (ERP, CRM, and so forth.), ought to SAP BW/4HANA or Oracle Fusion Analytics Warehouse act as (A) one of many sources for an enterprise information warehouse [EDW] or (B) my ONLY enterprise information warehouse?

There’s no easy reply to that query. Selecting Choice A requires a fine-grained understanding of SAP/Oracle information schemas and metadata with a view to extract and rework information. Fairly a little bit of metadata is buried in utility layer logic, nonetheless, so merely querying DBMS tables doesn’t work. And extraction of the info is only the start of a deadly journey — subsequent comes information transformation and integration. Good luck integrating and reconciling information coming from SAP, Oracle, Salesforce, and different enterprise enterprise apps. That’s as a lot artwork as it’s science … and largely the realm of consultants. Oh, and did I overlook to say that information warehouses seldom assist operational reporting effectively? Shoppers have a tendency to return to the ERP/CRM reporting for his or her reporting.

Choice B isn’t any much less perilous. Every ERP/CRM platform has its personal distinctive strategy to dealing with hierarchies, delta updates, entity relationships, and so forth. Attempting to ingest and combine exterior information into these proprietary constructions, processes, and logic is like making an attempt to place a sq. peg right into a spherical gap — one other windfall for the consultants.

Each time I get a consumer inquiry on these matters, I sigh as a result of I do know there’s no straightforward reply. Now comes Salesforce Genie – the Salesforce EDW. Salesforce Genie is an EDW and analytics platform that:

  • Relies on Tableau’s Hyper DBMS operating on Salesforce infrastructure (storage and compute).
  • Permits the mixing of Salesforce and exterior information (through new Genie native and MuleSoft connectors and integration capabilities).
  • Has Tableau appearing because the analytics and information visualization entrance finish.
  • Natively helps publishing analytics/information visualizations to Salesforce’s Lightning UX (that is particularly vital since we predict that almost all information/analytics must be consumed in techniques of labor quite than in analytical functions).

Thanks, Salesforce. I anticipate tons of consumer inquiries on this matter for which, alas, I’ll not have clear solutions. Don’t misunderstand me — that is nice information for shoppers who’ve been asking us for years ship enterprise analytics inside the Salesforce UX. There weren’t nice choices past tons and plenty of coding and integration work. Now there’s: Salesforce Genie. However enterprise shoppers could have yet one more information structure dilemma: whether or not to start out utilizing Salesforce Genie throughout the enterprise quite than simply Salesforce analytics.

Have extra questions? I reluctantly ? provide a possibility to schedule an inquiry with me.