SAP HCI Odata Provisioning is a part of SAP Hana Cloud platform based tools which among other functionality provides secure exposure of REST based interfaces from On Premise SAP Business Suite into the SAP Hana Cloud. In this case, let us look into an approach to use SAP Hana Cloud Integration to leverage SAP HCI Odata Provisioning to fetch data from on Premise SAP Business Suite.
For this approach we will use the following:
1) SAP Gateway trial service that is been provided by SAP – for details please refer to the link
2) SAP Hana and SAP Hana Cloud Integration Trial account
3) SAP Cloud Connector:
SAP Gateway :
We will use the SAP Gateway trial as a substitute for on Premise system and connect to it from locally installed SAP Cloud Connector. Check if the SAP Gateway can be accessed from your local machine.
SAP Cloud Connector Configuration
- Start the go.bat from the SAP Cloud Connector directory (in case of Windows OS).
- Login to the SAP Cloud Connector – the default is https://localhost:8443.
Set the Access Control so that the virtual host and port (sapgateway 1234) is pointing to the IW_BEP service in the SAP Gateway. This hides the actual hostname of the on Premise system and securely sets up the communication from the SAP Hana Cloud.
SAP HCI Odata Provisioning Configuration (formerly Gateway as a Service)
- Log in to the SAP HCI Odata Provisioning tool – using the following URL or by going into the Services tab in your SAP Hana Cloud Account. Please make sure you have assigned in the Authorization of your user the two roles ‘GW_User’ and ‘GW_Admin’ from Account ‘gwaas’ and Application ‘gwaas’.
2. In the HCI Odata Provisioning Configuration there are 4 sections :
a) Browse to the ‘Destinations’ section and create a destination to point to the onPremise system. The hostname and port will be the virtual hostname and port provided in the SAP Cloud Connector above and the credentials would be the details to log in to the SAP Gateway.
e) In the ‘Services’ section refer to the ‘Open Service Document’ link to get the URL to be used by SAP Hana Cloud Integration to use this service.
The link should open an URL https://gwaas-<user>trial.hanatrial.ondemand.com/odata/IWBEP/GWDEMO;v=1
SAP Hana Cloud Integration Configuration
- In the Eclipse tool let us develop a simple Integration iFlow to fetch the data from the URL above. Basically the scenario would be to fetch data from the URL above using the Odata adapter in SAP HCI.
- The iFLow details are as follows :
3. The Odata communication channel should be configured as below :
a) Choose the Adapter type as below :
b) In the Connection section provide the connectivity details :
c) The credentials to access the service should be deployed as ‘User Credential’ artifacts and the same name is referenced in the communication channel above.
d) Click on the ‘Model Operation’ to build the Query for fetching the data from the service. Fill up the URL , username and password to proceed.
e) Click on next to get the Entity list – the filter box above makes it easier to search through Entities.
f) Select the particular entity to create the query – and then choose the particular fields. Optionally click on next and create filter conditions for the query.
On completion of the creation of the query – the Query appears in the Operation Details section.
g) Deploy the Integration Project (Put the Starter Timer at ‘Run Once’ in the iFlow) and check for errors.In the SFTP server check for the file created – it should be available for confirmation of the testing.
Result of the scenario – The file created contains the data queried from the SAP Gateway.
Relevant links are mentioned below: