2022 May 13 2:16 PM - edited 2022 May 13 2:20 PM
This is a great place for us to talk about all things OData, about the topics that came up during the related Hands-on SAP Dev live stream episodes. Have a look at the episodes, and share your thoughts, comments and questions here.
2022 May 13 2:41 PM - edited 2022 May 13 2:44 PM
Here are the links shared in this part 1 (introduction)
Sample OData services including the classic Northwind
OData with CAP showing how CAP helps you build OData services
Take a Deep Dive into OData mission on our Tutorial Navigator
Sample OData service and UI5 app that we'll be using in this series
2-minutes-of API Basics playlist including videos on HTTP and REST
Monday morning thoughts: OData where I talk about the origins of OData and more
OData Specs analysis this is a brief "map" of OData specification documents
Blog feed at qmacro.org that you can compare with an OData entityset and see that they're very similar
XML Tree extension for Chrome use this for nicely formatted XML responses in your browser
2022 May 13 9:02 PM
2022 May 14 8:35 AM
2022 Jun 29 3:05 PM
I tried to follow your instructions of your youtube video for VS code "cds deploy --to sqlite", but it returns with error: cds : File C:\Users\XXXXX\AppData\Roaming\npm\cds.ps1 cannot be loaded. The file C:\Users\XXXXX\AppData\Roaming\npm\cds.ps1 is not digitally signed. You cannot run this script on the current system.
For more information about running scripts and setting execution policy, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
At line:1 char:1
+ cds deploy --to sqlite
+ ~~~
+ CategoryInfo : SecurityError: (:) [], PSSecurityException
+ FullyQualifiedErrorId : UnauthorizedAccess
I tried to google, but did not found a working solution, will you know why? thanks Sam
2022 Jul 01 9:13 AM - edited 2022 Jul 01 9:15 AM
Hi there, this looks like it's a Windows / Powershell issue on your machine. I did a quick Google and found this, which seems to be in the right area: https://www.alitajran.com/not-digitally-signed-error-when-running-powershell-script/
I can't test it out myself, I don't run Windows or have access to a Windows machine.
2022 Jul 01 2:02 PM - edited 2022 Jul 01 2:07 PM
I would add that I am a Windows user and run PowerShell and I don't have any issues running the cds commands from the npm global install.
So I don't believe this is just a general Windows/Powershell kind of issue. When you do a npm install -g a powershell script is created by NPM to be compatible with running commands from powershell. On my machine my Nodejs install is setup (by the installer) to be trusted by Powershell automatically. I didn't have to do anything special. So this might indicate a problem in your intial Node.js install or something company specific installed on your machine (It could be the case they have enforced additional security checks).
I do use nvm for Windows to manage my Node.js installations. coreybutler/nvm-windows: A node.js version management utility for Windows. Ironically written in Go.... Maybe that will help you get around any security/setup issues with Node.js runtime on your machine
You might try running this from regular Windows cmd instead powershell or even better try out WSL2 and run it via the embedded Linux. If you haven't tried out WSL2 I highly recommend it in general. Install WSL | Microsoft Docs
While I run Powershell as the default in my terminal, I also have a startup script that routes certain commands to Ubuntu in WSL. I can issue both powewshell and linux commands mixed in the same terminal session that way.
2022 May 16 1:44 PM
Here is the chat log from the livestream as well:
Author Name | Message | Video Time |
Helmut Tammen | 33 people are waiting. DJ, seems that you hit the nerv | 0:00:12 |
Henry Stuifzand | Goodmorning from a cloudy Netherlands | 0:00:12 |
Nils Lutz | good morning everyone 🖖 | 0:00:12 |
bilen cekic | good afternoon from Malaysia 🖐 | 0:00:12 |
Akshath LT | Hello Good morning 🌞 | 0:00:12 |
vijay kumar | Good morning DJ | 0:00:12 |
emsigyver | Good morning DJ from Heidelberg | 0:00:12 |
Joe Blower | Morning all 👋 | 0:00:12 |
Nico Geburek | Good Morning all | 0:00:12 |
Pavan Kumar | Good morning all | 0:00:12 |
Onno Schoenmakers | Good morning from a sunny Den Bosch, Netherlands 😃 | 0:00:12 |
Akhilesh Vatupalli | Good Morning | 0:00:12 |
SAP Developers | https://www.youtube.com/user/sapdevs/videos | 0:00:12 |
Sanjay Yadav | Good morning sir 🌞 | 0:00:12 |
Christian Drumm | good morning 👋 | 0:00:12 |
SAP Developers | https://www.youtube.com/playlist?list=PL6RpkC85SLQBCAZNbi-vNMSoXZJZp5wDq | 0:00:12 |
SAP Developers | /watch?v=sMyXGqDDxu8 | 0:05:07 |
Ian Stubbings | Morning DJ, morning all 🙂 | 0:05:07 |
Pieter Janssens | Good morning folks | 0:05:07 |
Raghu Ram | Hi!! Greetings for the Day | 0:05:07 |
bilen cekic | but DJ, there are many startups still relies on RestAPI and GraphQL but i don't see anyone really want to use ODATA for their dataflow 😀 | 0:05:07 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbXdGeHVCNVluUWRFQU9NSXNUTnR2YUJ... | 0:05:07 |
Christian Drumm | Your mic sounds a litte strage today. A lot of reverb and metallic. Did you select the right mic? Might just be that you are sitting in a different room... | 0:09:58 |
Nico Geburek | I don't notice any difference tbh | 0:10:01 |
flatline | odata is kindof standard but what do you think about gRPC , isn't that more suitable for erp projects | 0:10:01 |
vijay kumar | I am working for data migration. I am using ETL( BODS, Talend ) tool for data load. Recently started exploring the Odata for data loads which is already available in SAP. Suppose | 0:10:01 |
Christian Drumm | OK. Don't worry. No need to apologies. It's fine! | 0:10:01 |
vijay kumar | if any standard oData is not available. I think to develop from RAP API since SAP is recommanding to go forward with RAP rather in Odata with SEGW( Netwear Gateway ). | 0:10:01 |
vijay kumar | What is the recommanded way for future development for data migration? RAP or traditional SEGW? | 0:10:01 |
Akhilesh Vatupalli | Will REST completely replace SOAP? What are the main differences? | 0:10:01 |
Helmut Tammen | 33 people are waiting. DJ, seems that you hit the nerv | 0:12:28 |
Henry Stuifzand | Goodmorning from a cloudy Netherlands | 0:12:28 |
Nils Lutz | good morning everyone 🖖 | 0:12:28 |
bilen cekic | good afternoon from Malaysia 🖐 | 0:12:28 |
Akshath LT | Hello Good morning 🌞 | 0:12:28 |
vijay kumar | Good morning DJ | 0:12:28 |
emsigyver | Good morning DJ from Heidelberg | 0:12:28 |
Joe Blower | Morning all 👋 | 0:12:28 |
Nico Geburek | Good Morning all | 0:12:28 |
Pavan Kumar | Good morning all | 0:12:28 |
Onno Schoenmakers | Good morning from a sunny Den Bosch, Netherlands 😃 | 0:12:28 |
Akhilesh Vatupalli | Good Morning | 0:12:28 |
SAP Developers | https://www.youtube.com/user/sapdevs/videos | 0:12:28 |
Sanjay Yadav | Good morning sir 🌞 | 0:12:28 |
Christian Drumm | good morning 👋 | 0:12:28 |
SAP Developers | https://www.youtube.com/playlist?list=PL6RpkC85SLQBCAZNbi-vNMSoXZJZp5wDq | 0:12:28 |
SAP Developers | /watch?v=sMyXGqDDxu8 | 0:12:28 |
Ian Stubbings | Morning DJ, morning all 🙂 | 0:12:28 |
Pieter Janssens | Good morning folks | 0:12:28 |
Raghu Ram | Hi!! Greetings for the Day | 0:12:28 |
bilen cekic | but DJ, there are many startups still relies on RestAPI and GraphQL but i don't see anyone really want to use ODATA for their dataflow 😀 | 0:12:28 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqa2ZnZkxCbVdIcFR6cjZVX044LWk0Smh... | 0:12:28 |
Christian Drumm | Your mic sounds a litte strage today. A lot of reverb and metallic. Did you select the right mic? Might just be that you are sitting in a different room... | 0:12:28 |
Nico Geburek | I don't notice any difference tbh | 0:12:28 |
flatline | odata is kindof standard but what do you think about gRPC , isn't that more suitable for erp projects | 0:12:28 |
vijay kumar | I am working for data migration. I am using ETL( BODS, Talend ) tool for data load. Recently started exploring the Odata for data loads which is already available in SAP. Suppose | 0:12:28 |
Christian Drumm | OK. Don't worry. No need to apologies. It's fine! | 0:12:28 |
vijay kumar | if any standard oData is not available. I think to develop from RAP API since SAP is recommanding to go forward with RAP rather in Odata with SEGW( Netwear Gateway ). | 0:12:28 |
vijay kumar | What is the recommanded way for future development for data migration? RAP or traditional SEGW? | 0:12:28 |
Nico Geburek | Had to CAPture it | 0:15:07 |
Wises Keshom | Hi Good morning everyone | 0:15:07 |
flatline | it would be really perfect experiment to embed nodejs into erp so instead of segw we can access tables with node, i know there is cap but it not available for normal onprem erp | 0:15:07 |
Nikhil Rao | Actually DJ/Vijay Kumar, wouldnt it be fair to say, that Odata is not the best candidate for massive data migrations ? instead shouldnt we be looking at LTMOM/LTMC. + no SEGW on Steampunk, yeah ?! | 0:19:11 |
SAMIR DUTTA | is there any utility to monitor RAP API payload and reprocess it like Idoc. any plan to bring such tool ? | 0:19:11 |
flatline | for etl go binary | 0:19:11 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbXlkN2dGZXBITjJJNG1aZWxyb29ESEF... | 0:25:33 |
Raghu Ram | What about folks who are new to SAP and don't know SAP ABAP? | 0:25:33 |
Helmut Tammen | @Raghu Ram CAP and BTP | 0:25:33 |
vijay kumar | LTMOM and LTMC is too much manual work. We are extracting from non SAP system and direct load to SAP Via IDOC and RFC. | 0:25:33 |
vijay kumar | But these are old techniques . We want to go SAP's features proofs of both hybrid data migration for both on cloud and on prim S4 hana | 0:25:33 |
Rajshekhar Verma | for better understanding of REST architecture, i think fielding_dissertation is good reference | 0:25:33 |
Pavan Kumar | I see some services in sap api business hub as REST API and OData API . what exactly the difference between both ? | 0:25:33 |
Raghu Ram | please paste the link to start abap | 0:25:33 |
bilen cekic | for ETL i developed a sap certified ETL tool purely relies on REST API and i can tell there is no limitations at all. especially on dynamic content, nothing can beat REST API. Insanely simple. | 0:25:33 |
Ian Stubbings | @Raghu Ram .The one I posted is the new one from Andre Fischer | 0:25:33 |
Henry Stuifzand | NIce link I saw yesterday: | 0:25:33 |
Ian Stubbings | Should be perfect for you | 0:25:33 |
sorabh nagpal | We are currently in ECC developing Segw odata but if we plan to migrate to S/4 HANA ..can we reuse them or we should try to rebuilt within the RAP/CAP to take the advantage of S/4 HANA | 0:25:33 |
Raghu Ram | Oh!! thanks a lot my dear friends | 0:25:36 |
Ian Stubbings | np 🙂 | 0:25:36 |
flatline | before open source cap , embed cap into onprem erp, xs never took of maybe this will | 0:25:36 |
Raghu Ram | Send me the link of Fischer | 0:25:36 |
Chech | programming on SAP BTP | 0:25:36 |
SAMIR DUTTA | we have seen SAP has started releasing odata v4 based Apps in s4. is this the way forward to build app and in sap roadmap on v4. is there any tool for odata v2 to v4 migration or we hv to create srvc | 0:25:36 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbGVIOWRicFhiamhTVF9NSS1rVlR1UHB... | 0:28:01 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqa01hY0VKeWNrMVVZeVotQTVSdmk0RWh... | 0:28:01 |
Nikhil Rao | CAP is now on Eclipse too ? anyone with feedback on it here ? | 0:28:01 |
Nils Lutz | CAP ❤ | 0:28:01 |
Gary Daley | ms | 0:28:01 |
Akhilesh Vatupalli | RSS | 0:28:01 |
SAMIR DUTTA | microsoft | 0:28:01 |
Nils Lutz | wasn't it Microsoft? | 0:28:01 |
Pavan Kumar | Microsoft | 0:28:01 |
Akhilesh Vatupalli | Will REST completely replace SOAP? What are the main differences? | 0:28:28 |
Nico Geburek | Had to CAPture it | 0:28:28 |
Wises Keshom | Hi Good morning everyone | 0:28:28 |
flatline | it would be really perfect experiment to embed nodejs into erp so instead of segw we can access tables with node, i know there is cap but it not available for normal onprem erp | 0:28:28 |
Nikhil Rao | Actually DJ/Vijay Kumar, wouldnt it be fair to say, that Odata is not the best candidate for massive data migrations ? instead shouldnt we be looking at LTMOM/LTMC. + no SEGW on Steampunk, yeah ?! | 0:28:28 |
SAMIR DUTTA | is there any utility to monitor RAP API payload and reprocess it like Idoc. any plan to bring such tool ? | 0:28:28 |
flatline | for etl go binary | 0:28:28 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbkZFdXhRYzVOVENUUF85cUM5cUZ6UU5... | 0:28:28 |
Raghu Ram | What about folks who are new to SAP and don't know SAP ABAP? | 0:28:28 |
Helmut Tammen | @Raghu Ram CAP and BTP | 0:28:28 |
vijay kumar | LTMOM and LTMC is too much manual work. We are extracting from non SAP system and direct load to SAP Via IDOC and RFC. | 0:28:28 |
vijay kumar | But these are old techniques . We want to go SAP's features proofs of both hybrid data migration for both on cloud and on prim S4 hana | 0:28:28 |
Rajshekhar Verma | for better understanding of REST architecture, i think fielding_dissertation is good reference | 0:28:28 |
Pavan Kumar | I see some services in sap api business hub as REST API and OData API . what exactly the difference between both ? | 0:28:28 |
Raghu Ram | please paste the link to start abap | 0:28:28 |
bilen cekic | for ETL i developed a sap certified ETL tool purely relies on REST API and i can tell there is no limitations at all. especially on dynamic content, nothing can beat REST API. Insanely simple. | 0:28:28 |
Ian Stubbings | @Raghu Ram .The one I posted is the new one from Andre Fischer | 0:28:28 |
Henry Stuifzand | NIce link I saw yesterday: | 0:28:28 |
Ian Stubbings | Should be perfect for you | 0:28:28 |
sorabh nagpal | We are currently in ECC developing Segw odata but if we plan to migrate to S/4 HANA ..can we reuse them or we should try to rebuilt within the RAP/CAP to take the advantage of S/4 HANA | 0:28:28 |
Raghu Ram | Oh!! thanks a lot my dear friends | 0:28:28 |
Ian Stubbings | np 🙂 | 0:28:28 |
flatline | before open source cap , embed cap into onprem erp, xs never took of maybe this will | 0:28:28 |
Raghu Ram | Send me the link of Fischer | 0:28:28 |
Chech | programming on SAP BTP | 0:28:28 |
SAMIR DUTTA | we have seen SAP has started releasing odata v4 based Apps in s4. is this the way forward to build app and in sap roadmap on v4. is there any tool for odata v2 to v4 migration or we hv to create srvc | 0:28:28 |
Ian Stubbings | Green screen alert 🙂 | 0:30:47 |
Akhilesh Vatupalli | RSS was one of the birth places for ODATA | 0:30:47 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbnQ3Z1oxWmVqdkNmamF3QWRvd0dIald... | 0:30:47 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqa1FxQTJCdmZjRXhjdmVvZmJ1SVVOS3p... | 0:30:47 |
Joe Blower | FYI DJ, you're getting some green screen tearing on your right. Looks like your blinds!? 😀 | 0:30:47 |
Ian Stubbings | Right shoulder | 0:30:47 |
Joe Blower | Ah, beaten to it 🙂 | 0:30:47 |
flatline | since odata contains metadata about data type filed names etc.., do anyone know a tool that generates sample request from an odata endpoint ? | 0:30:47 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqa1JFaEF2ZnNUdDNKbE1rYURSYlRtRnN... | 0:33:13 |
Raghu Ram | if it is hanadb, do we go wuth hanadb instead sqlite in console | 0:33:13 |
Ian Stubbings | I remember that | 0:33:13 |
vijay kumar | yes i am aware | 0:35:46 |
Jan-Willem Kaagman | Ofcourse, everyone knows the Northern winds 😉 | 0:35:46 |
Nico Geburek | Northwind 🥰 | 0:35:46 |
Nils Lutz | northwind -> the SFLIGHT in Odata world 😀 | 0:35:46 |
flatline | rival company to acme ? | 0:35:46 |
Pieter Janssens | Northwind V4 allows CORS | 0:37:17 |
Pavan Kumar | is it possible to get the metadata for the odata service in json ? | 0:37:17 |
vijay kumar | Yes you can get the metadata in JS using JSlint site | 0:37:17 |
vijay kumar | or install the plugin | 0:37:17 |
bilen cekic | we send entire JSON content of our data in one of the columns of ODATA service. Technically it is ODATa but we RESTified it . Easier for our UI5 apps | 0:37:17 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbWg1YnJ6MDNfaFRDVHlNdVNBZzJOa21... | 0:40:15 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqblVIeTJkajVHSGlMY2VCZW5jSG02R1J... | 0:40:15 |
Nikhil Rao | CAP is now on Eclipse too ? anyone with feedback on it here ? | 0:40:15 |
Nils Lutz | CAP ❤ | 0:40:15 |
Gary Daley | ms | 0:40:15 |
Akhilesh Vatupalli | RSS | 0:40:15 |
SAMIR DUTTA | microsoft | 0:40:15 |
Nils Lutz | wasn't it Microsoft? | 0:40:15 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqa0sxU0NnVWR3TUNwSWhoaXludTlLTjJ... | 0:42:02 |
Nils Lutz | have a look at the editors DJ | 0:42:02 |
Nils Lutz | of odata v4 | 0:42:02 |
Rajshekhar Verma | Raj is okay | 0:42:02 |
Nils Lutz | yep | 0:42:02 |
Nils Lutz | wanted to point that out to show the dedication of SAP to the OData protocol | 0:42:02 |
Chech | it says V3 in the northwind URL. fair to say SAP skipped adopting v3? | 0:42:02 |
Nico Geburek | What's the browser extension you use to view xml to get the tag highlighting etc? | 0:49:32 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbG1CX05DSkhIZTlfVmxLVXdEa01fc3p... | 0:49:32 |
Nils Lutz | @Nico looks like "XML Tree" | 0:49:32 |
Nico Geburek | Muchas Gracias | 0:49:32 |
vijay kumar | In terms of performances for more than 1 millions records of creating material master , Sales order, Purchase orders using Odata service. will it support that huge volume of data?. | 0:51:29 |
vijay kumar | I am using ETL i can split into small packets of data using $filter, $between but still it takes long time. Is it a right approach to do this using Odata or RAP? | 0:51:29 |
jbm1991 | it's big enough for me | 0:51:29 |
Rajshekhar Verma | @Vijay kumar it is always recommended to call service in batches | 0:51:29 |
jbm1991 | it is me! It seems to have logged me in with a different account today for some reason | 0:51:29 |
bilen cekic | @Vijay kumar i am using plain rest with JSON. And my ETL is sometimes integrationg 100 millions of BSEG records. Integration via ODATA should be illegal | 0:51:29 |
bilen cekic | I also split into smaller batches but my ODATA tests also shown data, it is cumbersome to use ODATA if not specially for Azure or AWS for a specific service, or RAP purpose | 0:54:23 |
vijay kumar | for both hybrid approach of cloud and on prim | 0:54:23 |
Rajshekhar Verma | @Vijay kumar some times platform restriction wont allow you to create that log document, in ABAP backend it will throw dump while processing as it can not hold that big service document in string | 0:56:20 |
Jan-Willem Kaagman | Something very different, but very much in the spirit of SAP Development: Will there be a "live" TechEd this year, or again online? | 0:58:03 |
vijay kumar | @Former Member Verma , I am only in concept phase. i am thinking to use new approaches with kafka with Odata in ETL. | 1:00:26 |
Pavan Kumar | nice session DJ | 1:01:30 |
vijay kumar | @Former Member Verma , I am only in concept phase. i am thinking to use new approaches with kafka with Odata in ETL. | 1:02:10 |
Pavan Kumar | Microsoft | 1:02:10 |
Ian Stubbings | Green screen alert 🙂 | 1:02:10 |
Akhilesh Vatupalli | RSS was one of the birth places for ODATA | 1:02:10 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbmRDcW81VmpGNjZRQlg2Yk9UbTJ0TjNsVjZzd3xBQ3Jtc0trbGJyb3ZJTk45UkExSGpHbkwxbS1rOGVTYTRldTg0WHZWdkszNkpIMGtLdjdiSE9HUXNGakNhOTBOMUV0VWRWUjI1bTdQOXUwVVRuaHJkQTF0dFNxVDYwZnMwZnIwejc0QWRYeXRzZjdMRlV2MVo0VQ&q=https%3A%2F%2Fblogs.sap.com%2F2018%2F08%2F20%2Fmonday-morning-thoughts-odata%2F | 1:02:10 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbEtjbVJlZUlhVUZYeW9SOG81aVhTYko2NjY4UXxBQ3Jtc0ttUEZmTXRnaFVPR3dpa2tQdmFWZ1lfS1BHOWpnRUpzMG10a21RazRzcWM1TDFrd2R1UktSc0N1a0JjQ3JKQ29MR1FZZlBiTXM5MHJRQmJEdFF4dS04UTA4dWpyUlZ0WDBOSDFVZW45R0wxRkF3RE84WQ&q=https%3A%2F%2Fblogs.sap.com%2F2018%2F08%2F20%2Fmonday-morning-thoughts-odata%2F | 1:02:10 |
Joe Blower | FYI DJ, you're getting some green screen tearing on your right. Looks like your blinds!? 😀 | 1:02:10 |
Ian Stubbings | Right shoulder | 1:02:10 |
Joe Blower | Ah, beaten to it 🙂 | 1:02:10 |
flatline | since odata contains metadata about data type filed names etc.., do anyone know a tool that generates sample request from an odata endpoint ? | 1:02:10 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbUZQSGJLa0Q4UGlicWppVW9obG5EWjF3OHZ5UXxBQ3Jtc0tuWlVkTWxYanc5b3FHVzNoZUkxeGNHdXVMSFRaczkwanFueGJiTXBUSzh4QUVSVzBZWU1xWWtlT1BIZTFkVFJwZVFDaE1KOTBYY0RmdzBQbHJudFdhT0dyOF9RV19oN2tZNHlrdUhXQkdYWlFSNktTTQ&q=https%3A%2F%2Fservices.odata.org%2F | 1:02:10 |
Raghu Ram | if it is hanadb, do we go wuth hanadb instead sqlite in console | 1:02:10 |
Ian Stubbings | I remember that | 1:02:10 |
vijay kumar | yes i am aware | 1:02:10 |
Jan-Willem Kaagman | Ofcourse, everyone knows the Northern winds 😉 | 1:02:10 |
Nico Geburek | Northwind 🥰 | 1:02:10 |
Nils Lutz | northwind -> the SFLIGHT in Odata world 😀 | 1:02:10 |
flatline | rival company to acme ? | 1:02:10 |
Pieter Janssens | Northwind V4 allows CORS | 1:02:10 |
Pavan Kumar | is it possible to get the metadata for the odata service in json ? | 1:02:10 |
vijay kumar | Yes you can get the metadata in JS using JSlint site | 1:02:10 |
vijay kumar | or install the plugin | 1:02:10 |
bilen cekic | we send entire JSON content of our data in one of the columns of ODATA service. Technically it is ODATa but we RESTified it . Easier for our UI5 apps | 1:02:10 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbVU4YlZwMHQ1SldmdjJsMW0zTEpiZkZSdVVzQXxBQ3Jtc0ttY3lIbnBQUzhkenpEZExRY2I0c2xzeE13RHNHejlMampVc0l0bXRGS01FU2NGREVwUXJQc0Zob01RUTdJSzBZN3Q3Rk12VmJHVVMyZm04SWVrYXdHbnh2dGR1ai1acW9xTGdQMVlQb1JOaDlMQ0k1Yw&q=https%3A%2F%2Fgithub.com%2Fqmacro%2Fodata-specs%2Fblob%2Fmaster%2Foverview.md | 1:02:10 |
Nils Lutz | have a look at the editors DJ | 1:02:10 |
Nils Lutz | of odata v4 | 1:02:10 |
Rajshekhar Verma | Raj is okay | 1:02:10 |
Nils Lutz | yep | 1:02:10 |
Nils Lutz | wanted to point that out to show the dedication of SAP to the OData protocol | 1:02:10 |
Chech | it says V3 in the northwind URL. fair to say SAP skipped adopting v3? | 1:02:10 |
Nico Geburek | What's the browser extension you use to view xml to get the tag highlighting etc? | 1:02:10 |
SAP Developers | https://www.youtube.com/redirect?event=live_chat&redir_token=QUFFLUhqbmVPYjBDSUdVUS1KRlpqOF85Nk03aWw2V0hKUXxBQ3Jtc0tsVFdBX1hkcmNONWhXZ3ItUTZFSmhVbUVoNVZmSDlUS0h0UE93T1dGcWpfUWh5RGpSQlhEdkhybU5lSWk0YjJDeENLOVZtaENRLW5xR1NPOUp5OEZUUXc3ODRaeXZXNS16bC03a25rNzlLclVrbmxEbw&q=https%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Fxml-tree%2Fgbammbheopgpmaagmckhpjbfgdfkpadb%3Fhl%3Den | 1:02:10 |
Nils Lutz | @Nico looks like "XML Tree" | 1:02:10 |
Nico Geburek | Muchas Gracias | 1:02:10 |
vijay kumar | In terms of performances for more than 1 millions records of creating material master , Sales order, Purchase orders using Odata service. will it support that huge volume of data?. | 1:02:10 |
vijay kumar | I am using ETL i can split into small packets of data using $filter, $between but still it takes long time. Is it a right approach to do this using Odata or RAP? | 1:02:10 |
jbm1991 | it's big enough for me | 1:02:10 |
Rajshekhar Verma | @Vijay kumar it is always recommended to call service in batches | 1:02:10 |
jbm1991 | it is me! It seems to have logged me in with a different account today for some reason | 1:02:10 |
bilen cekic | @Vijay kumar i am using plain rest with JSON. And my ETL is sometimes integrationg 100 millions of BSEG records. Integration via ODATA should be illegal | 1:02:10 |
bilen cekic | I also split into smaller batches but my ODATA tests also shown data, it is cumbersome to use ODATA if not specially for Azure or AWS for a specific service, or RAP purpose | 1:02:10 |
vijay kumar | for both hybrid approach of cloud and on prim | 1:02:10 |
Rajshekhar Verma | @Vijay kumar some times platform restriction wont allow you to create that log document, in ABAP backend it will throw dump while processing as it can not hold that big service document in string | 1:02:10 |
Jan-Willem Kaagman | Something very different, but very much in the spirit of SAP Development: Will there be a "live" TechEd this year, or again online? | 1:02:10 |
Antonio Maradiaga | When dealing with massive amount of data and using APIs to extract the data, the biggest problem you'll face is initial /full load. Delta's are easier to handle | 1:02:45 |
Pavan Kumar | nice session DJ | 1:02:49 |
Antonio Maradiaga | When dealing with massive amount of data and using APIs to extract the data, the biggest problem you'll face is initial /full load. Delta's are easier to handle | 1:02:49 |
2022 May 17 7:19 AM - edited 2022 May 17 7:20 AM
I just came across a cool extension for visually exploring OData metadata - the OData CSDL Modeler.
What do you think? Shall we take a look at it in this week's live stream (part 2 of our OData series)?
2022 May 17 7:39 AM
Thanks for this. We are always on the look out for a good OData modeller. My all time fav was the PragmatiQa "XOdata", sad that was discontinued years ago but still half works on their website.
We use the WebIDE modeller sometimes, but it's kind of old and tired.
Something that we would really like is a tool that both models i.e. create/change/display graphically as well as doing the same in an editor that is CSDL syntax aware. Be good for you to take a look at the VS Code tool this week in your session.
High up on our list of wants is also a tool can also generate Swagger/Open API documentation of SAP OData V2 or V4 service metadata, without having to convert it to another format first or manipulate the metadata. I haven't been able to find such a tool thus far.
Brendan
2022 May 17 7:49 AM
2022 May 17 1:57 PM
@BrendanFarthing wrote:High up on our list of wants is also a tool can also generate Swagger/Open API documentation of SAP OData V2 or V4 service metadata, without having to convert it to another format first or manipulate the metadata. I haven't been able to find such a tool thus far.
Brendan
When you say SAP OData in this context do you mean ABAP based OData? Because CAP has functionaltiy and examples of how to generate Swagger/OpenAPI:
capire - Publishing to OpenAPI (cloud.sap)
2022 May 27 7:12 AM
Hi Thomas,
I'm meaning ABAP based OData, most typically OData V2 on an ABAP stack in our case and almost all of them are ECC systems.
But thanks for the tip about CAP, I'll check that out. But be good if anyone has some tips on taking an ABAP stack OData V2 $metadata and converting it into exactly what you guys have shown for CAP.
2022 May 18 4:29 PM
Yes, Tom is absolutely right. Here's the Swagger UI and YUML diagram that CAP creates with pretty much zero effort for me, on the https://github.com/SAP-samples/odata-basics-handsonsapdev repo:
2022 May 27 7:13 AM
2022 Jun 09 4:56 PM
Hi Team,
Thanks for sharing the details around odata.
I am working on an interface in SAP PO 7.5 odata v2 adapter where trying to query data from a thirdparty application. In the metadata, I have the fields CREATED_AT and MODIFIED_AT in the format "YYYY-MM-DDTHH:MM:SS". Can you please help with query filter on how to extract records of last 24 hrs.
Tablename: TD_RG_WELL_DAY_DSP_ALL
Thanks,
Varun