Kiuwan supports extracting code from SAP/HANA Cloud database. This guide describes how to extract the code from the cloud database into local files, where it can then be analyzed using Kiuwan Local Analyzer.
Configuration
- Download and unzip the Kiuwan Local Analyzer.
- Open the extracted folder.
-
Important: Perform one of these steps to update Kiuwan Local Analyzer:
- From a terminal window in the KiuwanLocalAnalyzer\ directory, run kiuwan.cmd (on Windows) or kiuwan.sh (on Mac/Unix)to launch the Kiuwan Local Analyzer GUI and log in. You MUST Log into Kiuwan Local Analyzer GUI.
- From a terminal window in the KiuwanLocalAnalyzer\bin directory, run agent.cmd --update (on Windows), or agent.sh --update (on Linux/MacOS)
- If you launched the GUI in step 3, close it after the updates complete.
- Navigate to the folder .\KiuwanLocalAnalyzer\lib.engine. Ensure the file ngdbc.jar exists in this folder.
Script Parameters
| Parameter | Expected Value | Example |
| url | jdbc:sap://<SAP HANA SQL Endpoint>/?encrypt=true&validateCertificate=true | jdbc:sap://8dedf199-8938-4784-adcf-43b16e7974c6.hana.trial-us10.hanacloud.onde mand.com:443/?encrypt=true&validateCertificate=true |
| user | SAP database username | DBADMIN |
| pass | Password for the database user | adminxyz123 |
| type | This should be ‘CLOUD’ always | CLOUD |
| dir |
Output directory for the extraction (This directory MUST exist) |
D:\Work\SAP-HANA\Results |
| table | Table name | REPOSRC |
Script execution
Note: The following examples show commands for Windows. On Unix systems (including MacOS), use agent.sh instead of agent.cmd.
- Navigate to the following directory <KiuwanLocalAnalyzer>\bin
- Open this directory in the console.
-
Insert the following command:
agent.cmd url="jdbc:sap://*SQL Endpoint*/?encrypt=true&validateCertificate=true" user="DBADMIN" pass="*password*" type="CLOUD" dir="*directory to save file*" table="REPOSRC"Example:
agent.cmd url="jdbc:sap://8dedf199-8938-4784-adcf-43b16e7974c6.hana.trial-us10.hanacloud.onde mand.com:443/?encrypt=true&validateCertificate=true" user="DBADMIN" pass="pass1234" type="CLOUD" dir="D:\Work\Kiuwan\Kiuwan-SAP\cmd" table="REPOSRC" - Press Enter and execute the command.
Successful Execution
Note: If the following error appears, it can be ignored:
"ERROR: The following options are required in command line mode without user input enabled: --sourcePath (-s), --softwareName (-n)"
You should see the following output if all steps were followed correctly and the command executed successfully.
Windows
Unix/MacOS