How to use VDP as a SAP Lumira Data Source

Applies to: Denodo 7.0 , Denodo 6.0 , Denodo 5.5 , Denodo 5.0
Last modified on: 07 Mar 2018
Tags: SAP Connectivity

Download document

You can translate the document:

Goal

In this document we will learn how to integrate SAP Lumira into Virtual DataPort as a JDBC data source.

Content

SAP Lumira is a reporting solution that allows accessing, transforming, and visualizing data. It can read data from multiple sources, visualize it, and then compose stories from those visualizations that can be shared with other tools like SAP Lumira Cloud, SAP Lumira Server, SAP StreamWork, SAP HANA, or SAP BI.

Download SAP Lumira

In this example we will use the free version of SAP Lumira.

Add the VDP JDBC driver

  1. Go to File > Preferences and select in the left panel SQL Drivers”.
  2. In the right panel a list of drivers is loaded. Select Generic JDBC datasource - JDBC Driversand click on the “Install Drivers” button at the top.
  3. Browse to the denodo-vdp-jdbcdriver.jar file.

Create new charts/visualizations/datasets

  1. Go to File > New to create a new report.
  2. The first step is to select the Dataset. In the new dialog select “Query with SQL”.

  1. Click on the “Next” button.
  2. Select “Generic JDBC datasource” and click on “Next” again.
  3. Enter the typical connection parameters to VDP:
  • User Name / Password
  • JDBC URL: jdbc:vdb://<host>:<port>/<database>
  • JDBC Class: com.denodo.vdp.jdbc.Driver
  1. Click on the “Connect” button.
  2. The dialog will show the list of views of the VDP database:


  3. When selecting a view, a sample SQL query is created in the right panel.
  4. After clicking on the “Preview” button an error is shown:

  1. In order to fix the error, change the query from:

select * from "database_name"."database_name"."view_name"

to:

select * from "database_name"."view_name"

  1. Click on Preview again.

  1. Finally, click on Create and to start creating the report:



Compose the report

Now we can create the final reports using the charts created in the previous step. We can add external images, text, etc.

Publish

The final step is to publish/share the report. The available options are:

  • Export as File (Excel or CSV).
  • Publish to SAP HANA.
  • Publish to Explorer.
  • Publish to SAP Lumira Cloud (you have a 1GB with the free registration).
  • Publish to SAP Lumira Server.
  • Publish to SAP StreamWork.
  • Publish to SAP BI.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training