Load data from API to CDS Artifact Tables in SCP Web IDE

[former_member355593]

Hi,

I am trying to load data from API development environment (e.g. POSTMAN) to SCP CDS Artifact tables. Is there any standard SAP suggested process/approach for this activity? If not, how can we achieve it? The data source can be anything except Hana (e.g. flatfiles, Oracle DB etc)

Please let me know.

I am using SCP Cloud Foundry Trial version.

[gregorw]

When you create a service layer using the Application Programming Model you will get a OData V2 or V4 API that you can use for data load. When you follow the cloud-sample-spaceflight-node example you also see a way how to populate the DB from CSV files.

[former_member355593]

Hi Gregor,

Thanks a lot for your input. I have already successfully tried this approach before posting the question here. The references which you have provided are uploading/importing the csv files physically to cloud platform MTA and then triggering the load to the CDS tables. What I am looking for is a bit different - I want to load the CDS tables without uploading/importing the csv files. e.g. Customer csv file is remotely located in my desktop and I only want to load the data to CDS table in MTA (without physically uploading the csv) via a service.

My use case has 30-40 tables, Importing csv files everytime we want to load makes the app heavy. Also, it doesn't sound like optimized approach as far as ETL is concerned.

Please let me know if you need further clarifications.

[gregorw]

You might try https://www.npmjs.com/package/odata and create a local OData Client in Node.js that uploads your files using the OData API?