Document Properties
Last Modified
Added to KB
Public Access
Doc Type
Feature Lists
BI Data Hub
Feature List - BI Data Hub Service

Product Version

BI Data Hub 1.0

Product To Version


New Labels

1 Introduction

This document describes feature of the BI-Data-Service. The BI Data Service provides various data as output. 

2 Feature List

As this product is a data service, the retrievable data are considered as features. Available are:

  • Order data

  • Product data

  • Order states (are contained in the order data) 

2.1 Order Data

The following data is provided:

2.1.1 Base Order Data

  • First and last name of the buyer

  • Creation date

  • Currency

  • Customer and their ID

  • Document number

  • Total in gross and net and their tax

  • JSON value how it was delivered from Intershop Commerce Management

  • Order state

  • Order URN (the unique identifier for the order including the channel and organization)

  • List of shipping buckets

  • Used payment method

  • Used promotions (e.g. limited tenders like vouchers)

2.1.2 Shipping Bucket Data

  • List of Product Line Items

  • Shipping method id

2.1.3 Product Line Item

  • Name of the product

  • SKU

  • Quantity

  • Single gross and net price

  • Product ID (consists of SKU and channel)

2.1.4 Payment

  • Payment base amount

  • Payment total amount

  • Payment ID

2.1.5 Order States

The order states are delivered via an own Microservice and are taken from Intershop Order Management. You can specify an interval which determines how often the order states are updated.

2.2 Product Data

2.2.1 Base Product Data

  • SKU

  • Name

  • Short description

  • Image link

  • Default category and name

  • The category path of the product (a list)

  • List of assigned categories

  • Creation date (from this Microservice and not from Intershop Commerce Management)

  • Last update (from this Microservice and not from Intershop Commerce Management)

The last two values creation date and last update can be used to check whether a product was available in a specific period of time, for example to calculate the best/slow sellers in this time

2.2.2 Category Path Data

  • Name

  • Path ID

  • URI (for accessing via REST)

2.2.3 Assigned Categories

  • Title

  • URI

3 Accessing the Data

You can access the data with any tool which supports access to the SQL server database. For that you need the server location, the username and the password. These information will be generated while running through the on-boarding process and provided by the R2D2-Team (and later by the Cloud Operations Team).

For example if you want to access the data within Power BI, you can use the DirectQuery.


The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

The Intershop Customer Support website uses only technically necessary cookies. We do not track visitors or have visitors tracked by 3rd parties.

Further information on privacy can be found in the Intershop Privacy Policy and Legal Notice.
Customer Support
Knowledge Base
Product Resources