Let's continue to look at the various data connectors for SAP Lumira. One of the most popular are relation data sources. Usually, there are plenty of systems which can provide business insights, such as order systems, warehouse systems, call centre systems, human resources systems, and so on.
Using Query with SQL we can create our own data provider by manually entering the SQL for a target data source:
However, users need to be familiar with their database and the SQL language to use Query with SQL. You can specify the source tables, columns, and functions to acquire data. In this book we will connect SQL database MySQL via JDBC driver. However, Lumira offers us more options, but they are out of the scope of this book.
SAP Lumira can connect a database via a JDBC driver.