# bas-enc-hana-conn

> Create a new Encrypted HANA Connection inside SAP Business Application Studio

Latest version **0.0.7** (published 2020-04-14) · SEE LICENSE IN LICENSE license · 0 weekly downloads

## Install

```sh
npm install bas-enc-hana-conn
pnpm add bas-enc-hana-conn
yarn add bas-enc-hana-conn
bun add bas-enc-hana-conn
```

Provides the command `enc-hana-conn`.

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.0.7 |
| Published | 2020-04-14 |
| First published | 2020-04-14 |
| Weekly downloads | 0 |
| License | SEE LICENSE IN LICENSE |
| TypeScript types | none |
| Module format | CommonJS |
| Node | >=10.x |
| Dependencies | 1 |
| Unpacked size | 17.4 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 0 |
| Author | SAP |
| Maintainers | alunde |
| Keywords | hana, bas, sap, business application studio |

## Links

- npm: https://www.npmjs.com/package/bas-enc-hana-conn
- Repository: https://github.com/andrewlunde/bas-encrypted-hana-connection
- Homepage: https://github.com/andrewlunde/bas-encrypted-hana-connection/
- Issues: https://github.com/andrewlunde/bas-encrypted-hana-connection/issues
- npm.io page: https://npm.io/package/bas-enc-hana-conn

## Dependencies (1)

- [@sap/xsenv](https://npm.io/package/@sap/xsenv.md) ^2.2

## Alternatives

- [flatbuffers](https://npm.io/package/flatbuffers.md) — 6.0M weekly downloads
- [jwt-simple](https://npm.io/package/jwt-simple.md) — 259.5K weekly downloads
- [@exodus/patch-broken-hermes-typed-arrays](https://npm.io/package/@exodus/patch-broken-hermes-typed-arrays.md) — 28.5K weekly downloads
- [@native-to-anchor/buffer-layout](https://npm.io/package/@native-to-anchor/buffer-layout.md) — 12.2K weekly downloads
- [binary-parser-encoder](https://npm.io/package/binary-parser-encoder.md) — 5.3K weekly downloads

## Recent versions

- 0.0.7 (latest) — 2020-04-14
- 0.0.6 — 2020-04-14
- 0.0.5 — 2020-04-14
- 0.0.4 — 2020-04-14
- 0.0.2 — 2020-04-14
- 0.0.1 — 2020-04-14

## README

# 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/](https://nodejs.org/en/download/)

* Add the SAP Registry to your NPM configuration

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

* Clone the repository from [https://https://github.com/andrewlunde/bas-encrypted-hana-connection](https://github.com/andrewlunde/bas-encrypted-hana-connection)

```shell
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

```shell
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](https://docs.npmjs.com/cli/link)

```shell
npm link
```

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

```shell
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](LICENSE) file.

---
_Source: https://npm.io/package/bas-enc-hana-conn · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._