Automate your infrastructure to build, deploy, manage, and secure applications in modern cloud, hybrid, and on-premises environments.
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.
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.
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.
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:
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:
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.
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!
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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.
Copyright © 2021 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.