bas-enc-hana-conn

0.0.7 • Public • Published

Create a new Encrypted HANA Connection inside SAP Business Application Studio

Description

This command line tool prompts the user to accomplish the following. It should be enhanced to detect the details and edit the prefs for the user automatically.

mkdir -p ~/.ssl ; cd ~/.ssl ; wget https://dl.cacerts.digicert.com/DigiCertGlobalRootCA.crt ; openssl x509 -inform der -in DigiCertGlobalRootCA.crt -out ~/.ssl/DigiCertGlobalRootCA.pem ; cd ~

Go to File-Settings-Open Preferences. Find the sqltools.connections element and replace it with this.

"sqltools.connections": [
  {
     "dialect": "SAPHana",
     "port": 20217,
     "server": "zeus.hana.prod.us-east-1.whitney.dbaas.ondemand.com",
     "name": "HANA_Encrypted",
     "database": "BECT_DB",
     "username": "BECT_DB_6USCB41HPEXXDTM6VYZ32LQS1_RT",
     "password": "Zt5ZszJ32zMgeXu2wEY44bSFLG.Gm_6nM2HdaVIIlLGltpaOL9UCMGnl0bvmptg--V9CvocYuE2BHGVi9WcN34zbigLXegStkNsSDqYtmGeXlxMvBkJldUMo9RAHkv0P",
     "hanaOptions": {
         "encrypt": true,
         "sslValidateCertificate": true,
         "sslCryptoProvider": "openssl",
         "sslTrustStore": "/home/user/.ssl/DigiCertGlobalRootCA.pem"
      },
      "isActive": false,
      "isConnected": false
  }
]

Requirements / Download and Installation

npm config set @sap:registry=https://npm.sap.com
git clone https://github.com/andrewlunde/bas-encrypted-hana-connection
  • Run NPM install from the root of the hana-developer-cli-tool-example project you just cloned to download dependencies
npm install
npm link

Or if you would rather just access the tool directly, it is now available in npm directly. You can install via:

npm install -g bas-enc-hana-conn

Security

Examples

How to obtain support

This project is provided "as-is": there is no guarantee that raised issues will be answered or addressed in future releases.

License

Copyright (c) 2020 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, v. 2 except as noted otherwise in the LICENSE file.

Package Sidebar

Install

npm i bas-enc-hana-conn

Weekly Downloads

3

Version

0.0.7

License

SEE LICENSE IN LICENSE

Unpacked Size

17.8 kB

Total Files

6

Last publish

Collaborators

  • alunde