Importing OData Services Data to a New or Existing Model

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 data 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. You can also save your OData connection details, and schedule model updates and data imports from OData sources.

Context

Note
  • 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. The following table lists the minimum requirements for generic OData:

    Data Type

    Operator

    Format

    String (Edm.String)

    "eq", "ne", “startswith”, “toLower”

    "eq", "ne", “startswith”, “toLower”;

    Number (Edm.Decimal)

    "gt", "ge", "lt", "le", "eq", “ne”, "M"

    [value] m

    Number (Edm.Double)

    "gt", "ge", "lt", "le", "eq", “ne”, "d"

    [value] d

    Number (Edm.Single)

    "gt", "ge", "lt", "le", "eq", “ne”, "f"

    [value] f

    Number (Edm.Int16)

    "gt", "ge", "lt", "le", "eq", “ne”

    Number (Edm.Int32)

    "gt", "ge", "lt", "le", "eq", “ne”

    Number (Edm.Int64)

    "gt", "ge", "lt", "le", "eq", “ne”, "L"

    [value] L

    Datetime (Edm.DataTime)

    "gt", "ge", "lt", "le", "eq", “ne”

    Datetime (Edm. DataTimeOffset)

    "gt", "ge", "lt", "le", "eq", “ne”

    Boolean (Edm.Boolean)

    "eq", "ne"

    True|False

    Edm.Guid

    "eq", "ne"

    guid’[value]’

    Logical Operator

    “and”, ”or”

  • Embedded Complex types are not supported.

Procedure

  1. Go to the Models list: select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  ModelsEnd of the navigation path.
  2. Select the appropriate option:
    • If creating a new model: Select Start of the navigation path Next navigation step Get data from an app Next navigation step OData ServicesEnd of the navigation path.
    • If importing to an existing model: In the Import Data menu, select Import Data From OData.
  3. Select the OData Services connection 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

        Note
        To connect to an On-Premise OData service, ensure that the following tasks are completed:
        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.

      • Connect to an SAP OData serviceSAP Hybris Cloud for Customer Analytics: 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 SAP Hybris Cloud for Customer Analytics 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.
  4. Select your connection or select Create New Connection to create a new connection.
    For more information, see Import Data Connection to OData Services.
  5. Select your query or select Create New Query to create a new query.
  6. In the Create New Query dialog, enter a name and a description for your query.
  7. In the Select Data area, select a table to build your query, and then select Next.

    Select (Refresh list) to display the list of reports from SAP Hybris Cloud for Customer or SAP Business ByDesign Analytics in real time.

  8. In the Build a Query dialog, build your query by moving data elements into the Selected Data and Filters areas, and then select OK. For more information see, Building a Query.

Next Steps

After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.