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.