Import Data Connection to OData Services

You can create a connection that allows you to import data from data sources (such as, SAP Hybris Cloud for Customer, SAP Business ByDesign Analytics, and so on) using customized OData source types. You can also create a connection that allows you to import data from both on-premise and cloud data sources using generic OData services. It is possible to request a customized OData data source solution.

Prerequisites

To connect to an On-Premise OData service, completed the following tasks:
  1. The cloud connector is installed. For more information, see Installing the SAPCP Cloud Connector.
  2. The cloud connector is configured. For more information, see Configuring the SAPCP Cloud Connector.

The SAP Analytics Cloud agent doesn't need to be installed during the configuration process.

Context

Note
  • While OData exposes one-to-many navigation, SAP Analytics Cloud cannot follow these relationships because doing so would distort the measures at the parent level. OData v4.0 supports Lambda operators “any” and “all”, which can reduce the collection of children to a single Boolean value. For this to work, however, both the server and SAP Analytics Cloud must support OData v4.0. Currently, SAP Analytics Cloud supports only OData v2.0. As a result, one-to-many navigation properties will be hidden to the end user until OData v4.0 is supported on both sides. As a possible alternative, select the child entity as the main entity for the data query and use the parent entity as the navigation property.

  • SAP Analytics Cloud supports OData Version 2.0. Logical Operators (such as Equal, Not Equal, Greater than, Greater than or equal, Less than, Less than or equal, Logical and, Logical or) are supported. Not logical negation, arithmetic operators, or functions are not supported.

  • Embedded Complex types are not supported.

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection) Next navigation step Import Data Connection Next navigation step ODataEnd of the navigation path
  2. In the New OData Connection dialog, do the following:
    1. Enter a name for the connection.
    2. Select the data source type.

      The following data source types are available:

      • SAP Hybris Cloud for Customer: Use this data source type to connect to the SAP Hybris Cloud for Customer General OData API, which exposes lower level data objects used to create analytics in SAP Analytics Cloud.

      • SAP Hybris Cloud for Customer Analytics: Use this data source type to connect to the SAP Hybris Cloud for Customer Analytics OData API, which exposes analytical objects (reports) that users have already created in SAP Hybris Cloud for Customer products.

      • SAP Business ByDesign Analytics: Use this data source type to connect to the SAP Business ByDesign Analytics Analytics OData API, which exposes analytical objects (reports) that users have already created in SAP Business ByDesign products.

      • OData Services: Use this data source type to connect to new OData Services using a generic OData driver. If you select this data source type, you can select the following options:
        • Connect to an On-Premise OData service: Make sure to complete the prerequisites before connecting to an On-Premise source using a generic OData driver. If this option is not selected, the driver will connect to cloud OData data sources.

        • Connect to an SAP OData service: When you select this option, specific SAP metadata is respected. This metadata specifies default behaviors based on SAP OData services guidelines; for example, filterable and sortable are by default true, if not claimed to be false, and support basic filter operators. For more information see, SAP Annotations for OData Version 2.0Information published on SAP site.

        Note
        Advanced features of customized OData data sources, such as SAP Hybris Cloud for Customer and SAP Business ByDesign Analytics, are only available using customized data source types. These features are not available using generic OData services. It is highly recommended to use the relevant customized data source types, if available, for your data service to leverage full capability of the data connector. It is possible to request a customized OData data source solution.
    3. Select the authentication type.
    4. Enter the Data Service URL published during your configuration.
      Note
      For an “OData Services” type of connection, you may add extra url parameters in the Data Service URL field. This is to accommodate some data sources specific constraint on authentication. For example, you may pass in the saml2=disabled parameter to disable SAML, or sap-system-login-basic_auth=X to disable custom login. All the parameters entered in the Data Service URL field (anything following “?” in the url) are only used in the authentication flow, and are ignored in the data queries.

      For any other specific OData types of connection, all the parameters entered in the Data Service URL field are ignored in both authentication and data queries.

    5. Enter the User Name and Password of the user you want to import data from.
  3. Choose Create.
    The new connection is added to the list of connections on the Connections screen.