Connection with SDI

Connection with SDI

With the migration to the Cloud and the new connection type available with HANA, it has been decided to create a new connection between Dynasys and BW using SDI (Smart Data Integration).

The SDI is able to create the table on HANA and this can be used directly on calculation view or BW datasource.

As we have a large volume for transactional data in Dynasys, it is a good option to implement this type of connection.

With UD Connect it was necessary to clear the cache of the datasource strcuture in J2EE Layer in case of modifications, not anymore with SDI.

How to add a new Dynasys Table with SDI ?

Before continue, it is mandatory to have access to the WEB IDE tool => See the link  SAP WEB IDE.

And also see Dynasys Catalog :

1. Target Schema = TB_DYNASYS
2. Virtual Table Schema = VT_DYNASYS

 The storage of the data is organized into 2 different catalogs on HANA DB:

• Target data: TB_DYNASYS 
• Virtual table VT_DYNASYS

1. The first step is to create a new replication task named "RT_" + "Dynasys view technical name" under the package "RT_DYNASYS" like below :
   
   
2. Replication task properties  
   1. Remote Source = RS_DYNASYS
   2. Target Schema = TB_DYNASYS
   3. Virtual Table Schema = VT_DYNASYS
      
      Please find below an example on an existing Dynasys table (EXP_DFU_DR_BW)
      
      
      
      Source Remote Object => Select the Dynasys view
      Source Virtual Table => Must be prefix by VT*
      Target Name => Must be prefixed by TB*
      
      
3. Check the new tables created and make a data preview (if possible) on HANA
   
   
4. The table is available on calculation view
   
   
5. For each calculation view, there is an associated datasource based on the calculation view that permit to load data into BW :

How to load data from Dynasys into BW ?

Before the loading of the DTP, it is important to fill the VT_* tables from Dynasys using the replication tasks.

We'll not run every tasks manually but we'll use the program ZBW_RUN_REP_TASK.

An associated Variant is existing for each Dynasys view.

In the variant you must fill the Schema and the replication task to run like below :

Then, the program will be used in the process chain before the stop of TP running.

Transport of replication task

1. Use the T-CODE SCTS_HTA with SAP Logon.
2. Go to the Dynasys package Solvay.ETL.RT.RT_DYNASYS
   
   
   
3. Choose the replication task modified and assign it to your transport request