Page History

The new wiki link for this data flow is here:

Connection with SDI 

Please update the new doc there and no longer here.

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 :
   
   Image Modified
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)
      
      Image Modified
      
      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
   
   Image Modified
4. The table is available on calculation view
   
   Image Modified
5. For each calculation view, there is an associated datasource based on the calculation view that permit to load data into BW :

Image Modified

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 :

Image Modified

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

Image Modified

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
   
   Image Modified
   
3. Choose the replication task modified and assign it to your transport request

Image Modified

How to add a new field in an existing SDI datasource ?

1. Go to the replication task in which the new field will be added on WEB IDE Tool.
2. Delete the virtual table associated to the replication task :
   Image Added
   
   Image Added
3. Select the Source Remote Object (1) and click to add (2) and then choose the new field from remote object (3) :

Image Added

4.Re-create the virtual table choosing the remote table source :

Image Added

5.Activate and run the replication task.

6. Update the associated calculation view to add the new field in the projection step based on TB* table

Image Added

7. Replicate the datasource based on the previous calculation view to display the new field

Image Added

Transport :

Be careful, before transporting the replication task  you need to :

1.Delete the virtual table in the target system (refer to step 2.).

2. Ask to Dynasys Interface Team to add the new field in the Dynasys view on Test System or Prod System (if you move to prod).

3. Recreate the virtual table (refer to step4.)

4. Check the new field is available in the virtual table

5. Move the TR with the replication task on the target system.