HPE Ezmeral Data Fabric 6.1.x is In Maintenance and transitions to "End of Maintenance" in June 2024. Please see the latest documentation.

About MapR 6.1
This site contains the main documentation for Version 6.1 of the MapR Converged Data Platform, including installation, configuration, administration, and reference information.
6.1 Installation
This section contains information about installing and upgrading MapR software. It also contains information about how to migrate data and applications from an Apache Hadoop cluster to a MapR cluster.
6.1 MapR Data Platform
MapR Data Platform is the industry-leading data platform for AI and analytics that solves enterprise business needs.
6.1 Administration
This section describes how to manage the nodes and services that make up a cluster.
6.1 Development
This section contains information related to application development for Ezmeral ecosystem components and MapR Data Platform products, including the file system, Database (Key-Value and JSON), and Event Streams.
- Application Development Process
  Before you start developing applications on the MapR Data Platform platform, consider how you will get the data into the platform, the storage format of the data, the type of processing or modeling that is required, and how the data will be accessed.
- MapR XD and Apps
  The following sections provide information about accessing the MapR XD with C and Java applications.
- MapR Database and Apps
  This section contains information about developing client applications for JSON and key-value tables.
- MapR Event Store For Apache Kafka and Apps
  MapR Event Store For Apache Kafka brings integrated publish and subscribe messaging to MapR Data Platform.
- MapReduce and Apps
  This section contains information associated with developing YARN applications.
- MapR Data Science Refinery
  The MapR Data Science Refinery product is an easy-to-deploy and scalable data science toolkit with native access to all platform assets and superior out-of-the-box security.
- MapR Data Fabric for Kubernetes
  This section describes how to leverage the capabilities of the MapR Data Fabric for Kubernetes.
- Ecosystem Components
  The following sections provide information about each open-source project that is supported by the MapR Data Platform.
  - Ezmeral Ecosystem Packs
  - AsyncHBase
  - Cascading
  - Apache Drill
  - Flume
  - HBase
  - HBase Client and MapR Database Binary Tables
  - HCatalog
  - Hive
  - HttpFS
  - Hue
  - Impala
  - Livy
    Apache Livy is primarily used to provide integration between Hue and Spark.
  - MapR Event Store For Apache Kafka Clients and Tools
    Describes the supported MapR Event Store For Apache Kafka tools and clients.
    - KSQL
      KSQL is an open-source streaming SQL engine that implements continuous, interactive queries.
    - Kafka Streams
      Kafka Streams is a programming library used for creating Java or Scala streaming applications and, specifically, building streaming applications that transform input topics into output topics.
    - Kafka REST Proxy
      The Kafka REST Proxy provides a RESTful interface to MapR Event Store For Apache Kafka clusters to consume and produce messages and to perform administrative operations.
    - Kafka Connect
      Kafka Connect is a utility for streaming data between MapR Event Store For Apache Kafka and other storage systems.
      - Architecture of Kafka Connect
        Kafka Connect for MapR Event Store For Apache Kafka has the following major models in its design: connector, worker, and data.
      - Connectors, Tasks, and Workers
        Describes how Kafka Connect for MapR Event Store For Apache Kafka works and how connectors, tasks, offsets, and workers are associated.
      - Connector Configuration
        This section describes how and where connectors are configured.
      - Worker Configuration
        This section describes how and where to configure workers.
      - JDBC Connector
        The topics describes the JDBC connector, drivers, and configuration parameters.
        JDBC Driver
        Kafka Connect for MapR Event Store For Apache Kafka provides a JDBC driver jar along with the connector configuration.
        JDBC Configuration Options
        Use the following parameters to configure the Kafka Connect for MapR Event Store For Apache Kafka JDBC connector; they are modified in the quickstart-sqlite.properties file.
        Whitelists and Custom Query JDBC Examples
        This section provides common usage scenarios using whitelists and custom queries.
        Streaming Data JDBC Examples
        This section provides common usage scenarios of streaming data between different databases to or from MapR Event Store For Apache Kafka.
      - Managing Kafka Connect Services
        Lists the commands you use to start, stop, or restart Kafka Connect Services
      - HDFS Connector
        These topics describe the Kafka Connect for MapR Event Store For Apache Kafka HDFS connector, driver, and configuration parameters.
      - REST API
        The Kafka Connect REST API for MapR Event Store For Apache Kafka manages connectors.
      - Saving Kafka Connect Configurations
        Describes how Kafka Connect configurations are saved during an upgrade.
    - Kafka Schema Registry
      Kafka Schema Registry provides a RESTful interface for storing and retrieving schemas.
    - Structured Streaming in Spark
      Starting in EEP 5.0.0, structured streaming is supported in Spark.
  - S3 Gateway
    The S3 gateway is a service that provides an S3-compatible interface to expose data in MapR Data Platform as objects. The S3 gateway manages all inbound S3 API requests to put data into and get data out of cloud storage.
  - Myriad
  - Oozie
  - Pig
  - Sentry
  - Apache Spark
  - Sqoop
  - YARN
  - Zeppelin
- Maven and MapR
  This section discusses topics associated with Maven and MapR.
- Developer's Reference
  This section contains in-depth information for the developer.
- API Documentation
  MapR Data Platform supports public APIs for MapR File System, MapR Database, and MapR Event Store For Apache Kafka. These APIs are available for application-development purposes.
Other Docs
This section contains release-independent information, including: MapR Installer documentation, Ecosystem release notes, interoperability matrices, security vulnerabilities, and links to other MapR version documentation.
Glossary
Definitions for commonly used terms in MapR Converged Data Platform environments.

JDBC Connector

The topics describes the JDBC connector, drivers, and configuration parameters.

The JDBC connector allows you to import data from any relational database into MapR Event Store For Apache Kafka and export data from MapR Event Store For Apache Kafka to any relational database with a JDBC driver. By using JDBC, this connector can support a wide variety of databases without requiring custom code for each one.

The JDBC connector provides flexibility regarding which databases you can import data from and how that data is imported. JDBC connector implements the data copying functionality on the generic JDBC APIs, and relies on JDBC drivers to handle the database-specific implementation of those APIs.

The supported relational databases include:

MySQL
Oracle
PostgreSQL
SQLite
SQL Server
Hive is supported for the JDBC Source Connector