This sample integrates SAP data in SharePoint Online (Office 365) by means of ECS Core. The tools used to setup the sample are Napa Office 365 Development Tools and the Azure Portal.
ECS Core enables you to read and write SAP data. This article provides the procedures for how you can read data from SAP.
Before you start
This samples requires the following:
- An Office 365 Developer Site in an Office 365 domain and the rights to create and install a Napa-App.
- A Service Bus instance in the Azure Management Portal.
- An ECS Core Instance installation and configuration, in particular:
- Create a Service Application (i.e. SAP Connection), refer to Services.
- Generate an API Key, refer to API Keys.
- Add a Service Bus registration, refer to Azure Service Bus.
Remark: Other middleware software or tools like e.g. SAP Gateway or SAP Gateway for Microsoft are not needed for this scenario.
Step 1: Create a NAPA App
By using Napa, you can create your SharePoint Add-ins inside your browser instead of in Visual Studio. At any time, you can download your project and open it in Visual Studio for more advanced scenarios.
You need to have a SharePoint Online subscription that you can use for development. Otherwise, skip to Install Napa. If your subscription was not originally created as an Office 365 Developer Site, you have to create a Developer Site in the Administration UI of the subscription and then install Napa in it. To install Napa, open your Developer Site and choose Site Contents > add an add-in > SharePoint Store. In the store, search for Napa and install it. (If you have an Office 365 Developer Site, Napa may have already been installed when the site was created and you will see it on the Site Contents page.)
Create a SharePoint Add-in project
Open the Napa add-in on the Office 365 page.
Choose the Add New Project tile, and then choose the Add-in for SharePoint tile.
Name the project SAPMaterials, and then choose the Create button. The code editor opens and shows the default webpage, which already contains some sample code that you can run without doing anything else.
Step 2: Edit the home page (Default.aspx)
On the left side of the page under the Pages folder, choose the Default.aspx page if it isn’t already selected. The Default.aspx webpage appears in the code editor.
In this sample we used the current version src=”//static.theobald-software.com/theobald.ecs/4.10.2/theobald.ecs.js”
Important: please check and use the latest version of tEcs, where newest changes and improvements are incorporated! Please visit: http://static.theobald-software.com/tEcs/
In the PlaceHolderMain section, add the following code under the existing HTML.
The HTML creates these controls: An input that contains the input data (e.g. SAP material number) in the web page of the SharePoint Add-in. A button for reading the material description from SAP. A div that contains the result.
In the next step, you’ll define the function for the button control that you created in the previous procedure. GetSAPData(): to connect SAP and read SAP data.
In the App.js file, add the following code to the $(document).ready() function to set a handler for the button click event:
Note: Error squiggles may appear but they’ll disappear later.
Add the following code after the $(document).ready() function in App.js.
Let us put the basic code to call SAP through AzureBus and ECS Core:
- connection.ecs.coreApiKey must be be retrieved from your ECS Core installation.
- connection.ecs.url consists of Azure Service Bus name for ECS Core The ‘data’-field contains the SAP statement (using XtractQL) to get the German and English material description from the SAP table MAKT.
A table is used to display the result.
In this sample we read data from an SAP table. To execute an SAP function module check the following section Executing an SAP function.
Step 4: Run the app
At the left side choose the run button.
The project is packaged, deployed, and installed on your Office 365 Developer Site.
After installation, the SharePoint Add-in starts. If the add-in doesn’t start automatically because, for example, a popup blocker is enabled, choose the add-in link to start the add-in. The screen for the SharePoint Add-in appears.
Now enter some material number and click on the button. The result will be fetched from SAP and displayed. When you finish, close the browser window, and then choose the Close button in Launch Add-in window to return to the project that you were editing.