This post is part of an entire series

Hana Smart Data Integration – Overview

In order to write new Adapters three things are needed

  1. A Hana instance with the Data Provisioning Server turned on
  2. Eclipse or Hana Studio (preferred)
  3. The Adapter SDK plugin for Eclipse/Hana Studio

Enabling the DPServer in the Hana Instance

The first step is done as database administrator by opening the Administration screen of the Hana instance.

adapter sdk setup 1.png

In case the dpserver does not show up there, the configuration tab allows to turn it on (Hana SPS09 or higher).

adapter sdk setup 2.png

Eclipse or Hana Studio

If Java SDK 1.7 is installed, the Hana Studio allows to open the Java perspective to develop new Java programs. The Adapter is just yet another Java program based on a couple of interfaces and classes, the Adapter SDK.

The main advantage of using Hana Studio is that SQL commands can be sent to Hana and breakpoints within the adapter being defined in one application. But nothing wrong in using a plain Eclipse installation instead.

Adding the Eclipse Plugin for the Adapter SDK

Currently the Adapter SDK is part of the data provisioning agent download, found in service marketplace.

There the various versions for the different Hana releases can be found, the last line is for the latest Hana revision – here Hana SPS10 with the matching SDI 1.00.01 version.

adapter sdk setup 3.png

After uncompressing the downloaded SAR file and running the hdbsetup.exe file, a target directory is to be defined and other settings in the next screen.

NOTE: After the installation locate the Agent and disable it permanently. We do not want to use the agent with preconfigured adapters, but as part of the development environment.

adapter sdk setup 4.png

With all components available in this directory, the Adapter SDK can be installed from the “ui” subdirectory, in above installation the c:\apps\dataprovagent\ui folder.

In Eclipse or Hana Studio, the menu item Help -> Install New Software, allows to add a local directory as new repository.

adapter sdk setup 5.png

In this “ui” directory the Data Provisioning Framework and can be selected for installation.

adapter sdk setup 6.png

Once this is installed and the application restarted, a new plugin project can be created, one per adapter. The details are described in the Adapter SDK document found in help.sap.com.

Create a Custom Adapter Using a New Plug-in Project – SAP HANA Data Provisioning Adapter SDK – SAP Library

It says there:

Procedure

  1. In SAP HANA studio, open the Plug-in Development perspective (Start of the navigation path Window Next navigation step Open Perspective Next navigation step Other Next navigation step Plug-in Development End of the navigation path).
  2. Right-click in the Package Explorer white space and select Start of the navigation path New Next navigation step Plug-in Project End of the navigation path.
  3. Enter a project name such as HelloWorldAdapter.
  4. For Target Platform, select an OSGi framework: Equinox and click Next.
  5. Optionally change the Execution Environment depending on your adapter code.
  6. In the Templates dialog, select Data Provisioning Adapter Wizard and click Finish.

In case the Data Provisioning Adapter Wizard is not shown in step 6, make sure the step 4 was done – setting the target platform to Equinox.

adapter sdk setup 7.png

The last step is to import the Adapter launch configuration, which is needed to start an adapter within Eclipse.

In the File -> Import dialog under the item Run/Debug a Launch Configuration can be imported from the same “ui” directory.

adapter sdk setup 8.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply