In this blog post, I will show you how you can fast start with developing custom HANA adapters in JAVA.
- S-User is required to download data provisioning agent: https://launchpad.support.sap.com/#/softwarecenter/template/products/%20_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=Y&FUNCTIONBAR=N&EVENT=TREE&NE=NAVIGATE&ENR=73555000100200005999&V=MAINT&TA=ACTUAL&PAGE=SEARCH/HANA%20DP%20AGENT%202.0 I downloaded the Linux version, but windows should work too (I’m on Mac OS).
- I will proceed in SAP Hana Studio because Eclipse is missing some packages. If you don’t have SAP Hana Studio, please check: https://launchpad.support.sap.com/#/softwarecenter/template/products/%20_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=Y&FUNCTIONBAR=N&EVENT=TREE&NE=NAVIGATE&ENR=73554900100200000585&V=MAINT&TA=ACTUAL&PAGE=SEARCH/SAP%20HANA%20STUDIO%202
- Download missing plugins: https://mvnrepository.com/artifact/javax.xml.bind/jaxb-api/2.3.0 https://mvnrepository.com/artifact/com.sun.xml.bind/jaxb-impl/2.3.3 and put into the plugins folder
- Unpack dpagent.tar.gz
- Run Hana Studio and go to the Help -> Install new Software. Then click on Add, Local and choose patch to UI folder from extracted DPAGENT.TGZ
- Install the plugin.
- Create a hello world adapter. Change perspective to Plug-in development. Click on File->New->Plugin Project.
- Check to Generate an activator flag.
- Right-click on the project, Debug As ->Debug Configurations
- Unselect Target Platform and click on Add Required Bundles
- Select org.eclipse.equinox.console and com.sap.hana.dpagent. Next click on Add Required Bundles
Click on Apply, then Debug. When this is finished, everything should work perfectly. Now we can use dplogin to deploy plugin into your Hana system. If you are using HANA Express, dpagent can be activated on HXE instance from SYSTEM connection by:
ALTER DATABASE HXE ADD 'dpserver'
And finally, you should be able to use it in Hana 🙂
Good article on SAP Blog regarding this topic: https://blogs.sap.com/2015/08/26/hana-adapter-sdk-the-adapter-code/