SAP HANA DB on AWS

[Former Member]

Hi Friends,

I have setup an SAP HANA AWS instance on Amazon. Can you help with the following:

I have HANA DB 1.0 SP04 Rev 28 and HANA Client and Stuio on SP04 (REV 27)

1. Currently the AWS instances come with the following : m2.xlarge = 17 GB HANA, m2.2xlarge = 34 GB HANA & m2.4xlarge = 68 GB HABA.

I realize there are other sizes also available . But where can I find the matrix to look for a 256 GB, 512 GB and 1024 GB HANA. Is there any matrix available like the very understandable one you provided on the top of the blog.

2. I wanted to up;load CSV file into my AWS instance. Is there any easy way to do this other than using the CTRL file method. Can I directly load using excel.

3. What is the Port Number to be used to FTP files to HANA DB Server, to upload files.

4. Currently the HANA Studio and Client in the link above are Revision 27. When is the revision 28 going to be available. The reason I was keen on revision 28 is because the file upload mechanism into HANA is very straightforward.

5. Is there any Reporting Tool available on the cloud readily,  like the BO Explorer, Visual Intelligence or Predictive Analysis, that we could use to connect to the HANA AWS to perform Reporting.

6. Is ther any provision to perform SLT on AWS.

Any inputs on any of the above will be very much appreciated.

Thank You.

-S

[Former Member · Accepted solution]

Hi,

1- No you can not get 256gb ram or others. You can find instance types here: http://aws.amazon.com/ec2/instance-types/

3- If you have Linux knowledge you can set up an ftp on the server. I dont know ftp is active or not. Default ftp port number is 22. But you can upload files using ssh. AWS allows this.

5- You can use your own BO or other tools. If you dont have you can get one from Cloudshare.

6- There is no problem replicating data to HANA using SLT. But you have to get an SLT server. SLT licence is not included. It is included only if you have a HANA box.

Please reward points if helpfull.

[Former Member · Accepted solution]

Thanks Erhan.

I was able to get the FTP working.

What is the biggest HANA Size available on AWS. Also can we use the AWS for depploying Production ?

Thanks,

S

[Former Member · Accepted solution]

Hi

Biggest size is 68.4 gb. No you can not use because HANA version is "Developer". I am sure you dont want that version on production.

Please reward points if helful.

[Former Member · Accepted solution]

I know it's been a quite a while, but I'm trying to do the same thing, FTP my files over to my new SAP HANA instance on AWS.  Can you point me in a direction as to how to did that?