Welcome to this video where I would like
to present you our new information
management in HANA offering. My name is
Fernando Villas I am a product manager
in the EIM organization. IM in HANA
provides a simplified landscape where
users can author projects from a single
modeling environment which would be HANA
studio or it’s cloud version HANA Web IDE.
Bringing the data to HANA from a variety
of sources from on-premise sources or
cloud it is equipped with several
out-of-the-box built in adapters and
this set of adapters is extensible
throughout documented SDK and because it
works within HANA workloads are
accelerated resulting in lower latency
for the availability of the data for
consumption. I'm going to illustrate IM
in HANA through working demo. My business
case today is about auditing purchasing
transactions. We would like to find out
how much business we are doing with
vendors that have been favorably rated.
For the purposes of the demo we are assuming
that this external information has
already been brought to HANA and is
present in this table that we were
seeing here.
During our demo today we'll be
replicating two tables from an SAP
production system that is holding the
purchasing information. This production
system is seen here as a remote source
from my HANA studio cockpit. So let's
take a look at the out-of-the-box
adapters we have. One we will be using
today will be the db2 ECC adapter and on
these remote sources we have at this
moment one agent running which is
running at this remote location where
the SAP production data is being stored.
The schema where I will be bringing all
these tables is this RF schema here.
Currently it has no tables. If I run this
query asking for a table it will fail. So
I need to go and create a replication
task.
Replication tasks need to be defined
through the Web IDE currently. Before SPO9
is delivered developers will be
also able to define replication tasks
within HANA studio but for the time
being we'll be showing Web IDE here. So
I'm loading in and I'm getting to the
place where our replication flow will be
defined. Just click on new file and enter
a file name here. So I give a name to the
task HDB rep task. Hit create and so now
I can choose the remote source I am
going to defy the target schema. Virtual
tables are also going to be created. We
could create them in their own schema
but I'm going to choose here the same
schema and to create a prefix and then
I'm going to add remote objects. For that
then I need to browse the SAP remote
source. LAF1 table which is the
one I want.
So all column names from the table
LFA1 which is the one who holds all
the providers from SAP appear here. And
then there is the second table I want to
add which is the purchasing table
which is down below in the material
management hierarchy. Once I find the
table I bring it over and likewise I can
see all the columns at this point I'm
going to save the transformation. Logout
from here and retrieve my schema. My RF
schema should now have been populated
with virtual tables are corresponding to
the two sources I want to bring
over. Here they are and real tables which
for the time being this one being the
real table is empty and the other one
the virtual one. Well I can see the data
flowing over the remote source.
Replication will be effective when
executing this store procedure here. This
procedure was generated at the time we
saved the replication flow in Web IDE.
It is defining some remote subscription
objects at the remote source that will
read
DB2 redo logs bringing over only
transactional consistent data. The
procedure then performs the initial
loading on both tables and will listen
and distribute changes over to HANA on
both tables afterwards. At this point I'm
going to call this stored procedure to
start the replication. If we turn over
here we will see at the remote side that
there is some activity. The agency is
receiving the order from HANA and is
starting to load the changes. After some
44 seconds we can now check to see if
our data is here. So let me bring counts
for both of the real tables and we can
see here that we have 14,000 for the
purchasing table and 2,000 rows for the
provider table. Now that I have
replicated these two tables in HANA I
can write interesting confirmations to
solve my business problem.
I start by restricting my providers to
Germany. Restricting my transactions
to client 800. Perform the join between
these two tables using provider number
and client number. And then because I
want to see the number of transactions
in German cities that needs an aggregate
transform after the join of the two
tables and the result is stored here in
table vendor TR_City. Once this flow
executes I obtain here a table vendor TR
_City I can execute these two queries and
I see that I have more than 4,000
transactions and this is the breakdown
by city. Now remember my business problem
which was to find out how much business
goes through the vendors with first
rating. So for that I wrote this flow
where it basically looks like before but
here I'm joining my independent set of
our ranked vendors with my LFA1 SAP
table and the join is on the name of the
firm. Once the second flow executes I get
this second table here and with this
table I'm going to be able to find out
those transactions going with first rate
German providers. I get my first set of
numbers here. My number of transactions
go down to 834 so about a fourth of
what I had and here is a breakdown by
city. Now 25% of our business going
through vendors with first rating seems
like low. We are comparing names of firms
with name one from LFA one and you can
see here that there are similar
companies that should match but they
don’t. We have a cleanse transform coming
from our data quality software which is
very good with cleansing party data
which includes names of firms, addresses
people names, etc. So now we can apply the
cleanse transform to LFA1 cleanse the
firm names and the addresses and then
join with our first rated vendors with a
strict column equality and let's see
what our results become. Once I execute
that last flow I get this third table
which allows me to see that cleansing
did really good to our results because
now I have almost half of my
transactions with a much larger number
of cities going through our first rate
providers. This concludes my demo thank
you very much for your attention