Mobile Application using WEBIDE with custom SQL C# OData Service – Part1
There are many blogs/tutorials on scn which will help to set up trial account on the web and get started with SAP or Nothwind odata services – If you are a single developer who wants to develop a mobile app using WEBIDE which does not use SAP there are things we are have to do – this blog examines and explains how to go about this process.
1) Develop a Custom Odata Service which initially runs on your lap top and later can be moved to the cloud – for this we use the develop a Custom Odata service from Northwind database and deploy it on IIS and use this in the mobile App development. It is assumed that you have installed HAT and tested your configuration.
2) Install HANA cloud connector on your lap top – Again there are many documents on scn and this is not covered here – just note that after you install – you have to include the IIS path in hcc.
In this blog we Cover the steps to Create a Custom Odata Service on SQL Server and deploy it on IIS using Visual Stuido and set up the destination in WEBIDE which will enable us to start the application development described in Part 2.
1) Start Visual Studio 2013 and Create a new Web Project (empty)– Call it NorthData
2) Right Click on the Project and choose add new item and then choose Data and ADO.NET
Choose EF designer from Database – Then Select Next – Create a new Connection to the Northwind Database on your local SQL Server – Test the Connetion – on the next screen choose
Entity Frame work 5.0 – Next Screen choose the tables/views/stored procedures that you will use and finish – Build the Project
3) Right Click on the Project New Item and then and choose web- WCF Data Service 5.6 and type NorthwindData.svc and click Finish
open the file NorthwindData.svc.cs and make the following changes to make the file appear as below
public class NorthwindData : DataService<NorthwindEntities>
// This method is called only once to initialize service-wide policies.
public static void InitializeService(DataServiceConfiguration config)
// TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc.
config.DataServiceBehavior.MaxProtocolVersion = DataServiceProtocolVersion.V3;
NorthwindEntites is created in the webconfig file when you created the SQL Connectioin – The “*” in the config will ensure that you access any table and perform CURD on any table.
4) Build the project and Publish to the local IIS – After Building right click on the project and choose publish – Create Custom settings and enter shown
5) Start IIS and select NorthData – From the Middle Pane – select Directory Browsing and from the right pane choose Enable so that this service can be used
6) Enable Pass Through for IP address for localhost – When using Webide you cannot use localhost – we have to use ipaddress – To Get the ip address – Go to Control Panel , Windows Firewall , Advanced settings, Inbound Rules , New Rule, Select port, TCP, your port number and save it
7) Download and install the Cloud Connector – This is widely covered and is not discussed here – Login to Cloud Connector and make sure that the path for your odata service is allowed from the Connector
The final Step is this process is to create a destination in WEBIDE – log on to hana cloud trial account and Create a destination – Again this process is well documented – Here we create a destination for this local ip address and check connectivity
Click on the Check Connection to make sure the destination is set up correctly – Some times Cloud connector sometimes times out – make sure that this is not case – now we are set to start the application development using SAP WEBIDE which is covered n the next part.
In the next part you will use this service to create custom SAP UI5 app