Generic Data Connectors for SAP Lumira Discovery

Generic Data Connectors for SAP Lumira Discovery

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

SusanLamatrice

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
Comments are disabled in preview mode.
Topics
 
 
Latest Stories in
Your Inbox
Subscribe
More From Progress
New_Mobile_Dev_Ebook_Progress_Website_Thumbail
The New Mobile Development Landscape
Download Whitepaper
 
IDC Spotlight Sitefinity Thumbnail
Choosing the Right Digital Experience Platform to Improve Business Outcomes
Download Whitepaper
 
TheFastestWayToBuildMobileAppsArtboard-2
The Fastest Way to Build Mobile Apps With Cloud Data
Watch Webinar