CRM and CX Blogs by Members
Find insights on SAP customer relationship management and customer experience products in blog posts from community members. Post your own perspective today!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Hybris - Data Hub Installation

former_member290585
Explorer
‎03-14-2017 10:56 AM

SAP Integrations


SAP integrations provide a framework for connecting the Omni-commerce capabilities of SAP Hybris Commerce with other SAP products.



Architecture of SAP Integrations


SAP integrations involve various possible system landscapes, types of communication, data transfer processes, and SAP-specific configuration settings.



For now, let's focus on Hybris Data Hub Concept.

Data Hub



  • Data hubs are an important component in information architecture.



  • A data hub is a database which is populated with data from one or more sources and from which data is taken to one or more destinations.



  • A database that is situated between one source and one destination is more appropriately termed a “staging area”.


Hybris Data Hub


Receives and sends data to SAP ERP or to hybris (data replication in both directions).

example: Hybris Data Hub can replicate product master data from SAP ERP to hybris, or send orders from hybris to SAP ERP.

  • It can be used to connect hybris to non-SAP systems.




Execution takes place in following major steps:

  1. Load (raw format)

  2. Composition (canonical format)

  3. Publication (target format)



  • It also acts as a staging area where external data can be analysed for errors and corrected before being fed into hybris.




 

1.Raw items come directly from the source system.

  • The data they contain may undergo some preprocessing before entering the Data Hub.


2.Canonical items have been processed by Data Hub and no longer resemble their raw origins.

  • They are organised, consistent, and ready for use by a target system.


3.Target items are transition items.

  • The process of creating target items reconciles the canonical items to target system requirements


 


Feeds and Pools



  • Data Hub enables the management of data load and composition with the use of feeds and pools.



  • Fragmented items can be loaded into distinct data pools using any number of separate feeds.



  • Feeds and Pools allow a fine level of control over how data is segregated and processed.


Data Feeds



  • Data feeds enable you to configure how raw fragments enter Data Hub.



  • When data is loaded using one of the available input channels, it is passed on to a data feed as specified in the load payload.



  • The data feed then delivers raw items for processing to a specified data pool.


Data Pools



  • Data pools enable you to isolate and manage your data within Data Hub, for composition and publishing.



  • During the composition of raw items into canonical items, only data isolated within each pool is used.


Step-by-step Procedure for Data hub setup in our local system.


Prerequisites:

1.Hybris - v6.2.0 (I'm using)

2.Apache Tomcat 7.x

3.JDK 1.8

4.MySQL

Step 1:

Create folders as below structure in any of the drive

datahub6.2

  • config

  • crm

  • erp

  • others




  •  Open your tomcat folder -> go to config -> create Catalina folder -> localhost folder -> datahub-webapp (create xml file)


Step 2:

Copy the data from below to the datahub-webapp (xml file)
<Context antiJARLocking="true" docBase="<YOUR_PATH>\hybris\bin\ext-integration\datahub\web-app/datahub-webapp-6.2.0.2-RC13.war" reloadable="true">



    <Loader className="org.apache.catalina.loader.VirtualWebappLoader"

            virtualClasspath=

			

                "<YOUR_PATH>/datahub6.2/config;

                 <YOUR_PATH>/datahub6.2/crm/*.jar;

	         <YOUR_PATH>/datahub6.2/erp/*.jar;

	         <YOUR_PATH>/datahub6.2/others/*.jar"/>

</Context>

Step 3:

<YOUR_PATH>hybris\bin\ext-integration\datahub\web-app



  • Go to the above path and copy both the path and file name


Step 4:

The copied path and file name should be pasted in the tomcat folder

Open your tomcat folder -> go to config -> Catalina folder -> localhost folder -> datahub-webapp



Step 5:

Now Start the Tomcat

Go to the following path

<YOUR_PATH>\apache-tomcat-7.0.73\apache-tomcat-7.0.73\bin

  • Run the command startup.bat through command prompt




  • Automatically runs the command in new command prompt as below




Step 6:

Observe the change in the folders after the server starts

Before:



After:



Step 7:

Now go to the datahub6.2 folder which we have created earlier

<YOUR_PATH>\datahub6.2\config



Step 8:

create the following files

encryption-key ----------- text format

local.properties ----------- properties file



  • Copy the key 32digit key and paste in encryption-key file

  • Copy the following code into local.properties file


#DB Setup

dataSource.className=com.mysql.jdbc.jdbc2.optional.MysqlDataSource

dataSource.driverClass=com.mysql.jdbc.Driver

dataSource.jdbcUrl=jdbc:mysql://localhost/datahub?useConfigs=maxPerformance

dataSource.username=root

dataSource.password=root

#media storage

mediaSource.className=com.mysql.jdbc.jdbc2.optional.MysqlDataSource

mediaSource.driverClass=com.mysql.jdbc.Driver

mediaSource.jdbcUrl=jdbc:mysql://localhost/datahub?useConfigs=maxPerformance

mediaSource.username=root

mediaSource.password=root

#Not why we need to set it here.

datahub.extension.exportURL=http://localhost:9001/datahubadapter

datahub.extension.username=admin

datahub.extension.password=nimda

#Not why we need to set it here.

targetsystem.hybriscore.url=http://localhost:9001/datahubadapter

targetsystem.hybriscore.username=admin

targetsystem.hybriscore.password=nimda

# Encryption

datahub.encryption.key.path=encryption-key.txt

# enable/disable secured attribute value masking

datahub.secure.data.masking.mode=true

# set the masking value

datahub.secure.data.masking.value=*******

kernel.autoInitMode=create-drop

#kernel.autoInitMode=update

#====

sapcoreconfiguration.pool=SAPCONFIGURATION_POOL

#sapcoreconfiguration.autocompose.pools=GLOBAL,SAPCONFIGURATION_POOL

#sapcoreconfiguration.autopublish.targetsystemsbypools=GLOBAL.HybrisCore

datahub.publication.saveImpex=true

datahub.server.url=http://localhost:8080/datahub-webapp/v1



Step 10:

Go to the following path

<YOUR_PATH>\hybris\bin\ext-integration\datahub\extensions\sap




Step 11:

copy the highlighted jar files into the following folder

Go to erp folder



Step 12:

Go to others folder



Download the mysql-connector-java-5.1.30-bin.jar file and copy to the others folder only the jar file after extracting the Zip file

Step 13:

Login to MYSQL workbench

  • Create a Schema as below




Step 14:







Step 15:

Start Tomcat server



Step 16:

Go to localhost:8080/datahub-webapp/v1/data-feeds



  • To Disable Spring secure
    Stop the server


Step 17:

Go to the following path

<YOUR_PATH>\apache-tomcat-7.0.73\apache-tomcat-7.0.73\webapps\datahub-webapp\WEB-INF

  • web (open the xml file) and comment the following code




Step 18:

Now Start the server





Step 19:

Tables will be loaded in a schema which was created in step 13.



In the next blog, I will be posting how to load data into data hub using IDOC, CSV  and also further by sending IDOC directly from SAP ERP to Hybris (Asynchronous Order Management).

Thanks for reading 🙂

 
24 Comments
Popular Blog Posts