Skip to Content

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.

 

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply