sap-datasphere-exhibitor
v0.0.2
Published
Wrapper for `@sap/datasphere-cli` designed for exposing remote schema objects into SAP Datasphere repository.
Downloads
130
Readme
Wrapper for @sap/datasphere-cli designed for exposing remote schema objects into SAP Datasphere repository.
- Prerequisites. Fulfill the prerequisites as described in this [blog post](https://community.sap.com/t5/technology-blogs-by-sap/
sap-datasphere-view-generation-with-python-and-the-command-line-interface/ba-p/13558181) (bullets 1-4):
- Install Node.js & NPM
- Install SAP Datasphere CLI
npm install -g @sap/datasphere-cli
- Successfully accomplish
datasphere login
procedure (follow this guideline) - Create Database Analysis User
- Install
npm install -g @sap/datasphere-exhibitor
- Prepare configuration JSON file with SAP HANA Client connection options, put Database Analysis User connection details into it, example:
{
"host": "00000000-0000-0000-0000-000000000000.hana.prod-xx00.hanacloud.ondemand.com",
"port": "443",
"uid": "DWCDBUSER#TEST",
"pwd": "Password123"
}
- Save it as file, eg.:
options.json
- Run
datasphere-exhibitor
command, example:
datasphere-exhibitor remote-view-to-local-table --space SPACE_ID --schema CONTAINER_NAME --connection-file ./options.json --artifact XYZ
datasphere-exhibitor remote-view-to-fact-view --space SPACE_ID --schema CONTAINER_NAME --connection-file ./options.json --artifact XYZ --measures FIELD:SUM
- Other options and descriptions of commands and arguments can be obtained by:
datasphere-exhibitor --help
datasphere-exhibitor remote-view-to-fact-view --help