SAP OData service creation from .NET

[former_member306137]

Hello all,

Can you suggest the possible way to create OData service that will communicate with SAP using .NET technologies? This should be later used as Service catalog for Data connection in application development using SAP Web IDE tool.

Any documentation regarding this topic would also be very useful.

Thank you.

[Andre_Fischer]

Is your plan

a)

to develop a large amount of .NET based OData services and you want to develop a .NET based catalog service as well in order to be able to browse through all these services using SAP Web IDE?

Or

b)

do you have only a few .NET based services and want to use SAP Web IDE to develop SAP Fiori apps on top of those?

If it is a) we would have to check with the colleagues from SAP Web IDE Development whether we would support the use of a custom catalog service.

If it is b) I would recommend to use the option to enter a single Service URL.

Best Regards,

Andre

[former_member306137]

Hello Andre,

Thank you for your response. We would like to use this service to develop SAP Fiori apps, so the target is now second option. We made this connection already in SAP Web IDE using Service URL, as you suggested, but here we used Eclipse to create CDS View based on data from SAP and expose this CDS View as OData service.
Question is now how can we do this part using Visual Studio and .NET technologies instead of Eclipse?

Thank you in advance.

Best regards,
Tamara

[Andre_Fischer]

Hi Tamara,

I am not sure whether I got your problem and I would have two questions:

1.) Have you developed the CDS views in SAP Application Server ABAP or have you developed the CDS Views on HANA and used the XS Engine to publish them as OData service?

2.) You wrote ".. Question is now how can we do this part using Visual Studio and .NET technologies instead of Eclipse? "
Does that mean you are looking for an Option to develop CDS views with Visual Studio? This is not possible.

What you can do is to develop .NET based OData services and consume them via SAP Web IDE.

Regards,

Andre

[former_member306137]

Hi Andre,

You got it right. We developed CDS view in SAP Application Server and we used Eclipse IDE. But now we would like to switch to Microsoft technologies and get the same result. I think that this option to develop .NET based OData services could work for us. Do you have some documentation where we could see possible ways to do this and how to create connection between SAP and Visual Studio? Also, can this .NET service be reused later to connect to different database systems?

Thank you very much.

Best regards,

Tamara

[gregorw]

Dear Tamara,

the question still remains: Why? It seems your team has already experience with Eclipse to build CDS that can be exposed as OData Services. As SAP does not natively support such developments in Visual Studio I don't see why you need to do that. Of course could you access the SAP Backend from .NET using the .NET Connector, but that would just add another layer of complexity. It would help if you could provide more details on your reansons.

Best regards
Gregor

[former_member306137]

Hi Gregor,

The main reason that we want to use Visual Studio is code re-usability, meaning we have already developed application in C# and we want to adjust it and use that code as service for Fiori app. What would you suggest us?

Thank you.

Best regards,

Tamara

[Andre_Fischer]

Hi Tamara,

there are tons of libraries available to develop OData Services using .NET

https://www.odata.org/libraries/

If you want to use SAP Fiori Elements on top

https://sapui5.hana.ondemand.com/1.36.7/docs/guide/03265b0408e2432c9571d6b3feb6b1fd.html

you could use the Annotation Modeler in SAP Web IDE to add annotations to a .NET based OData Service similar as you can add annotations to an "old" OData Service that has been developed using SEGW with a Code based implementation but without annotations.

https://help.sap.com/viewer/825270ffffe74d9f988a0f0066ad59f0/Cloud/en-US/fe8ba75588964d3bbfc5c1bf96b...

Regards,

Andre