Data Migration to S/4 Hana

Question

Post reply

Data Migration to S/4 Hana

Steve Dell

SSCarpal Tunnel

Points: 4623
More actions
December 31, 2019 at 11:54 am

#3711399

Hi ,
I Would like to migrate the data from Flat files to the S/4 Hana database . Can i do that using the ODBC connection?
If some one has implemented it or has any knowledge can you please share your experiences or steps to be implemented using SSIS ? I am assuming that we cannot insert data using ODBC connection .
Thanks in advance 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 2

With the disclaimer that this is the first I've ever even heard of {SAP} S/4 Hana databases...

I assume that, since you're posting on an SQL Server forum and mentioned SSIS, S/4 Hana is SQL Server on the backend (in this case). That means it's not really that much different than anything else in SQL Server when it comes to imports.

If that's true, that means it will boil down to the same thing that one suffers when working with applications and their data... you need to know what the flat files contain and where the data needs to go in the application database. That means that you need extreme esoteric knowledge of both. For the S/4 Hana side of that, you need some serious documentation on what is required in the database. If you're having difficulty in finding such documentation, you might want to call the vendor and tell them what you're trying to do in some good detail, especially about what is in the flat files. It's unlikely that you're the only one in the world to import data to S/4 Hana and they may actually have a set of stored procedures or a GUI at the ready to help.

Remember that the answer is always "No" unless you ask. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

frederico_fonseca SSCoach Points: 16008 More actions · Answer 3

really annoys me when people don't even bother searching for what they need.

hana studio and Hana client are required - you get those from SAP

first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/

yes you can do it with odbc - yes it can do updates - if it could not it would not really be odbc compliant.

and as always you should be asking the vendor for this info and searching their site for it where you can't find it on google.

depending on some other aspects of what you need you may wish to use C# instead - again google has examples https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/469e20f56d6110148618da80690c499b.html

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 4

frederico_fonseca wrote:

really annoys me when people don't even bother searching for what they need.
hana studio and Hana client are required - you get those from SAP
first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/
yes you can do it with odbc - yes it can do updates - if it could not it would not really be odbc compliant.
and as always you should be asking the vendor for this info and searching their site for it where you can't find it on google.
depending on some other aspects of what you need you may wish to use C# instead - again google has examples https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/469e20f56d6110148618da80690c499b.html

It looks to me like the C# examples on the link you provided also provide the SQL needed to do T-SQL Inserts, Updates, and Deletes within the examples (which could also be easily translated into BULK INSERTs). Is that a reasonable assessment on my part?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

frederico_fonseca SSCoach Points: 16008 More actions · Answer 5

Jeff Moden wrote:

frederico_fonseca wrote:
really annoys me when people don't even bother searching for what they need.
hana studio and Hana client are required - you get those from SAP
first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/
yes you can do it with odbc - yes it can do updates - if it could not it would not really be odbc compliant.
and as always you should be asking the vendor for this info and searching their site for it where you can't find it on google.
depending on some other aspects of what you need you may wish to use C# instead - again google has examples https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/469e20f56d6110148618da80690c499b.html
It looks to me like the C# examples on the link you provided also provide the SQL needed to do T-SQL Inserts, Updates, and Deletes within the examples (which could also be easily translated into BULK INSERTs). Is that a reasonable assessment on my part?

Possibly - but perhaps for pure bulk a different method is required as per https://blogs.sap.com/2016/03/07/using-the-net-odbc-connection-to-bulk-insert-data/

It is possible that the SSIS odbc option also allows bulk processing. I can't be certain as I have extremely limited access to the Hana instances on my shop.