Import Connection with odataV4 between S4hana to SAC

[niels1515]

Hello experts,
We use an on-premis system and want to connect the SAC via an import data connection. I have found the documentation “Import Data Connection to SAP S/4HANA”: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/63140f17362947fe8bcd9...
At the beginning it says that only odata V2 is supported, is that really the case? There is no mention of this here:
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/4c002a6b954d43f18f371...

If I want to import my data model via this interface, only the published OdataV2 serives are displayed in the SAC. Do I have to change anything in the settings?
Greetings Niels

[umasaral]

Hi 

To publish OData V2 services for SAP Analytics Cloud (SAC), ensure you follow these steps:
1.Define the Service: Use the Service Builder in SAP Gateway to create and maintain your OData service.
2.Register the Service: Use the transaction `/IWFND/MAINT_SERVICE` to register the service.
3.Check Authorization: Ensure that the necessary authorizations are assigned for your user.
4.Activate the Service: Make sure the service is activated in the system.
5.Test the Service: Use the service URL in a browser or tool like Postman to verify it’s working.

You can refer to the official SAP documentation for detailed instructions on publishing OData services for SAP Analytics Cloud. Here are a couple of useful links:

SAP Help Portal - OData Services: http://help.sap.com/viewer/6a0d5f0a07a740f3b58c1e3efc4f7d7b/latest/en-US

SAP Community - OData V2 Services: http://community.sap.com/topics/odata

[umasaral]

Hi 

To publish OData V2 services for SAP Analytics Cloud (SAC):
1. SAP Gateway Service Builder: Use transaction code SEGW in your SAP system.
2. Select Your Service: Find the required OData V2 service in the list.
3. Activate the Service: Right-click on the service and select "Activate". Ensure all relevant entities are included.
4. Register the Service: Use transaction /IWFND/MAINT_SERVICE to register the service, ensuring it's added to the appropriate system alias.
5. Check Authorizations: Ensure that the user has authorization to access the service.
6. Test the Service: Use the OData Service URL in a browser or Postman to confirm it’s accessible.
After these steps, refresh your SAC connection to see the updated services.
you can find detailed instructions on how to publish OData services in the SAP Help Portal. Here’s a helpful link that covers the process:
SAP Gateway: OData Services

[umasaral]

Hi 

Yes, the documentation specifies that SAP Analytics Cloud (SAC) supports only OData V2 for import data connections with SAP S/4HANA. If you're not seeing your OData V2 services in SAC, ensure they are correctly published and accessible. Check the service settings in your S/4HANA system to confirm that they are enabled and accessible from the network where SAC is hosted. If needed, consult your system administrator for any additional configurations.

[niels1515]

Hi @umasaral, Thank you for your answer. Are there any instructions on how to publish the Odata V2 services correctly for the SAC? I see some of the V2 services but unfortunately not the ones I need. Greetings Niels