topic Re: How to RSA-OAEP encrypt credentials using Node js (not c# or PowerShell) in Developer

How to RSA-OAEP encrypt credentials using Node js (not c# or PowerShell)

dpiret — Mon, 23 Aug 2021 08:21:32 GMT

Hi there,

I need to create a data source on a gateway that connects to an on-premises SQL Server.

I have understood that I need to RSA-OAEP encrypt the credentials (Basic username/password), for which I've found examples in Power shell and in c# (Configure credentials programmatically for Power BI )

Is there any way to encrypt the credentials with Node or using an API-based third-party service?

Thanks!

Re: How to RSA-OAEP encrypt credentials using Node js (not c# or PowerShell)

lbendlin — Wed, 25 Aug 2021 00:57:21 GMT

node-forge?

RSA Encryption with OAEP between Java and JavaScript - Stack Overflow

Re: How to RSA-OAEP encrypt credentials using Node js (not c# or PowerShell)

Anonymous — Fri, 27 Aug 2021 09:10:25 GMT

Hi @dpiret ,

Please check the content of the following documents and we hope they will help you to achieve your needs.

An example of RSA Encryption implemented in Node.js

Implementing RSA Encryption and Signing in Node.js (With Examples)

(Node.js) RSA-OAEP with SHA256 hashing

Best Regards

Re: How to RSA-OAEP encrypt credentials using Node js (not c# or PowerShell)

dpiret — Mon, 30 Aug 2021 14:09:31 GMT

Thanks, @Anonymous I already tried but none worked for me.

Re: How to RSA-OAEP encrypt credentials using Node js (not c# or PowerShell)

dpiret — Mon, 30 Aug 2021 14:22:20 GMT

In case this helps anyone seekeing a solution for the sale problem, here's what I did.

I used a PowerShell script as described here https://endjin.com/blog/2020/12/how-to-update-credentials-for-an-on-prem-power-bi-data-source-using-powershell.html then executed ith with Node, retrieving the resulting JSON. The Node code looks like this

```javascript const { exec } = require('child_process'); const PShellScriptFile = './rsa-oeap-encrypt-credentials.ps1' const datasourceCredentialsEncryptedFile = "./datasourceCredentialsEncryptedFile.json" var username = "useNameHere" var password = "passwordHere" // WARNING. Gateway module is fixed and should go as param exec(`${PShellScriptFile} -username ${username} -password ${password} -outputFile ${datasourceCredentialsEncryptedFile}`, {'shell':'powershell.exe'}, (error, stdout, stderr)=> { // you can use stdout but I choose getting the JSON file already generated by the script }) ```

The outcome looks like this

{ "credentialDetails": { "encryptedConnection": "Encrypted", "credentialType": "Basic", "credentials": "oCvURzaedv3WNvV...lRQZ", "privacyLevel": "Private", "encryptionAlgorithm": "RSA-OAEP" } }

Which you can then use in Gateways - Create Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Docs