- create app which is doing the following
-
access to https://smartsheet.redoc.ly/#section/API-Basics/HTTP-and-REST
- can be done via oauth client credentials grant
- destinations could be used to configure it on CF : https://help.sap.com/docs/CP_CONNECTIVITY/cca91383641e40ffbe03bdc78f00f681/7e306250e08340f89d6c103e28840f30.html
- or use cups - use-provided service on CF to wrap access info
- can be done via oauth client credentials grant
-
get DB connection to HANA DB:
- https:///
- can be authorized va api access: https://help.sap.com/docs/SAP_PROFITABILITY_PERFORMANCE_MANAGEMENT_CLOUD/184efabaccdc4175b97223affaf7e5f8/09d3b74b678f42cca3d0af3193e3dd67.html?locale=en-US
- access based on auth client credentials can be again configured within destinations
-
read the needed data from smart sheets
-
write data into hana database
- use connection as mentioned above and write data to hana db
- https://www.npmjs.com/package/@sap/hana-client
- https://docs.nestjs.com/techniques/database
-
use createConnection, getConnection from 'typeorm'
const credentials = { type: 'sap', host: hanaCredentials.host || '', port: (hanaCredentials.port as unknown) || '', username: hanaCredentials.user || '', password: hanaCredentials.password || '', database: this.configService.get('DB_NAME') || 'H00', name: tenantId, schema: '', encrypt: true, synchronize: false, logging: this.configService.get('DB_LOG') || '["error" , "warn", "info", "log"]', maxQueryExecutionTime: 5000, pool: { min: 10, max: 20, requestTimeout: 10000 }, extra: { sslValidateCertificate: false }, } as SapConnectionOptions;
-
- use connection as mentioned above and write data to hana db
-
schedule everything as a a task
-
app does not need to run on cf. It can run everywhere - should be secure due to credential settings
- cf specific parts need then 2 B replaced
-
alternatively implement a REST client from within Python or JS execution engine
- issue: How to store credentials in a secure manner
-
A progressive Node.js framework for building efficient and scalable server-side applications.
Nest framework TypeScript starter repository.
$ npm install
# development
$ npm run start
# watch mode
$ npm run start:dev
# production mode
$ npm run start:prod
# unit tests
$ npm run test
# e2e tests
$ npm run test:e2e
# test coverage
$ npm run test:cov
Nest is an MIT-licensed open source project. It can grow thanks to the sponsors and support by the amazing backers. If you'd like to join them, please read more here.
- Author - Kamil Myśliwiec
- Website - https://nestjs.com
- Twitter - @nestframework
Nest is MIT licensed.