SAP HANA JDBC commands
AnsweredI'm new to Workiva. After executing successfully the chain using "Execute Query" Command in SAP HANA JDBC Bizapp I was expecting the CVC file to be generated, but this didn't happen. I can see the recorded retrieved in the logs preview. So,
1. To get Detail information from SAP Source system( Example Trial balance) Which command should I use? A
2.. Which command I should use to retrieved data from SAP source system and create tables/ spreadsheet automatically in WData?
-
Hello Molla,
A successful run of the Execute query command will output a CSV file of the results. With the "Preview results" checkbox enabled, the LOGS tab of the command will show a preview of the results and the OUTPUT tab will show the temporary CSV file containing the results.
1. You can use the commands Execute query command (and/or Execute SQL) to retrieve data.
2. The output of the SAP command can be passed into the Workiva commands to save the results in a table or spreadsheet. For loading the results into an existing table with the appropriate schema, have a look at the Create file and Import file into table commands as well as the Update Datasets in a Table chain template. For loading the data into a Spreadsheet, please review the commands Overwrite sheet data and Write sheet data.
0Please sign in to leave a comment.
Comments
1 comment