ISV solution ecosystem for Hortonworks on IBM Power Systems
Enhance Hortonworks Data Platform (HDP) with a variety of ISV solution capabilities
Independent software vendor (ISV) data-related solutions commonly integrate with big data environments (for example, Apache Hadoop or Spark) to leverage data or analytic processing power. Many data software solutions provide a unique value-add by enhancing or augmenting Hadoop capabilities. The capabilities of the solutions span a broad spectrum of features such as facilitating fast data ingestion, improving data quality, moving data within a larger data lake environment, or accessing Hadoop data for analysis and visualization within existing BI dashboards and reports. Some solutions are designed to simply connect to Hadoop environments while others are architected to run directly on one or more of the Hadoop nodes (for example, management, data, or edge nodes).
This article documents a set of ISV data-related solutions that integrate with HDP running on Linux® on IBM® Power Systems™. The solutions listed here are those that IBM or the ISV has tested and do not represent all solutions available for this environment. As this ecosystem of solutions grows over time, this article will be updated on a regular basis.
ISV solutions that connect to HDP
Each of the following use cases show at least one ISV solution that provides the necessary capabilities. The solutions in this section are configured to connect to HDP running on Linux on Power, but don't run their software on the HDP cluster.
Advanced analytics solutions
The following use case (listed in Table 1) augment HDP by providing some form of advanced analytics capabilities.
Use case: Access data in HDP for use in analytics
This is useful to extend existing analytics environment on Power Systems to leverage data in HDP.
Table 1: Solutions that access data in HDP for use in analytics
|Solution||Tested by||Reference||ISV website|
|SAP HANA with SAP HANA Spark Controller||IBM with assistance from SAP||SAP HANA and Hortonworks Data Platform (HDP) integration with SAP HANA Spark Controller running on IBM Power Systems||https://www.sap.com/products/hana.html|
|Base SAS with SAS/ACCESS Interface for Hadoop||IBM with assistance from SAS||SAS software with Hortonworks Data Platform (HDP)
running on IBM POWER8||https://www.sas.com/en_us/software/base-sas.html|
Business intelligence solutions
The following use case (listed in Table 2) augments HDP by providing business intelligence capabilities such as data visualization, reporting, or dashboards.
Use case: Access data in HDP and visualize
Table 2: Solutions that access data in HDP and visualize
|Solution||Tested by||ISV website|
|Qlik Sense||IBM with assistance from Qlik||https://www.qlik.com/us/products/qlik-sense|
Enterprise data warehouse (EDW) and extract, transform, and load (ETL) solutions
The following use cases (listed in Table 3) augment HDP by providing enterprise data warehouse capabilities.
Table 3: Solutions that connect or move data in various data sources to HDP
|Use case||Solution||Tested by||Reference|
|Accelerate data replication with agentless bulk and incremental loading (with change data capture) of data from Oracle database on IBM AIX, or other supported data sources, into Hive in HDP||Attunity Replicate||IBM with assistance from Attunity|| • Demo|
• ISV website
|Connect data between data sources on AIX and HDP||Progress DataDirect||Progress||ISV website|
|Move and bulk load of data from Oracle database on AIX into HDP||Oracle 12c Instant Client and Apache Sqoop||IBM||ISV website|
|Move data from many heterogeneous data sources to HDP||Veristorm
vStorm Enterprise||IBM with assistance from Veristorm||ISV website|
|Extract data from a supported data source, transform it, and load it into HDP||Paxata Adaptive Information Platform||Paxata||ISV website|
The following use case augments HDP by providing security capabilities.
Use case: Encrypt and protect data on HDP data nodes
Zettaset Big Data Encryption Suite:
- The solution was tested by IBM with assistance from Zettaset.
- Read more details in the IBM Power Systems and Zettaset Big Data Encryption Suite solution brief.
- Read more about the solution on the ISV website.
There are many ISV solutions that support Hadoop and integrate with HDP regardless of the platform on which HDP runs. These solutions can be used in production environments today with HDP running on Linux on Power. As we test specific solutions across a number of use cases, we will update this article so you know which solutions we've actually tested. In addition, there are other solutions that run natively on the HDP cluster and need to be tested or ported to work with HDP on IBM Power Systems. We continue to work with many partners to complete this work and will document those solutions in this article as the ecosystem grows.
- Hortonworks on Power
- Hortonworks - IBM Partnership
- Hortonworks Data Platform on IBM Power Systems
- Hortonworks Data Platform on IBM Power - Reference Architecture and Design - Version 1.0