HANA Output Adapter Tips
While performing some testing, which required the use of a HANA Output adapter, I came across a few common configuration issues. This blog is intended to help other users who may be setting up a HANA output adapter for the first time. Note that the full documentation for the HANA Output adapter is available here.
Note: the smart data streaming window attached to the adapter will be referred to as the “feeding object”, as it feeds data to the output table.
- Check that the login credentials are correct.
- In the left panel, beside the “Project Explorer” tab, click on the “Data Services” tab.
- Click on the data service you are using in your project. This is shown in the image to the right
- In the “Properties” panel at the bottom of HANA Studio, check that the “User*” and “Password*” fields are correct
- Check that the object feeding the HANA Output adapter is consistent with the table being outputted to. If a Field Mapping has not been specified,
- Check that the same number of columns exist in the feeding object and the output table
- Check that the column names of the feeding object schema and output table are identical (case sensitive)
- Check that the order of the columns in the feeding object schema is identical to that of the output table
- If you have specified a Field Mapping and the Data Warehouse Mode property is off, ensure that you have included a mapping for at least one column of the primary key of the feeding object. Without mapping at least one primary key column, the adapter will fail to start.
- To find potential HANA Output adapter runtime errors (assuming the project compiles successfully):
- Log files could also be useful for finding runtime errors:
- Go to the SAP HANA Administration Console perspective
- Under the “Systems” tab, double click the system you are working with
- Click on the “Diagnosis Files” tab
- You may need to scroll down to view the most recent log files
- Trace, log and out files reside here and can be viewed by double clicking