How can we help you today?

Show Data from SharePoint on SAP HANA Cloud Portal Using ShortPoint


Before you start:

  • We will use SAP Destination to connect with SharePoint 2013 On-Premise environment. If you want to know more about SAP Destinations, you can read the documentation here
  • We are connecting to SharePoint 2013 On-Premise with Basic Authentication
  • We are using REST\OData query to load content from SharePoint

ShortPoint can be used to show the data available on an external application, that you would like to show uniquely, you can configure ShortPoint Widget along with SAP Destination to read those data and present them in a beautiful way using ShortPoint elements.


Step 1: Connect with SharePoint On Premise 2013:


We need to create a new Destination to connect with SharePoint, 

Open your Cloud Portal Cockpit > from the left panel Choose Destinations




Now from the right panel, click on "New Destination"





A form "Destination Configuration" will appear as follows





In this example we are connecting with SharePoint On-Premise website using REST query as Destination URL(_api/web/lists/GetByTitle('Announcements')/Items?$select=Id,Title,Body) with Basic Authentication. This query loads items from SharePoint list called Announcements, we also specified to return only Id, Title and Body fields for each item.



blob1476358037067.png




Step 2: Register the Connection on ShortPoint



Generate Config files


In order to use the destination in ShortPoint you have to register it in two config files. But to make things easy for you, we have created a simple page that will generate config files based on Destination Name.

You only need to specify the Destination name and the Connection name in the field Destination Connections. Connection name is a name user will see in Connect panel of ShortPoint Inserter.




In our example we want this connection to appear with name Announcements. You can specify as many connection pairs as you want, each in separate line.

When all connections are listed there, press Generate button.


Copy Config generated files

When files are generated, copy their content to corresponding files in SAP Web IDE. 


You can find more information on Config Generator page.




Step 3: Redeploy the Widget


To Deploy the Widget, right click on folder shortpoint-widget-beta > Deploy > Deploy to SAP HANA Cloud Platform




Then the Dialog “Deploy Application to SAP HANA Cloud Platform” will appear, choose Deploy an existing application, and click Deploy




Step 4: Connect Tickers ShortPoint to Announcement SharePoint library


Open the blue Insert button




Search for "Tickers" and click on it


blob1476358396757.png


Go to the "Connect" Tab


blob1476358447898.png


Choose "Announcements" from the "Connection Type" drop down menu, and click "Connect"


blob1476358601351.png


Wait for few seconds, until connection is established, once the connection is done, a green info box will appear telling you that "ShortPoint is Connected to Announcements" as in the next image


blob1476358668489.png


Now get back to the "Items" tab


blob1476358754728.png


You will notice that next to each field now we have a "Link" button, 

Because we will not add items one by one, instead, all the items will be coming from the connection that we have just done,

We will use this "Link" button to specify which metadata from the connection will be used for this field.


blob1476358913750.png


In our example, we want the "Title" from the Connection to be displayed as a Title for the "Ticker"


blob1476359193922.png


We have configured what data to be shown inside our Ticker from the SharePoint Connection,
Now let us update the settings for the ticker to make it look appealing.


Open the "Settings" tab


blob1476359306927.png


And update the following options, as in the next image:

  • Title: "Breaking News"
  • Style: "solid"
  • Size: "medium"
  • Color: "warning"


blob1476359380995.png


Click Insert, to add it to the Widget




Your Ticker is now inserted into the widget, and the link icon indicates that it is connected, and the rendered data will be coming from the connection itself

hZ-I1DPUd3mPAJnyE5X24ipD2Cn8s_fcSQ.png


Hit the Save button




And you will see a nice golden ticker that shows data right from your SharePoint Server, how cool is that!


blob1476359627166.png






Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

World's best intranet sites are designed using ShortPoint

Get started today! Learn more
See all 6 topics

Start a trial

Ignite your vision. Install ShortPoint directly on your site, or play in sandbox mode. No credit card required.

Get started today

World’s best intranet sites are designed using ShortPoint

Thousands of companies using ShortPoint everyday to design, brand and build award winning intranet sites.

Get started Learn more