Day: February 14, 2018

Hi,

In this post, I have explained step by step configuration of  Smart Data Access for Hana Database with error resolutions.

One of main challenges that companies are facing today are

1. Get information in real time to make quick decision on time

2. At the same time, we need to keep control over cost for IT and Technology.

By Keeping Business requirement in mind, SAP has introduced Smart Data Access in SAP HANA which is a Virtualization Technique. This feature is introduced from Hana 1.0 SPS 6 in SAP HANA.

What is Smart Data Access?

SAP HANA smart data access enables remote data to be accessed via SQL queries as if they are local tables in HANA, without copying the data into SAP HANA.
Not only does this capability provide operational and cost benefits, but most importantly it supports the development and deployment of the next generation of analytical applications which require the ability to access and integrate data from multiple systems in real-time regardless of where the data is located or what systems are generating it.

Key Concept of SAP HANA Smart Data Access

Smart Data Access is a technology which enables remote data access as if they are local tables in HANA without copying data into SAP HANA.

It is based on local virtual tables that maps to an existing object at the remote data source site.

Data required from other sources will remain in virtual tables. Virtual tables will point to remote tables in different data sources. It will enable real time access to data regardless of its location and at same time, it will not affect SAP HANA database.
Customers can then write SQL queries in SAP HANA, which could operate on virtual tables. The HANA query processor optimizes these queries, and executes the relevant part of the query in the target database, returns the results of the query to HANA, and completes the operation.

With the SAP HANA 2.0 SPS 00 release, virtual tables have been integrated with result caching in HANA. Static caching has been available as of SAP HANA 1.0 SPS 11, what is new in this release is the support for virtual tables. If you choose to enable the caching feature on virtual tables you can look forward to improved performance by means of avoiding redundant computation of identical and frequent queries. You can enable this feature either directly via the ini file or by using SQL. Also keep in mind that you need to define a cache staleness restriction when configuring.

Restrictions on usage of Smart Data Access:

Data in virtual tables cannot be modified i.e. insert, update and delete operations are not possible on virtual tables. However, we can do select on virtual table and put data in HANA table.

Virtual table does not support BLOB/CLOB data type. Workaround of this problem is to create view on remote table by excluding column of BLOB/CLOB type and then create virtual table with the help of view.

Virtual Tables cannot be used in multi node HANA cluster. However, it is possible to access virtual table from one HANA server to other.

Some analytical view does not support virtual tables.

Need to add below entries in odbc.ini file

[HDB]

Driver=/hana/shared//hdbclient/libodbcHDB.so

ServerNode=:31113

->Expand the  folder Provisioning http://bit.ly/2BZMMif #SAP #SAPCloud #AI

Schoolhouse Electric, Portland-based maker and retailer of handmade, iconic lighting, furniture, and domestic home goods, was founded on family values and quality.

To reinforce that sense of family and community, owner and founder Brian Faherty joins his team of employees each day in the Portland, Oregon, warehouse, which happens to be where his wife also works. He’s the inspiration behind the products, which are vintage with a minimalistic utilitarian and even retro aesthetic.

Handmade is Best-Made

Chris Tufts, vice president of operations and finance at Schoolhouse Electric, recently joined me on the phone to discuss how Schoolhouse is adapting digitally while also maintaining its artisan craft. As we talked, I could hear the bustling of creation and laughter in the background. His desk borders the lighting assembly center at the flagship store in Portland.

In the past, it was difficult to compete with the Amazon and Google retailers of the world that can ship a product to customers in as little as two days. Most products sold by Schoolhouse are assembled by hand (even hand-sewn pillows and cushions), a process that takes time and precision.

In addition, 80 percent of product parts are purchased from U.S.-based mom and pop suppliers, some of which provide custom-made parts for Schoolhouse.

“Ordering from mom and pop vendors is a challenge when it comes to scaling up, but it’s a great asset to the product that we can offer and the quality that’s included,” Tufts said.

Today’s customers expect fast delivery and reasonable prices, so to scale growth and cut lead time, Schoolhouse decided on SAP Business ByDesign, a full cloud ERP suite, to manage its business and provide near real-time visibility into supply, inventory, and customer trends.

Before implementing and going live with SAP Business ByDesign, Schoolhouse Electric staff performed a manual, quarterly inventory assessment on 2 million pieces of inventory. The process required the warehouse to close for a full weekend each quarter.

“It was a mess unquestionably. The results of the inventories might have been more harm than good depending on who you had counting different things and whether they could tell one washer from another.  It was pretty messy,” said Tufts. “With SAP, we have a regular ongoing constant cycle counting. We know exactly what inventory accuracy is by floor, by product segment, and we can track that to a high degree of detail. We know where and how much of each part we have.”

In addition to keeping parts on hand, Schoolhouse discontinued ordering obsolete parts.

“Without SAP, it was hard to visualize all of the material needed to make a product that has a five- to 10-part assembly process. By tracking our builds and materials in SAP Business ByDesign, we now have quick answers, and we’re able to quantify the impact and strategize how many of each product we can make in a certain timeframe. Today we are at 98 percent product availability, an increase from 70 percent in early 2016,” said Tufts.

Growth with Industrial Roots

Schoolhouse Electric plans to open a third store in Pittsburgh, Pennsylvania, a former industry hub of the U.S.  The city is a perfect complement to the Schoolhouse style. It’s a new hub for technology leaders like Uber and Google, the cost of living is reasonable, and there are many universities in the area.

Tufts closed our conversation mentioning that without the cloud ERP solution, Schoolhouse Electric wouldn’t exist in the market. The third store in Pittsburgh would not be a reality: “Without SAP, we wouldn’t be the size that we are. We wouldn’t be growing 25 percent year-over-year because we simply wouldn’t have had the competitive lead times, and we wouldn’t have been able to fulfill customers’ products as we committed. Our business benefits are stronger than enabling growth.  It would really not be happening had we not gotten into a cloud ERP system.”
—

Learn how SAP Business ByDesign can help your
small to midsize business here.

—

To implement SAP Business ByDesign successfully, Schoolhouse Electric partnered with Navigator Business Solutions. Learn more here.

Follow me on Twitter: @CMDonato.
This story originally appeared on the SAP Community. http://bit.ly/2BZuqhu #SAP #SAPCloud #AI

#InternetofThings #AI https://goo.gl/8Hv8f5 #Technology #IoT #ML