Skip to Content
Where to Place the Custom Adapter Files

Where to Place the Custom Adapter Files

Intermediate
15 min.
SAP HANA streaming analytics, Intermediate, Internet of Things, SAP HANA, express edition, Tutorial
Place the files we have created and edited for our Custom Adapter in the correct directory.
You will learn
  • Where to place the Custom Adapter Files on the server
  • Where to place the Custom Adapter Files on the client
  • How to access your Custom Adapter in HANA Studio

Prerequisites

The files for the custom adapter include the:

  • mqtt-input.jar and org.eclipse.paho.client.mqttv3-<version>.jar files
  • adapter_config.xml file
  • mqtt_input.cnxml file
  • edited versions of the modulesdefine.xml, custommodulesdefine.xml, and parametersdefine.xsd files

The directory paths for these files will be relative to the STREAMING_HOME and STREAMING_CUSTOM_ADAPTERS_HOME environment variables. The streaming home environment variables are %STREAMING_HOME% and %STREAMING_CUSTOM_ADAPTERS_HOME%for Windows, and $STREAMING_HOME and $STREAMING_CUSTOM_ADAPTERS_HOME for Unix operating systems (please edit the below paths according to your intention). The rest of the directory path relative to the STREAMING_HOME environment variable is the same on both Linux and Windows.

  • Step 1

    Assuming you used the default install location, then the local Windows Streaming Analytics $STREAMING_HOME will be 

    <Hana Studio installation location>\plugins\com.sybase.cep.studio.native.bins_<version>.<timestamp>
    and the $STREAMING_CUSTOM_ADAPTERS_HOME will be 

    <Hana Studio installation location>\plugins\com.sybase.cep.studio.native.bins_<version>.<timestamp>\adapters\framework
    relative to your IDE’s directory.

    Files New Path
    mqtt-input.jar
    org.eclipse.paho.client.mqttv3-<version>.jar    		$STREAMING_CUSTOM_ADAPTERS_HOME/libj
    adapter_config.xml $STREAMING_HOME/adapters/framework/instances/mqtt_input
    Note: You will need to create the mqtt_input folder
    mqtt_input.cnxml $STREAMING_HOME/lib/adapters
    modulesdefine.xml $STREAMING_HOME/adapters/framework/config
    custommodulesdefine.xml
    parametersdefine.xsd     		$STREAMING_CUSTOM_ADAPTERS_HOME /config
  • Step 2

    To check the $STREAMING_HOME environment variable make sure that you’re connected as the <sidadm> user, and use the echo command “echo $STREAMING_HOME”.

    IMPORTANT! Since you’re running a multidb SAP HANA environment, $STREAMING_CUSTOM_ADAPTERS_HOME will refer to 

     /hana/shared/<SID>/streaming/cluster/<tenant db>/adapters
    assuming you have used the default location of /hana as the root directory for the installation.

    Files New Path
    mqtt-input.jar
    org.eclipse.paho.client.mqttv3-<version>.jar    		$STREAMING_CUSTOM_ADAPTERS_HOME/libj
    adapter_config.xml $STREAMING_HOME/adapters/framework/instances/mqtt_input
    Note: You will need to create the mqtt_input folder
    mqtt_input.cnxml $STREAMING_CUSTOM_ADAPTERS_HOME/cnxml
    modulesdefine.xml $STREAMING_HOME/adapters/framework/config
    custommodulesdefine.xml
    parametersdefine.xsd     		$STREAMING_CUSTOM_ADAPTERS_HOME /config

    For the question below, select the correct answer, and click Validate.

    Which user should you be connected as, to check the $STREAMING_HOME environment variable?

  • Step 3

    If you have placed your mqtt_input.cnxml file in the correct location, you will be able to see your custom input adapter in the Input Adapters drawer in the palette.

    Create a new Streaming Project using the Streaming Analytics plugin. Use the ccl code provided below for the project shown in the screenshot.

    Custom Adapter Streaming Project
    SQL
    Copy

    CREATE INPUT WINDOW InputWindow1 SCHEMA ( Message string )
PRIMARY KEY ( Message ) KEEP ALL ROWS ;

ATTACH INPUT ADAPTER MQTT_Input_Adapter1
TYPE mqtt_input TO InputWindow1
PROPERTIES  mosquittoServerAddress = 'tcp://<your-ip-address>:1883' ,
topic = 'test' ;

    Click the Done button below once you have completed this tutorial.

Back to Top
Back to top