Skip to Content

Cluster/Pool table data migration using Data Services

Mar 07, 2017 at 12:56 PM


avatar image

Can SAP Data Services move data for cluster pool tables directly via data flow

or requires any tool or transformation?

is SAP DS having out of box solution for cluster or pool tables?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Sasi Mar 08, 2017 at 10:24 AM

What is the exact requirement?

Which is the Database which contains the Clustered or Pool tables(I suppose it should be Oracle)?

Where do you want to move the data from Clustered tables to?


Arun Sasi

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Moving SAP tables [ Oracle data base/DB2 ] to Hadoop or other database

presently we are using a tool which uses 3rd party add-on to ingest cluster and pool table.

Since SAP DS is homegrown , wanted to know if it handles it out of box and how it handles these tables.

also since cluster tables are large tables , how much it usually takes for them to load.



You can use SAP Tables in a ABAP data flow and use fake partitions and Indexes.

Refer SAP Supplement Guide for more reference


Arun Sasi

qb81q.png (50.3 kB)

thanks for the details Arun,

my question is on how it handles cluster / pool tables.

Presently we are using a hvr tool , it can only move data for transparent tables out of box system.

For moving data to cluster/pool tables , they have a 3rd party tool , which we need to install for this process.

so if we use SAP data services , will it be able handle all types of tables out of box system or not ?