Excel Casts a Wider Net for Data in August Update
Updated connectors for SAP HANA and Access enable users to incorporate more information into their business analyses.Microsoft has tweaked some of its Excel connectors, allowing users to gather more data for their business intelligence and analytics efforts with fewer steps. This month's update includes an improved connector for SAP HANA, allowing users to select more than one value for a variable or parameter in the Navigator window. HANA, the in-memory analytics platform from German software maker SAP, has gathered its share of big-name supporters in recent months. Dell, in partnership with SAP, recently announced that it plans in April to open up an innovation lab intended to help businesses pit their business analytics workloads—30 terabytes—against the technology. "The lab environment for SAP HANA offers our customers the ability to test their current and future SAP applications and benchmark their performance to facilitate rapid adoption within their organization," remarked Simon Spence, global director of the Dell SAP division at Dell Services, in an Aug. 2 announcement. In May, during SAP's Sapphire Now conference, Microsoft pledged to make more room on its cloud for HANA workloads. Among the new HANA on Azure options are multimode deployments with up to 32TB of memory and a high-performance virtual machine option with 448GB of memory, 32 cores and over 6.5TB of SSD-based storage.
Meanwhile, the Access Database connector for Excel features a new Select Related Tables button that, as its name suggests, selects all the tables with a direct relation to selected tables when clicked. And the OData connector gains a new way of gathering data.