Monday, December 26, 2016

DXC H100

Quiz on DXC/Batch (test yourself):
https://quizlet.com/177259523/dxcdashboard-flash-cards/

Link to DXC/Batch Blog (other helpful links):
http://sapcerto.blogspot.com/2016/12/dxc-dashboard.html


DXC:  Batch driven data acquisition technique that relies on BW extractors


  • Out of the box foundation data models 
  • low TCO(total cost of ownership) data acquisition method for SAP HANA
  • leverages existing delivered data models
DXC:
  • Loads data in the "embeded" SAP BW system
  • Business Content DataSource Extractors deliver data directly to SAP HANA
  • form of ETL done by the source system by ABAP extractors
Benefits:
  • Leverages pre-existing foundation data models of SAP Business Suite for use in SAP HANA data mart scenarios
    • reduces complexity in Data Modeling tasks in SAP HANA
    • Speeds up timeliness for implementation projects
  • Provides semantically rich data from SAP Business Suite:
    • Ensures that data appropriately represents the bzn docs from ERP
    • logic built into the extractors
  • Simplicity and low TCO
    • Reuses existing ETL mechanisms over HTTP connection to SAP HANA
    • No addt'l server or apps are needed in system landscape
  • Change data capture(delta handling)
    • Efficient data acquisition: DXC brings new or changed data into HANA
    • provides a mechanism to properly handle data from all delta processing types
Embedded BW system:  generally un utilized; have it installed in a different server 

  • can use scheduling and monitoring features of embedded BW system, but not it's other features such as Storing data, DW or reporting and BI
  • DXC extraction process bypasses the normal data flow, and sends data to SAP HANA

IMDSO (IN memory dataStore Object): generated in SAP HANA, corresponds to the structure of the Data Source worked on; consist of several tables and an activation mechanism; used to build data models (attribute, analytical, and calculation views)

Data is transferred from the source SAP BW using HTTP connection.  extraction and load process is virtually the same as when extracting and loading data into SAP BW;  rely on infoPackage scheduling, the data load monitor, process chains


Creating and Activating a Direct Extractor Connection: configure and start a data replication b/t a SAP source system and SAP HANA system

1)  starts SAP logon and log on to the TAS system:SAP front end -> SAP logon
  • client
  • User
  • PW
  • Language

2)  Content table SFLIGHT; table included in data source; replicated to the SAP HANA system
  • execute transaction SE16
  • enter SFLIGHT in table name; data browser: table SFLIGHT: Selection Screen
3)  Check the DXC parameters in table RSADMIN:
  • Execute transaction SE16:  SE16 is a T-code for object browser.
       generally used to search the fields of SAP Tables . and respective data
  • table name: RSADMIN; Data Browser: Table RSADMIN: Selection Screen opens
  • Filter by object, enter PSA*  choose the EXECUTE button
4)  Create a new data source HA_SFLIGHT_01

  • data source based on a transaction table SFLIGHT
  • Expand generic DataSources node and choose maintain Generic DataSources
  • Transaction data field, enter HA_SFLIGHT_01 and choose Create
  • Applic. Component field, enter training
  • 3 description fields, enter (copy/paste) SFLIGHT Data Source
  • View/Table field, enter SFLIGHT
5) Replicate Metadata and activate the data source based on application component TRAINING
  • Execute transaction RSA1
  • Documentation on Modeling Area dialog box opens
  • Select Modeling --> Data Sources item
  • DataSources for TASCLNT200 tree, right click SAP app Component --> Training and choose Replicate Metadata
  • DataSource type, select Data Source (RSDS) radio button
  • Right click on HA_SFLIGHT_01 data source and choose change
  • activate
6)  Check the new SAP HANA optimized DSO(data store object)  has been created
  • Start Studio and open Modeler Perspective
  • Display tables node in Systems view
7)  Create an info package to load data into HANA system
  • execute transaction RSA1
  • Modeling --> DataSources Item
  • DataSources for TASCLNT200 tree, R.click SAP APP componetnts --> Training --> SFLIGHT data source... choose InfoPackage
  • Schedule tab: select start data load immediately
8)Display the replicated data

Condensed Version
---------------------------------------------------------------------------------------------------------------------
1     1)      Logon 
2     2)       Content table/data src (SE16) 
3     3)      DXC parameters( Execute SE16)
4     4)      Create new Data SRC
5     5)      Replicate MetaData -> Activate Data SRC
a.       Execute Transaction
6     6)      Optimized DSO created
a.       Display tbl nodes in system view
7     7)      Create info pkg to load data into HANA
a.       Execute transaction
b.       RSA1 (Modeling - DW Workbench)
c.       Schedule Tab

8      8)      Display Replicated Data


No comments:

Post a Comment