Migrate data from Greenplum Database to SAP HANA

[matthias-landowski]

Hello,

we are facing a customer who want to change his Greenplum Database to SAP HANA.
I just wanted to aks i anybody have done something similar before?
There are only 2 Ways i can imagine to transfer the whole Data into SAP HANA. This would be either SLT (System Landscape Transformation) or SDA (Smart Data Access). I am wondering if a SAP System is needed to use SLT or if it is working out of the box without a System.
The only think i know, the Greenplum Database is also using ODBC.
Maybe somebody could just give me an advice on how to transfer Data from non SAP Databases to SAP HANA.

Best Regards
Matthias

[dvankempen · Accepted solution]

Hi Matthias,

SLT or SAP Landscape Transformation replication server in full requires SAP NetWeaver AS ABAP (see the entry on the product availability matrix for the details). It supports both SAP and non-SAP sources and using generic ODBC, I assume Greenplum would work just fine as well.

SAP HANA smart data access (SDA) is a federation feature, enabling you to connect to remote sources (linked database) and creating virtual tables which stores the metadata of the remote objects locally. This enables you to join local tables to remote tables, create views, etc. For data transfer, SAP HANA smart data integration (SDI) is the tool to use. This allows for transformations (ETL).

Note that SLT and SDI replicate data. To migrate non-SAP application(s), using the SAP Advanced SQL Migration tool would be more suitable, see

• https://blogs.sap.com/2020/08/06/set-your-databases-free-with-sap-advanced-sql-migration-2/

Send a message to Advanced_SQL_Migration @sap.com for more information on this topic.

[matthias-landowski]

Thank you guys for the answers.
For now the customer wants to migrate his data from non-SAP applications to SAP HANA, without any Netweaver on top.
But i will get tomorrow some more clear answers for that.
So i will keep SAP advanced sql migration in mind, since this sounds for the best solution right now.
If i will have further questions i will contact you guys via email.

Is there any possibility to calculate the needed space for the migration?
In SAP ABAP you can run report HDB size. But is there anything similar for non-SAP applications?
Thanks a lot again.

Matthias

[michael_eaton3]

Hello

Moving data from one platform to another is often considered a relatively easy technical task, and it can be, as there are many tools that connect via JDBC/ODBC/API/etc. from a source and write to a target, but if the data is used for critical business operations, then you might consider dedicated data migration software, for example SAP Advanced Data Migration.

Do you want to simply move the data, or do you need to migrate the data? They are very different things (although most people only realise this after a failed data migration!)

Michael