SAP Lumira and Business One

[Former Member]

Test driving Lumira right now and I am not seeing the in the instructional videos how to connect to a SAP B1 database on SQL.  I can see Hana instructions and  Business Objects but not the SQL version of B1.  What am I missing?

Thank you

[juancarlos_huerta · Accepted solution]

Stacy,

I was able to do it with this source type: "Query to SQL"...

Acquiring data using Query with SQL - About SAP Lumira - SAP Library

Connecting to a Query with SQL data source - About SAP Lumira - SAP Library

Regards,

JC.

[former_member319241]

Hi,

You have to use directly SQL query for connecting to SAP B1 database.

You can then select Microsoft SQL Server database from SAP Lumira and write SQL query to create SAP Lumira dashboard.

On this page you can find the link for

Acquire a dataset from a database using Freehand SQL: SAP Lumira 1.28 - YouTube

Thanks.

[kothandaraman_nagarajan]

Hi,

Please check with this link for more information:

SAP Lumira 1.29 – SAP Help Portal Page

Thanks