Hi guys,
I just made a screenrecording on how to execute the mentioned steps:
[How To Load CSV files into HANA|http://youtu.be/TzANTmNG5sw]
Hope it's usefull to someone.
Ronald.
Ronald:
What can I say? Thank you! This is going to be very useful for a lot of people -:) Good job!
Greetings,
Blag.
Thank you for putting together this video, Ronald. We are going to post the link to your video in the [SAP HANA Developer Center website|http://www.sdn.sap.com/irj/scn/index?rid=/webcontent/uuid/c022341c-5ed1-2e10-0b98-9b6a3314dd25]. Great job!
Cheers,
Gigi
How nice!
I also written an article called SAP HANA Developer Access Beta program - 7 steps towards your first HANA report. Unfortunately I cannot upload it at the moment as the content submission system seems to be out.
Gr.,
Ronald.
I also written an article called SAP HANA Developer Access Beta program - 7 steps towards your first HANA report. Unfortunately I cannot upload it at the moment as the content submission system seems to be out.
That's because we're migrating to the new SCN -;) You should be able to upload your article soon...looking forward to read it -:)
Greetings,
Blag.
how did you come up with 7? i really like that number.
Hi Blag,
That explains ![]()
Drop me a mail if you want to have a copy in advance!
Hello,
I created wiki page regarding the import:
http://wiki.sdn.sap.com/wiki/display/inmemory/ImportingCSVfilesintoSAP+HANA
I am interested in constructive criticism - please suggest what can be improved.
@R. Konijnenburg
Would you consider making new video along the steps of the procedure?
Tomas
I am interested in constructive criticism - please suggest what can be improved.
Excellent Tomas! -;)
Greetings,
Blag.
how would the result of this
SELECT COUNT(*) FROM
differ from the records count in the table "Runtime Information"?
maybe, there's a way to eliminate this step and reduce the number of steps from 8 to 7.
Hello,
how would the result of this SELECT COUNT(*) FROM differ from the records count in the table "Runtime Information"?
I believe it is same - however SQL Editor was mentioned in procedure several times so users following the steps should know what to do while trying to send them to "Runtime Information" tab in table properties might be confusing... (my opinion)
maybe, there's a way to eliminate this step and reduce the number of steps from 8 to 7.
Well my intention was not to keep it as short as possible but as simple as possible. Last step is of course optional and can be skipped. Maybe I should highlight it is optional... but I guessed it is clear from the step description.
However if I would have just 7 steps I could follow Ronald's example and rename the wiki page to:
SAP HANA Developer Access Beta program - 7 steps towards your first imported table
just kidding ** :-D
Anyway thanks for feedback.
Tomas
SAP HANA Developer Access Beta program - 7 steps towards your first imported table
what keeps you and Ronald from publishing it in the new and redesigned SDN blog page?
just make sure you have a backup, but that's a middle name for any Basis guy, so this sentence is redundant.
Apparently we cannot subit articles yet. Go live on the 12th.
Hello,
what keeps you and Ronald from publishing it in the new and redesigned SDN blog page?
Actually I believe that wiki is more suitable for this... (so I created wiki page)
Tomas
Hi All,
we cannot directly upload the file into HANA. To do so, Please follow the following steps:
1. Firstly place the file on the application Server.
2. Then, a file called ".ctl" is prepared on the Linux platform.
3. In this file, the source and destination path should be given and then excute the file.
4. file will load into HANA
I hope this information helpful for all.
Regards,
Neha