Generic Data Connectors for SAP Lumira Discovery

Generic Data Connectors for SAP Lumira Discovery

Posted on June 04, 2018 0 Comments
Generic Data Connectors for SAP Lumira Discovery_870x450

Learn how you can connect to Lumira Discovery Edition to easily connect to multiple data sources, even if they lack built-in support from Lumira.

What is Lumira Discovery Edition?

Lumira Discovery Edition is visualization analytics software from SAP which aims to provide self-service capabilities to create and share maps, charts, and infographics with an intuitive dashboard. Lumira Discovery has the built-in ability to import data from on-premises and cloud data sources, including Hive, Greenplum, Oracle and others.

SAP Lumira Discovery

Accessing Other External Data with Lumira Discovery

While Lumira Discovery has some data source drivers readily available, what can you do if your particular data sources are not supported? The Discovery Edition provides the capability to connect to a "generic" external data source using JDBC and OData APIs.

The JDBC API defines a set of Java interfaces that encapsulate major database functionality, such as running queries, processing results, and determining configuration information. A JDBC driver uses the Java Database Connectivity API originally developed by Sun Microsystems, now part of Oracle, which provides a standard way to access data using the Java programming language. 

OData is a REST-based protocol for querying and updating data. It is built on technologies like HTTP, ATOM/XML and JSON. It is more flexible than other REST-based web services and provides a uniform way to describe the data and the data model for easy interoperability between data sources, applications, services and clients. As with JDBC, OData gives you a single way of accessing multiple data sources. 

How to Use JDBC and OData

Access to generic JDBC and OData connectivity is available in SAP Lumira under the "SQL Drivers" preferences. To access that screen, open SAP Lumira Discovery, go to File -> Preferences -> SQL Drivers and expand the "Generic" menu item. Here's a look at that screen:

1 Lumira Discovery

For OData connectivity, you'd select the "Generic OData 2.0 - OData Connector" option under the  "Generic" menu item. Enter your OData end point URL with user name and password, if those are applicable:

SAP Lumira Discovery OData

For JDBC, select the "Generic JDBC Data Source - JDBC Drivers" option. My colleague Saikrishna Bobba has written a detailed tutorial demonstrating the next steps on how to connect to the DataDirect Eloqua JDBC driver in SAP Lumira Discovery.  Follow along with his tutorial to do the same in your environment.

5 Lumira Discovery

While this tutorial uses an Eloqua JDBC driver, these same steps would apply to any DataDirect JDBC driver. Get Started today with a free trial download of our DataDirect JDBC drivers and see what data you can bring into Lumira Discovery!

Get Started


Susan Lamatrice

Susan Lamatrice is a Technical Marketing Manager with 20 years’ experience in the Data Connectivity field. Susan has experience in Pre-Sales and Post-Sales technical support, as well as training and Sales Enablement. Her work is focused on making technical information consumable and engaging for both technical and non-technical audiences.


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation