SAP HANA Export into CSV or HTML

[Former Member]

Hi everyone,

Being in the field of IT Audit, I have to prepare SQL Script to audit SAP HANA database but like our others scripts, I want to run multiple 'SELECT' statements and output them in single HTML file, which is possible via SQL*Plus in Oracle EBS.

Can you let me know, with a sample SQL script about how to export the results in CSV or HTML (preferable) from SQL in SAP HANA.

Currently, I am running my SQL Script from SAP HANA Studio. Also let me know, how to save my script in SDBSQL extension.

Regards

Ahmad Saleem

[lbreddemann]

Hello Ahmad,

Thank you for coming to the SAP Community for answers. However, before posting a question, please make sure you have searched all existing content -- as the answers may already be available.

Try to use these search options, too:

https://cse.google.com/cse/home?cx=013447253335410278659:5di2969x5we

https://www.google.com/cse/home?cx=013447253335410278659:k8ob9ipscwg

SAP Search

You can find more important guidelines in the community rules of engagement and learn questions and answers best practices here.

If you have searched for answers already, then apologies for making this request. In order to be on the safe side, please make sure your question outlines the steps you took while searching for your answer. This way, members will know that you searched and that you were unable to find the answer you were after. You may also want to include screenshots that best describes the topic that your question relates to.

In order to avoid duplication, I will remove this question for now. Please repost according to the guidelines provided above. In case you have any additional questions, please reach out to scnmoderators@sap.com

Thank you for your understanding.

Lars
SAP Community Moderator