What It Is

With the release of Teiid 8.11.Final, we have introduced support for SAP HANA as a data source. Teiid is the project used for creating the Red Hat JBoss Data Virtualization (JDV) product and Teiid 8.11.Final will be part of the upcoming Data Virtualization 6.2 release. SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud.  It is a revolutionary platform that’s best suited for performing real-time analytics, and developing and deploying real-time applications. At the core of this real-time data platform is the SAP HANA database which is fundamentally different than any other database engine in the market today.

Image reference from SAP Community Network

JDV overview

How the SAP HANA Translator Works

Using the SAP HANA JDBC driver with Teiid, you can connect to SAP HANA, compose your views, and consume data from SAP HANA and other disparate data sources to create a single view of all of your SAP-related information. JDV can expose this single source via JDBC, ODBC, REST, OData or SOAP services. This allows for consumption of SAP HANA data as well as web services, relational databases, application systems, cloud, etc that can be utilized by enterprise applications, mobile, reporting or whatever client needs access. In addition, with JDV you can create custom views for each end user of the data with full CRUD capabilities, custom security and caching for a secure and performant solution to data integration with SAP.

A Typical Use Case

While there are many possibilities for solving SAP HANA data integration challenges using JDV, some scenarios are more common across all enterprises. A somewhat common problem users encounter is getting disparate data from SAP and other systems or web services and easily consuming that federated data in the field within mobile applications. JDV can easily accomplish this using the SAP HANA translator as well as its full suite of translators and connectors to create a single view and point of connection for your mobile applications. Furthermore, since the data from JDV can be exposed as web services (OData, REST, or SOAP), JDBC, or ODBC, the implementation can be tailored to be application-specific. The following diagram shows what an environment like this might look like, integrating SAP HANA with a SQL Anywhere data source and exposing as an OData service from a JDV instance running in the cloud.

Try it out... for free!

You can download Teiid 8.11.Final now which includes the SAP HANA translator. You will also need the Teiid Designer to create your models and views. Feedback is always welcome and please let me know if you have any questions!