Skip to Content
Technical Articles
Author's profile photo Jascha Kanngiesser

@sap/dwc-cli: Command-Line Interface for SAP Data Warehouse Cloud: Overview

Introduction

The Node.js-based Command-Line Interface (CLI) for SAP Data Warehouse Cloud, @sap/dwc-cli hosted on npmjs.com, allows you to interact with your SAP Data Warehouse Cloud tenant from the terminal or command line. 

In this blog post, I’m summarizing all blogs I’ve published so far on this topic. This blog is your entry point to working with the CLI, and stay informed about new blogs which are published on this topic.

Overview

The list of blog posts is sorted by date in descending order. The newest post is listed on top.

Conclusion

I’d be happy to hear your thoughts, ideas, and comments on this tool and what you think would be a nice-to-have enhancement to the CLI, making your life and work with SAP Data Warehouse Cloud easier. Let me know in the comments!

Further Reading

Command-Line Interface for SAP Data Warehouse Cloud on npmjs.com

Command-Line Interface for SAP Data Warehouse Cloud on SAP Help

Get your SAP Data Warehouse Cloud 30 Days Trial Account

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Young Seol Sohn
      Young Seol Sohn

      Hi Jascha,

      Thank you very much for this useful documentation. I have one suggestion for you.

      It would be nice to be able to run or schedule a table replication or data flow using CLI or API. A customer's desired scenario is that when a specific job finishes on the source system, a follow-up job runs on the DWC.

      Do you have any support plans for these features?

      Thank you,

      Youngseol

      Author's profile photo Jascha Kanngiesser
      Jascha Kanngiesser
      Blog Post Author

      Hi Young Seol Sohn

      thanks for your comment! 🙂 We have this on the radar, but I cannot communicate any specific version yet, unfortunately.

      Regards,
      Jascha

      Author's profile photo Xavier Polo
      Xavier Polo

      Hi Jascha Kanngiesser ,

      My two cents

      - Support for the "Bussines Layer", I hope that when the Business Builder adds the option to export, dwc-cli will also be able to work with these objects. If not, at least give the option to extract something from the metadata, like dependencies.

      - Extend the file size limit: currently I can export a space (json > 80MB), but I can't recreate it because it fails to import because of this limitation (25MB).

      - Improve the login system, having to use RPA to automate a command line program is a bit extreme 🙂

      - Incorporate existing services in DWC: There are many services like impact and lineage that are implemented through a web service, and I think it would not cost too much to incorporate them into the client tool.

       

      Regards,

      Author's profile photo Jascha Kanngiesser
      Jascha Kanngiesser
      Blog Post Author

      Hi Xavier Polo re "Improve the login system" I just published https://blogs.sap.com/2022/09/21/sap-dwc-cli-getting-rid-of-passcodes-thanks-to-oauth-client-support/. Check it out and let me know your thoughts!

      Author's profile photo Xavier Polo
      Xavier Polo

      You made my day 🎉

      Thanks!