Skip to Content
Author's profile photo Former Member

SAP and DataStax enable the Internet Enterprise

(Special thanks to Ashish Sahu -blog content and review, Eric Du and Travis Price for technical papers)

The NoSQL market has grown rapidly to support the vast amount of data generated by today’s world of intense, always-on environments.

Datastax, built on Cassandra, a high performance, Apache open-source database technology, spans its database technology in a fully distributed way, across private data centers and the cloud to power this landscape.

It is one of the leading NoSQL vendors providing fault-tolerant distributed databases to 200+ customers including Netflix, Adobe, HP, eBay and Twitter. Additionally, DataStax supplies OpsCenter for visual management and monitoring, along with expert support, training, and consulting services for Hadoop, Cassandra, and Solr. SAP and DataStax are working together to bring their joint capabilities to the enterprise.

The integration of the technologies is delivered for 2 scenarios:

  1. SAP HANA SPS09 supports DataStax Enterprise 4.5

SAP’s in-memory SAP HANA platform is integrated with DataStax to enable applications and interactive analysis across corporate applications data & operational data with content from Internet of Things, messaging or stream data stored on DataStax.

This integration is delivered via SAP HANA smart data access (SDA) that makes it possible to access data from DataStax remotely, without moving data into SAP HANA. SAP HANA handles the data like a local virtual table performing automatic data type conversions and push-down processing.

The combined capability means that customers can use SAP HANA’s “speed of thought” analytics on millions of transactions per second data coming into DataStax. It also simplifies the landscape by processing data where it resides instead of performing costly and time-consuming data movement.

SDA already supports many different data sources such as: SAP IQ, SAP ASE, Spark, Teradata, Apache Hadoop, Oracle, SQLServer providing a comprehensive selection for its customers’ needs.

DSE 4.5 HANA.jpg

SAP HANA is a high-performance in-memory columnar database which performs OLTP and OLAP on the same platform.

It provides in-database native support for advanced analytics like predictive, text analysis, spatial and graph processing. The platform is the leading choice of more than 4000+ customers and 1700+ startups.

DataStax Enterprise (DSE), built on Apache Cassandra™, delivers what Internet Enterprises need to compete in today’s high-speed, always-on data economy. DataStax Enterprise is the leading distributed database choice for online applications that require fast performance with no downtime.

DataStax Enterprise 4.5 encapsulates a distributed peer-to-peer architecture in which all nodes are equal, ensuring cluster resilience to an arbitrary number of node or data center failures.

Architecturally, SAP HANA’s smart data Access Component connects to DataStax Analytics with Spark/Shark through the ODBC driver. The resultant data set is treated as a remote table in HANA and it can be used as the input for all advanced analytics functionalities in HANA, which includes modeling views, SQL Script procedures, predictive, text analytics and so on.

The joint capabilities of SAP HANA and DataStax are as follows:

Always On

  • Zero downtime. Ever.
  • 100% availability for mission-critical applications


  • High throughput
  • Low latency

Advanced Analytics

  • Intuitive interfaces make it easy to explore transactional data in real time

No Complex Data Migration or ETL

  • Transactional data is immediately available to SAP Applications

Integrate with SAP Ecosystem

  • Use existing SAP workflows and BI tools

2. SAP’s Agile BI Platform,SAP Lumira, supports DataStax

We have also completed the integration with SAP Lumira in order for customers to view Datastax data in Lumira Data Visualizations and Storyboards.

DSE 4.5 Lumira.jpg

The DataStax Enterprise Sample Connector Template for SAP Lumira makes it easy to integrate DataStax data with numerous other data sources to allow business users to analyze data and get insights in real-time You can download the DataStax Connector Template for SAP Lumira from the SAP HANA Marketplace under this link:

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo John Barton
      John Barton

      A warm welcome to Cassandra which is now accessible to HANA as a Smart Data Access (SDA) source. Nice work!

      Author's profile photo Steffen Krause
      Steffen Krause

      Thanks for this article!

      Where can I find information on how to install the Simba ODBC driver that is mentioned in the attachment? It refers to a technical requirements chapter which  I can't locate.

      Many thanks!