Microsoft Expands its Power BI Gateway with SAP HANA Integration to Enhance Data Analytics
FREMONT, CA: With an aim of adding new capabilities for data analytics, Microsoft Power BI Gateway now supports SAP HANA platform and SQL Analysis services, reports Pedro Hernandez for eWEEK.
Microsoft Power BI Personal Gateway is a Business Intelligence tool that helps collect and organize business data. It provides quick transfer between Power BI service and on premise data sources enabling IT administrators to assert control over their user’s data exploration and visualization activities. The gateways provide end user connectivity to on premises data sources allowing cloud powered business intelligence and data visualization platform to generate charts, graphs and reports.
Power BI Gateway Enterprise administrators can include SAP HANA as a DirectQuery data source that uses data stored in SQL Server database. Providing access to updated data, DirectQuery mode eliminates the need to maintain a number of copies of data for analytics. Once the SAP HANA data source is set up, enterprises can create and edit Power BI reports using the latest information provided by SAP HANA.
SQL Server Analysis delivers online analytical processing for business intelligence applications allowing users to design, create and manage multidimensional structures that include data collected from various data sources. The inclusion of SQL Server Analytics allows enterprises to access database’s operations, objects and data. However, administrators can determine the level of access granted to various users and ensure that employees can view only the data authorized to them.
"With the updated gateway you can now connect to Analysis Services and issue live queries to both tabular as well as multidimensional models, For multidimensional models, we use the DAX (Data Analysis Expressions) over MD capability to connect to on-premises multidimensional models and a pre-requisite of SQL Server Analysis Services Enterprise edition," says Power BI team, Microsoft.
By James Seevers, CIO & GM, Toyoda Gosei
By Bill Krivoshik, SVP & CIO, Time Warner Inc.
By Gregory Morrison, SVP & CIO, Cox Enterprises
By Alberto Ruocco, CIO, American Electric Power
By Bruce. D. Smith, SVP & CIO, Information Systems, Advocate...
By Adrian Mebane, VP-Global Ethics & Compliance, The Hershey...
By Graham Welch, Director-Cisco Security, Cisco
By Michael Watkins, Senior Product Director, Global Knowledge
By Bernd Schlotter, President of Services, Unify
By Patrick Hale, CIO, VITAS Healthcare
By Steve Bein, VP-GIS, Michael Baker International
By Jason Alan Snyder, CTO, Momentum Worldwide
By Mike Morris, CIO, Legends
By Louis Carr, Jr., CIO, Clark County
By Bill Dow, SVP and General Manager of Business Solutions,...
By Jim Whitehurst, CEO, Red Hat
By Darren Cockrel, CIO, Coyote Logistics, a UPS Company...
By Nathan Johnson, SVP and CIO, Werner Enterprises [NASDAQ:...
By David Tamayo, CIO, DCS Corporation
By Neil Hampshire, CIO, ModusLink Global Solutions, Inc....