Timing is Everything: Realtime in the Real World: Smart Data Integration SAP ECC Replication
Now there’s a huge coincidence. On the day I bought an Audi, I am writing about a SAP HANA technology where Audi features in the data set as an example. Whilst writing about Tahir Hussain Babar’s instructional video on ECC Replication in SPS09 for the SAP HANA Academy I am not going to discuss company brands but will touch on how coincidences affect our decision making. Think back to even important decisions such as the purchase of a car or the selection of a life partner. Most of these decisions are not objective, quantifiable or even based on specific need. Many of them, though we don’t admit it, are emotional decisions that boil down to timing. To paraphrase the Godfather, “the price you pay for the life you choose”, can boil down to a pair of eyes and a nice smile or a colour and fancy badge. When I write these blogs I do so as an experienced teacher with management experience and father of teenage girls. A middle income, middle aged graduate professional from a humble background but with a noble heritage, I am heavily influenced by where and how I was brought up. I am partly the result of the selfish decisions most of us make, an honourable exception being Bob, aka Tahir Hussain Babar. The connections I make between what strikes me as I review these videos is not always direct and clear from an IT commercial perspective. When I write about videos on Geospatial Analysis I remember a time before SAT NAV. I know that the two are only tenuously connected. Why do I mention this? It’s simple. We learn in text books that businesses exist for a variety of reasons but whilst remembering the primary reason – making a profit, forget what we are dealing with – people. People make many of the most important decisions of their lives based on the information they have at the time. This information is processed thorough a mind influenced by a whole set of experiences and perhaps genetic tendencies. This video is about real-time processing. Again tenuous but relevant, like the fluttering of a butterfly’s wings on the other side of the Atlantic, real-time processing affects customer behaviour. People in receipt of real time information will make decisions differently. This is why businesses invest in it.
This video is about replication. In this session you connect to a remote system which is an ECC system in DB2. This task will then be replicated in real time into SAP HANA. This is real-time transacting and will democratize and open up many closed business systems including the auction I bought my car.
Bob starts off by demonstrating how to look at the source data. He discusses how this is like a virtual view on top of ECC tables in DB2. He outlines how he is going to do this by using SAP Logon to change attributes about a customer. You should see the changes in the remote system in DB2. After setting up replication you will see these changes in your own SAP HANA system. Bob explains that you cannot actually view the data here. This is a virtual table which is sitting on top of the DB2 system. To get around this problem Bob demonstrates adding a virtual table into a schema.
Bob shows how the table is replicated to his schema. He explains how this isn’t really a table. It’s a view that is pointing to that DB2 system. He asks a rhetorical question. How can this be proved? He opens the table content showing a list of customers going into his remote system.
Bob then demonstrates updating a particular customer using the SQL where clause by customer number. To allow for the connection he puts in six trailing zeroes. He then demonstrates how to change one column in the record selection below.
After logging on to the SAP GUI System Bob demonstrates how it is connected to the ECC system. He creates a transaction code which will modify the master customer data. He verifies that he is logged into the right client and runs the command XD02 to modify the data he has selected for the purpose of the demonstration. This updates the relevant value in the table above.
Bob emphasises that this isn’t replication. This is a view using smart data access in SAP HANA which is connecting to that remote DB2 system running SAP ECC.
This is a real-time job so you need to set the base properties on the canvas especially the Real time Behaviour which needs setting to real time.
After creating a connection between his schema and a template table in HANA, Bob activates the connection to purposely demonstrate a common error. This error occurs because you need to set both the base object and the data source with real-time behaviour.
Bob then explains that in a production environment you would not want to keep re-executing this job. The replication should be pushing the data changes. Selecting real-time creates a procedure. You can see it when you go into your Catalog as shown. To test this you need to run it in a SQL console.
The data is being pushed so all you need to do is run it once with a call statement. It’s not running every few seconds, the agent is taking care of the replication. Bob then proves once again that the data is being replicated in real-time between the original and replicated tables.
Real-time systems have been with us for some time and are strongly influencing our decision making. My recent car adventures are a case in point. My car sadly died a few weeks ago. It was killed in an accident. I was on my way to teach Ruby on Rails in one of the most deprived areas of Northern England at the time. It had completed 185,000 miles on the original clutch, gear box and exhaust. It was beginning to look battered and I had, like a man with a roving eye, flirted with the idea of getting another car. “It’s costing us too much money” I would complain. In reality the car owed us nothing. I tried out other cars, but for the extra investment, found them lacking. The car soldiered on as its bodywork fell apart. The engine for me, remained unchanged, it was in a way beautiful. It had that winning combination of speed and economy which so easily wins you over.