Day: February 11, 2018

Those who haven’t heard about or experienced SIT (SAP Inside Track), it’s a local event organized by SAP community members for community members , an opportunity to connect with your peers, learn from each other, share experiences and be inspired by great talks. In short, A day of Learning, Sharing, Networking, Fun & much more!

First SIT of 2018 started with 3rd edition of SAP Inside Track Walldorf. There was also a parallel track for kids, where youngsters were given the chance to develop their technical understanding and skills, learn to work in groups with like-minded or different kids –  a step towards diversity and inclusion! 

here, in this blog, i am going to share highlights of the event based on #sitWDF & #sitKIDS tweets

Malin Liden started keynote- Future IS Community (periscope recording)

and then invited Thomas Grassl on stage who announced:

In parallel, kids were introduced to what they would be doing throughout the day

speakers (partners, customers, University professor & also SAP employees) shared their experiences on SAP products & solutions

( Sven Denecken Q&A recording)

sitWDF, sitKIDS family picture

kids busy with gadgets

 

after this, it was time for lunch

after lunch, it was time for marketplace sessions

and then sessions resumed in respective rooms,

 

and it the end it was time for kids’ projects presentation,

 

few recordings from kids show video1 , video2, video3 , video4 , video5

all kids on stage

Big thanks to entire team for successful execution of this event.

also, big thanks to Christian Braukmüller for designing Kids shirt

More photos can be found here, link1 , link2, link3

speakers presentation will be available soon, stay tuned at wiki page.

In case you are interested to join, here is list of upcoming SAP Inside Track

* SAP Inside Track Campinas February 3 #sitCPS
* SAP Inside Track Hannover February 24 #sitHVR
* SAP Inside Track Salvador, February 24 #sitSAL
* SAP Inside Track Frankfurt, March 10, #sitFRA
* SAP Inside Track Belo Horizonte, April 7, #sitBH
* SAP Inside Track Timisoara, April 14, #sitTimisoara
* SAP Inside Track Copenhagen, May 5, #sitCPH
* SAP Inside Track Wrocław, May 19, #sitWRO
* SAP Inside Track Sao Paulo – Functional Edition, July 20th – #SITsp
* SAP Inside Track Bern, Septembre 8 2018 #sitkids #sitbern with pre event
* SAP Inside Track Recife, Septembre #sitREC http://bit.ly/2BQGXU9 #SAP #SAPCloud #AI

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/2BmJVic #SAP #SAPCloud #AI

Negotiating CSV

As the API Evangelist, I work with a lot of government and business users. One thing I’ve learned working with these groups is the power of using comma-separated values (CSV) as a media type. I know that us developers and database folks enjoy a lot more structure in our lives, but I have found that allowing for the negotiation of CSV responses from APIs, can move mountains when it comes to helping onboard business users, and decision makers to the potential of APIs–even if the data format doesn’t represent the full potential of an API. CSV responses are the low bar I set for my APIs, making them accessible to a very wide business audience.

CSV as a data format represents an anchor for the lowest common denominator for API access. As a developer, it won’t be the data format I personally will negotiate, but as a business user, it very well could mean the difference between using an API or not. Allowing me to take API responses and work with them in my native environment, the Excel spreadsheet, or Google Sheets environment. As I am designing my APIs, I’m always thinking about how I can make my resources available to the masses, and enabling the negotiation of CSV responses whenever possible, helps me achieve my objectives. https://goo.gl/br8BRG #DataIntegration #ML