You can see the virtual table and target table in HANA Web-based Development Workbench Catalog as below Virtual table is only pointing to the SAC models. The target table will store the data physically. Saving the replication task will create virtual table and target table in HANA. You could refer to the example in Load Behavior Options for Targets in Replication Tasks to decide which fits your delta. Preserve all: INSERTS all rows and includes CHANGE_TYPE, CHANGE_TIME, and CHANGE_SEQUENCE columns in the target.Replicate with logical delete: UPSERTS rows and includes CHANGE_TYPE and CHANGE_TIME columns in the target.Replicate, Preserve archived rows: Rows archived in the source are marked with a CHANGE_TYPE of M in the target.Replicate: Replicates changes in the source one-to-one in the target.For example, in BW HANA native datasource could be created with delta enabled. Two additional columns will be added automatically, which could be used later to detect delta to the next level Objects. “ Replicate with logical delete” is chosen. In order to use delta, I choose realtime here.ĭefine the load behavior. For the master data and other models, you can only load full. If you choose any model which does not support realtime (delta), you will get an error “API Provider cannot handle subscription creation” when saving the replication tasks. Only FactData in a planning model choose “realtime” or “fulload only”. Then you will open a replication task screen and can choose the Remote Source “SACDES” and your target HANA schema as below: Here is the HELP document how to create a replication task. In the workbench –> Catalog, you can expand the remote source to your SAC and see the models there. Step 1: check the Remote Source in SAP HANA is configured correctly. Here is how to enable it How to enable SAP HANA Web-based Development Workbench in SAP HANA. In this blog, we will use SAP HANA Web-based Development Workbench. Only relevant for BW on HANA and BW/4HANA How to process the data in BW as next stepsĮxtended topics for BW: how to extract delta from local HANA DB tables. How to set filter and do field mapping in replication taskĤ. How to monitor replication tasks and subscriptionsģ. Understand how the replication task and delta works between SACmodel and HANA DB tables.Ģ. Enable relevant tools:to create HANA replication task, either SAP HANA Web-based Development Workbench or Web IDE and SAP Business Application Studio should be used.ġ.Configuration to SAC is Configure HANA Smart Data Access sources. Here is how to Enable SAC Data Export Service The SDI replication task can be easily changed to full load w/o delta. If you are using SDI to get the data, I recommend you only consider delta when the full load is big enough eg: above 1000K and users can not wait more than several minutes.For a less than 1000k records SAC models, it is expected a full load takes less than 5 minutes in a normal situation. You need some efforts to implement it in a proper way. Hints: Depends on the business needs and data volume, delta does not mean a better solution. If you are on any ABAP systems and do not like to use the Smart Data Integration, you can implement this delta logic in ABAP, Data Intelligence, Integration Suite or other integration tools following this blog How to implement the delta logic in SAC Data Export Service Odata API at the Consumers side Realtime (delta) Data Replication from SAP Analytics Cloud to BW/4 HANA This does not require HANA Enterprise Edition. If you are on BW on HANA or BW/4HANA systems and would like to use ABAP controlled way, please refer to my previous blog. I would like to hear your feedback what are your preferred way for this integration. The others especially in S/4 HANA have concerns or restriction in company policies not to access the HANA DB level thus using SDI directly on HANA DB is no go for them. Some customers have chosen this way as an implementation and like the flexibility in HANA replication task like filters, monitor and field mapping from SAC models to HANA DB tables. The full load also applies to the analytic models in SAC. You can replicate SAC planning transaction data not only with delta but also only full. This blog is about how to use Replication Task in Smart Data Integration to replicate data from SAC to your on premise HANA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |