SAP Dashboards Data Connections - SAP Dashboards

How to connect data sources in dashboard?

Dashboards allows you to connect your model to an external data source. While running the data model then it will be updated as current data information in the data source. Here are some ways to connect to an external data sources-
  • Using an External data connection in Data Manager
  • Create query from BI source

Managing Data Connections

To manage the data connections using the Data Manager (CTRL + M). To open the Data Manager, go to Data → Connections as shown in the following screenshot.
connections
Here are data connections that supports in SAP Dashboard Designer−
  • Query as a Web service (QWAAS)
  • Web Service Connection
  • SAP NetWeaver BW connection
  • XML Data
  • Crystal Report Data Consumer
  • Live cycle Data Services
  • External Interface Connection
  • Live Office Connections
  • Web Dynpro application as Flash Island and many more as below.

Adding an External Data Connection

See following screenshot to add an external data connection, go to Data → Connections.
connections
Go to the Data Manager Dialog Box, click on Add Connection and select a connection type from the list.
data_manager
Then it will configure the data connection in the next step.
To delete a connection, select the connection in the data manager and click on the Delete button.

How to Configure a Query as a Web Service?

To configure a query as a web service, go to Data → Connections. In the Data Manager dialog box, click on Add → select Web Service Query.
web_services_query
In the Definition window, enter the following details −
  • Name − A name for the connection.
  • WSDL URL − Type URL for WSDL generated by the web service query or select from the list. Click Import.

definition_window

Select the method from the drop down list. When you select the method, the web service URL is displayed.
RunQueryAsAService
This web service call is generated for index unaware prompts.
This method requires an Enter_Year_As string as the prompt value for year.
RunQueryAsAServiceEx
This web service call is generated for index aware prompts. The input and output parameter sets are the same as for RunQueryAsAService method except for the input prompt for year values.
This method requires an instance of LovValueIndex for year.
Valueof_
This method is generated only when the Web service query encloses atleast one prompt and is intended to provide a list of values for the prompt it is named after.

Input Value −

Input Values
When you import the WSDL, the required inputs defined for the web service are displayed in this list. To set a value for each item, select the input object from the list then set theRead Fromoption to map it to your model.

Read from and Output Value −

Read From
If the input values list includes items that require input, select the input item and then click the cell selector (selector) to select a cell from the embedded spreadsheet where the selected object will retrive its value.
Output Values
When you import the WSDL, the output parameters for the results object in the web service are displayed in this list.
In the Usage tab, set the refresh and message options as shown in the following screenshot.
usage_tab
In a similar way you can configure other external data connections as well in the Dashboard.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP Dashboards Topics