Tuesday, July 12, 2016

SAP LUMIRA (Installation & Connecting to Oracle Database)


Step: 1
Download the SAP LUMIRA Software from the below links


  • Sign in with any account shown (Preferably google)


  • Download the latest version into your local Computer





  • Click on Trial for Trial Version


  • Log in to SAP Store with your SAP Cloud Identity


  • Select SAP LUMIRA Standard Edition free trial


  • Review your account Information, accept terms and Place order


  • You will receive an e-mail with Reference Number from SAP Store Team, shortly describing the next steps on how to set up your trial.


  • Download the software file to your local computer

Step: 2
Installation:

  • Open the folder in which the software exists and double click on it


  • Choose a setup language and a destination folder then click next button


  • Accept the license agreement and click next button


  • If you want to change any content click previous button else click next button


  • The software is being installed and make sure that the window is not closed till installation is in progress


  • Click finish to complete the installation process


Step: 3

Add New Dataset:

  • From Home screen, click new document to add a new document


  • A pop up screen appears, where you can select different sources of dataset


  • For example, let us select a Microsoft Excel sheet as a source document and click next


  • Choose an Excel sheet residing on your local computer to create the dataset


  • Enter dataset name and check the check box set first row as column names and click on Create button


  • Hence the dataset with dimensions and Measures has been created.


Step: 4

Connecting to Oracle Database:

  • Open SAP LUMIRA


  • Go to File-->Preferences


  • A pop up screen with SAP LUMIRA Preference settings is displayed


  • Select SQL drivers tab, here you have the list of all databases that you can connect to


  • Let us select an Oracle database



  • Choose the version of Database you wish to connect and click on Install Drivers Button


  • Choose the path where the Driver for the Selected Database is present


  • The Symbol shows that SAP LUMIRA has been connected to the selected Database via the Driver. But, we need to restart the SAP LUMIRA for changes to apply


  • Click OK and Restart the application

  • Open SAP LUMIRA, go to File-->New


  • Click on Query with SQL as data source option


  • Expand the Oracle database which you need to connect


  • Select the Database version for which the connection is established and click next


  • Enter the credentials to connect the Database

  • Enter Database Credentials and Click on Connect Button 

  • Select a table from the list of Database schemas present in the Oracle Database


  • Let us select Profits table in SH Schema and Query panel is automatically updated then click Preview Button


  • We can Select a few or all columns from the table and click on Create Button to create our Dataset


  • The table data is extracted from the Oracle database and a dataset with Dimensions and Measures is created by SAP LUMIRA


  • Now, we can create any number of Visualizations and Share the Visualized Data               


  • Here is a sample visualization for the acquired dataset



Note:
  • This is a Trial Version of Standard Edition hence, the Share Phase is not available but it is available for full version of SAP LUMIRA.
  • To Explore the Share Phase tab it is recommended to install Personal Edition which has access to limited Data sources to Connect.

12 comments:

  1. I'm glad that I found your website Thanks man for your tips. Great job. Keep it going ;)

    ReplyDelete
  2. Hello,
    Simply, this Lumira is a desktop application that will probably run on its own JVM. It mostly installs its own Java runtime environment libraries with any of the core java version conflicts. The availability of the application is completely based on the individual machine hardware configuration. On the given descent desktop, it really performs well and it is probably launched in the 32 or else 64-bit environment based on the host's system. Thank you for sharing. I just wanted to share information about SAP Lumira Online Training.

    ReplyDelete
  3. This is really a useful article as it helps me learn a lot about SAP. You can also learn here about comptia a+ course

    ReplyDelete
  4. The website is so easy to use – I am impressed with it. Thank you for Sharing. The AWS service is provided by Amazon which uses distributed IT infrastructure to provide different IT resources available on demand. AWS Developer Certification Training provides basic and advanced concepts. Our AWS tutorial is designed for beginners and professionals.

    ReplyDelete
  5. Thanks for your post which is truly informative for us and we will surely keep visiting this website.

    AWS DevOps Certification

    ReplyDelete
  6. "Excellent material! Your post expertly demonstrates your knowledge and commitment. Our professional community values and highly appreciates your insights. I look forward to your future insightful contributions. DevOps Certification


    ReplyDelete
  7. "Your post shows that you have a thorough understanding of the topic. Your opinions are well-informed and significantly advance worthwhile debates. Kudos! DevOps Course

    ReplyDelete
  8. "Your post demonstrates a thorough comprehension of the subject. Your insightful comments add to the conversation and present new angles. Within our professional community, we sincerely appreciate the efforts you have made. I'm grateful. Ruby On Rails Training

    ReplyDelete
  9. It is a magnificent work of art! It enthrals with its perceptive writing, flawless research, and writing style. I appreciate you sharing your insightful viewpoint. Outstanding effort! Ruby On Rails Certification

    ReplyDelete
  10. Your essay is a stunning piece of writing! It captivates readers with its insightful writing, impeccable research, and writing style. Thank you for sharing your wise perspective. A superb work!  Salesforce Admin Training

    ReplyDelete
  11. Your essay is a stunning piece of writing! It captivates readers with its insightful writing, impeccable research, and writing style. Thank you for sharing your wise perspective. A superb work!  Splunk Course

    ReplyDelete
  12. The caliber and depth of your most recent post have truly astonished me. Your knowledge is evident in every sentence, and our professional community has benefited much from your views. It's impressive how you can simplify difficult ideas into facts that everybody can understand. Splunk Training

    ReplyDelete