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

• Install Node.js version 10.x or 12.x on your development machine https://nodejs.org/en/download/

• Add the SAP Registry to your NPM configuration

npm config set @sap:registry=https://npm.sap.com

• Clone the repository from https://https://github.com/andrewlunde/bas-encrypted-hana-connection

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

• Run NPM link from the cloned project root to make the enc-hana-conn command available from everywhere https://docs.npmjs.com/cli/link

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.