Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashutosh_rastogi
Active Contributor



This blog is part of the Lumira 2.0 launch blog series

SAP Lumira, edition for SAP Business One brings you an option to connect to your SAP Business One, build analytics and find insights. In this blog I would like to focus on how you can connect to your SAP Business One



  • If you are connecting to SAP Business One on MS SQL, you can connect via "Query with SQL" using MS SQL driver

  • In case you are connecting to SAP Business One, version for HANA. Then you have following additional options:

    • Live connection to SAP Business One on HANA (via HANA Live in Lumira)

    • Import from SAP Business One on HANA (via HANA Import in Lumira)



  • Third option is export your data to excel and use MS excel option in Lumira to analyse your data



Connect via "Query with SQL" using MS SQL driver


Consider your SAP Business One is hosted on a MS SQL server, you can then use "Query with SQL" option of SAP Lumira.

MS SQL Server drivers do not come pre-installed with SAP Lumira. Hence, follow the steps below to install the driver

  • Launch SAP Lumira, edition for SAP Business One

  • Go to file menu at to left, select preferences > SQL Drivers

  • Search for MS SQL

  • Select Install to install the driver




You need to select the “Query with SQL” option on SAP Lumira, edition for SAP Business One home screen



In subsequent dialogue, search for “MS SQL”.

I would select below “MS SQL Server 2014 - JDBC Drivers”, you may pick the right version of your MS SQL Server.



Click Next

Enter the database details in the subsequent Dialog



Once you are connected to database, you can select the table and preview data. You can as well specify your own query for fetching data.



Once you are done, click Visualize and you can start with analysis


Import from SAP Business One on HANA


This option can be used to connect to SAP Business One, only when you have SAP Business One, version for SAP HANA.

you need to select the “SAP HANA Import” option on SAP Lumira, edition for SAP Business One home screen



Either choose a managed connection from SAP BI platform, or provide the HANA system details where SAP Business One system is hosted.



Once you are connected, you would be able to search on all the views created in your HANA system. You can select a view



Click Visualize to start exploring that view.


Connect Live to SAP Business One on HANA


This option can be used to connect to SAP Business One, only when you have SAP Business One, version for SAP HANA.

And you have INA enabled on HANA system with your user having relevant rights and permissions.

Refer blog for INA



Once you are done with INA prerequisites. You need to select the “SAP HANA Live” option on SAP Lumira, edition for SAP Business One home screen



Either choose a managed connection from SAP BI platform, or provide the HANA system details where SAP Business One system is hosted.



Search and select the view for analysis



Click Visualize to start exploring that view.