Manually cleanse data in DS or Hana

[Former Member]

Hi All,

lets assume, that you have some validation in DS but you cannot correct the incomnig data along automatical rules, so you load the failed data into a SAP Hana "failed" table. Is there any platform/interface (either in SAP Hana or DS or in any BO product) that lets you manually correct the data in a given field? ...something like SM30 for example?

Thanks for any advice,

David.

[Former Member]

Hello

It sounds like you need a simple editing tool - there are many free/open ones available that could connect to SAP HANA using ODBC, JDBC or ADO.NET.  However, for a more feature rich tool check out SAP's partners like BackOffice Associates, or you could write your own using the SAP HANA XS Engine.

Michael

[Former Member]

Thanks for the answer Michael!

I knew of this options but it sounds a bit dodgy that SAP does not provide any solution for that in its BO palette...

What I was looking for is a general way of how to cleanse manually data in the process of data loading into Hana. Building a custom app sounds way complicated with users, logging, etc.

Would you share which free/open ones are good for this?

Thanks,

David.