Azure Data Factory Offers SAP HANA and SAP BW

Azure Data Factory enables SAP HANA and Business Warehouse data integration, boosting analytics.

Share online:

Azure Data Factory, a cloud-based data integration service, now allows users to load data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.

"With this release, you can easily ingest data from the existing SAP HANA and SAP BW to Azure, so as to build your own intelligent solutions by leveraging Azure's first-class information management services, big data stores, advanced analytics tools, and intelligence toolkits to transform data into intelligent action," writes program manager.

The Azure data stores include Azure Blob, Azure Data Lake and Azure SQL Data Warehouse. SAP is a market leader in enterprise application software. Here is what is new:

SAP HANA connector supports copying data from HANA information models (such as Analytic and Calculation views) as well as Row and Column tables using SQL queries. You need to install latest Data Management Gateway version 2.8 and SAP HANA ODBC driver to establish the connectivity.

SAP BW connector supports copying data from version 7.x InfoCubes and QueryCubes including BEx queries using MDX queries. Install latest Data Management Gateway version 2.8 and SAP NetWeaver library to establish the connectivity.

SAP HANA and SAP BW in Azure Data Factory
SAP HANA and SAP BW in Azure Data Factory

Azure Site Recovery available in five new regions today, totaling to 27 regions worldwide enabling customers to deploy ASR.

Irrespective of the region ASR deployed in, "it guarantees same reliability and performance levels as set forth in the ASR SLA."

Azure Backup provides consistent file system backup of Linux Virtual Machines running in Azure—today, Microsoft has made the application consistent backup for Linux VMs using Azure Backup available for enterprise critical applications such as MySQL, InterSystems Caché DB, and SAP HANA running on popular Linux distros (e.g. Ubuntu, Red Hat Enterprise Linux, etc.).

"This framework gives you flexibility to execute custom pre and post scripts as part of the VM backup process. These scripts can be used to quiesce application IOs while taking backups that guarantee application consistency."

Use Azure Machine Learning Studio for data simulation in machine learning. A convenient way to implement and reuse data simulation in Azure Machine Learning (AML) Studio is through a custom R module, writes a data scientist at Microsoft.

R modules merge the convenience of an R script packaged inside a drag-and-drop module, he writes, with the flexibility of a custom code that gives the user freedom to add and remove functionality parameters.

Microsoft today published an overview of how banks can get extra computing heft with Azure and ActivePivot together.

With Azure, banks can analyze data in real time and make the right decisions "intraday and be more equipped to meet the regulatory standards," writes Matthew Thomson, Azure Big Computing senior product manager.

Thomson explores the new possibilities of even more computing heft with "scale out architecture for in-memory analytics in Azure through ActivePivot."

ActivePivot is an in-memory database that aggregates large amounts of fast-moving data through incremental, transactional and analytical processing to "enable customers to make the right decisions in a short amount of time." It is part of the ActiveViam platform that brings big compute and big data closer together, Thomson says.

App consistent backup for Linux VMs using Azure Backup
App consistent backup for Linux VMs using Azure Backup
Azure Site Recovery Map
Azure Site Recovery Map

At Adobe Summit, Microsoft with Adobe will announce the availability of their first set of joint solutions designed to help enterprises transform their customer experiences.

These solutions will transform cross-channel experiences and campaign orchestration using Adobe Experience Cloud and Microsoft Azure, Dynamics 365 and Power BI.

In addition, the companies will announce a collaboration on an industry standard to define and unify the language for marketing, sales and services data needed to deliver digital experiences consistently at scale.

Microsoft along with partners launched the first publicly available water-risk analysis and financial modeling tool that translates water scarcity risks into financial terms.

Released in honor of World Water Day on Wednesday, March 22, the Water Risk Monetizer tool provides data to help businesses factor current and future water risks into their decision-making, writes Josh Henretig on the Microsoft Green Blog.

Microsoft used the tool to assess the risk of its datacenter near San Antonio, Texas, located in a high water-stress region. "The data insights gained will allow Microsoft to save more than $140,000 in water costs annually and avoid using 58.3 million gallons of water a year," Henretig writes.

Microsoft's Water Risk Monetizer tool
Microsoft's Water Risk Monetizer tool

In other news, Alain Crozier, CEO of Microsoft Greater China said in an interview:

"We have already developed the first version of the Windows 10 government secure system. It has been tested by three large enterprise customers. We have worked extensively to make it secure and controllable. We are now ready to serve the market."