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
   
   
   
   It's also possible to load data on BW side using a datasource (based on the previous calculation view created) on WB*_HANAIV source system.

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