Skip to Content

John Mrozek does a great job of showing how you can connect to your SAP ERP system with Lumira in this blog SAP Lumira 1.0 SP11 – New features at a glance part 1

Note he says you cannot pass parameters in this version.  Therefore you need to ensure you are only returning small amounts of data against your ECC InfoSet.  I am using sample/test data from a custom SAP ERP Special Ledger Infoset.

One item I noticed is there is a button for “SQL History”:

/wp-content/uploads/2013/06/1sqlhistory_232015.png

The other thing I learned is you have to click the “Preview data” button before you can “Acquire” the data:

/wp-content/uploads/2013/06/2sqlpreview_232016.png

When using Freehand SQL against ECC you get the fields names – the Business Layer from the IDT provides more business-friendly terms,   As a result, I found myself renaming some of the fields and having to reformat, including converting to text:

/wp-content/uploads/2013/06/3aconverttotext_232017.png

At this point you can visualize the data in Lumira on the desktop:

4VISUALIZE.png

Just for fun I publish to the Lumira Cloud:

/wp-content/uploads/2013/06/5publishdataset_232019.png

I can also save the document to the Lumira Cloud:

/wp-content/uploads/2013/06/6savedocumenttolumiracloud_232020.png

See below from the Lumira Desktop – it shows the document has saved to the cloud:

/wp-content/uploads/2013/06/7lumiracloud_232021.png

After logging on to Lumira cloud (cloud.saplumira.com) you can see how it looks (still on the PC browser):

/wp-content/uploads/2013/06/8browserhowitlookswithdataset_232022.png

What is also nice is being able to visualize and interact with the data on the iPad:

9oniPad.PNG

You can visualize on the iPad:

10oniPad.PNG

You can interact and analyze on the iPad as well.

11interactonipad.PNG


To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Vijay Chanchlani

    Hi Tammy,

    Nice intuitive article.

    I was successfully able to connect the Lumira to SAP Backend using Java connector as you mentioned.

    However, I am not able to see any of my Backend tables in the list.

    I want to use the data stored in the SAP Backend tables.

    Regards,

    Vijay.

    (0) 

Leave a Reply