How to use Integration Gateway with SMP 3.0 (Part 2)
How to use Integration Gateway with SMP 3.0
– Describes how to set up the HSQLDB and how to deploy the JDBC driver to SMP3
– Describes how to model, implement and deploy the OData service with Integration Gateway
– Describes how to configure the Integration Gateway on SMP3 to bind the OData service to the backend and how to display the OData service
This is the second part of the tutorial.In this part of the tutorial we will use the “Toolkit for Integration Gateway”, which is a component of the GWPA (Gateway Productivity Accelerator) eclipse Plugin to model and implement the OData Service. We will also use this toolkit to deploy the OData service to SMP3.
Toolkit for Integration Gateway (GWPA)
Prerequisite
– SMP 3.0 is installed and running
– HSQLDB database is setup and running and HSQLDB JDBC driver is copied to SMP3 (explained in my previous blog entry)
Steps
1. Download eclipse Juno (I recommend the Java EE Version)
2. Start eclipse and choose Help > Install New Software… and insert address: http://tools.hana.ondemand.com/juno
3. Expand component “SAP Netweaver Gateway Productivity Accelerator (GWPA)” and select “Toolkit for Integration Gateway (GWPA, Developer Edition)”, then install it
4. After an eclipse restart choose New > Other… , then expand folder “OData Development” and select “Service Implementation Project”.
5. In the next window define a project name (in this example I choose intgwtest) and mark the checkbox “Create OData file manually” if you don’t have an OData model already.
6. The “Integration Toolkit” will create a project structure for you. Under src/main/resources you can find the packages edmx, mapping, model and wsdl. Right click on “model” and select New > Other… expand “OData Development” and select “OData Model”.
7. After creation you can see the created model. Open the Model (*.odata file) and click in the Palette under Objects on “Entity Type” to create a new entity type. Set the object name, the entity set name and the properties.
IMPORTANT: If the backend connection should be realized via JDBC, the Integration Gateway component of SMP 3.0 SP0 requires that the entity set is named exactly like the database table and that the properties are exactly named like the columns in the table. There is (at the moment) no (graphical) mapping editor available.
As default a new property gets created with type Edm.String. Because our property ID is an integer value, we can select the property ID, open the “Properties” panel and choose the Type “Edm.Int16”. Also change the type for the property BIRTH_DATE. Here you can choose Edm.DateTime.
8. If you finish modelling your OData service right click on your model (in my case Service.odata) and select “Implement Service”
9. An odatasrv file will be created. Right click on this odatasrv file and choose “Select Data Source”. Here you can define which data source should be mapped to the previous created model. Mark “JDBC” option.
10. The OData Service Creation is finished now. But before deploying it to SMP you have to specify the connection details. Therefore go to Window > Preferences expand “OData Development” and click on “Integration Gateway”. Specify the URL to your SMP3, e.g. https://localhost:8083 . (Use the Management Port, by default 8083 and https!). Test the connection.
11. Now right click on the project (in my case intgwtest) and select “Generate and Deploy Integration Content”.
12. Specify the corresponding information (or leave the default). The service name (intgwtest) can be used to access the service later. The Service Namespace defines also the security profile which is used to control access to this service.
IMPORTANT: Make sure that the JDBC driver is already known to SMP3 BEFORE deploying the OData service via the “Toolkit for Integration Gateway”. This has been described in part 1 (http://scn.sap.com/people/marvin.hoffmann/blog/2014/01/08/how-to-use-integration-gateway-with-smp-30-part-1).
13. If everyhting is ok you should get the information message: “Deployment has been completed …”
The configuration on SMP3 and the concrete using of this service is explained and shown in part 3 (http://scn.sap.com/people/marvin.hoffmann/blog/2014/01/08/how-to-use-integration-gateway-with-smp-30-part-3)
Hi Marvin,
I am getting following error while installing of Toolkit for Integration Gateway (GWPA), Even i am trying with installation of individual plugin olny at a time.
cannot complete the install because of a conflicting dependency.
Software being installed: Toolkit for Integration Gateway (GWPA, Developer Edition) 1.1.1 (com.sap.odata.dt.framework.sap.smp.feature.feature.group 1.1.1)
Software currently installed: Eclipse IDE for Java EE Developers 1.5.1.20120917-1257 (epp.package.jee 1.5.1.20120917-1257)
Only one of the following can be installed at once:
Eclipse IDE UI 3.8.1.v20120828-165804 (org.eclipse.ui.ide 3.8.1.v20120828-165804)
Eclipse IDE UI 3.8.2.v20121106-165923 (org.eclipse.ui.ide 3.8.2.v20121106-165923)
Eclipse IDE UI 3.8.0.v20120521-2329 (org.eclipse.ui.ide 3.8.0.v20120521-2329)
Cannot satisfy dependency:
From: Toolkit for Integration Gateway (GWPA, Developer Edition) 1.1.1 (com.sap.odata.dt.framework.sap.smp.feature.feature.group 1.1.1)
To: com.sap.odata.dt.framework.sap.smp.util [1.1.1]
Cannot satisfy dependency:
From: The Toolkit for Integration Gateway Util 1.1.1 (com.sap.odata.dt.framework.sap.smp.util 1.1.1)
To: bundle org.eclipse.ui.ide 3.8.2
Cannot satisfy dependency:
From: Eclipse IDE for Java EE Developers 1.5.1.20120917-1257 (epp.package.jee 1.5.1.20120917-1257)
To: org.eclipse.epp.package.jee.feature.feature.group [1.5.1.20120917-1257]
Cannot satisfy dependency:
From: Java EE IDE Feature 1.5.1.20120917-1257 (org.eclipse.epp.package.jee.feature.feature.group 1.5.1.20120917-1257)
To: org.eclipse.platform.feature.group [4.2.1.v20120814-120134-9JF7BHVGFyMveli1uX6aTH0q-eAap6PAgOP5mO]
Cannot satisfy dependency:
From: Eclipse Platform 4.2.1.v20120814-120134-9JF7BHVGFyMveli1uX6aTH0q-eAap6PAgOP5mO (org.eclipse.platform.feature.group 4.2.1.v20120814-120134-9JF7BHVGFyMveli1uX6aTH0q-eAap6PAgOP5mO)
To: org.eclipse.ui.ide [3.8.1.v20120828-165804]
Hi Harish Yerra,
usually it should be quite simple to install the plugin into eclipse. I wrote it down. So if you are still having problems, try to follow these steps:
How to install Gateway Productivity Accelerator (GWPA) plugin for Integration Gateway
Regards
Marvin
Hi Marvin,
I've installed the plugin successfully. However, I don't see Service Implementation Project as a choice. All I see is OData Development and OData Model. In the steps further down I am able to connect the Integration Gateway to the SMP server. Any idea what I might have missed?
Thanks.
Ted
Never mind. I rebooted the vm and it was there. Apparently restarting Eclipse wasn't enought.
hey, i am using smp3 on cloudshare and i am trying your document on my local machine, is it possible for me to connect gateway from my local pc.
Hi Martin
I have this problem
My Error log is :
Please I need your help for this problem .
Regards
Jaime
Marvin,
is it possible to use the gateway cockpit in the hanatrial environment? adding gateway/cockpit to the url gives me errors, so i'm afraid it is not possible.
please clarify
regards
Peter
Hi Peter,
you could have a look into HCI (HANA Cloud Integration) which is the data integration layer running on HANA...
See: SAP HANA Cloud Integration – SAP Help Portal Page
Regards
Thanks Marvin, I'll have a look.
One other question which I have on an on-premise system.
Creating a http destination in the integration gateway returns me unknown host error when I try to ping the destination. However if I enter the same http destination in the browser on the server where the integration gateway is installed, I get a http response 200.
Any suggestions?
thanks
Maybe Proxy required or if HTTPS maybe missing ssl certificates?
No proxy, no https... hmmm.
Marvin, Can this trace help?
marvin,
i found the issue, it was a java issue...
regards