I was deployed excel file reader application using tomcat 7. For the back end purpose i used oracle 11g(oracle.jdbc.driver.OracleDriver ). How could I deploy the same application using SAP Netweaver Cloud and which driver i have to use for SAP HANA DB.
Thanks and Regards,
well, in fact the whole idea of a PaaS such as NW Cloud is to abstract these things for you so that you would need to worry about drivers, DB connection pooling etc.
Hence, if you deploy your app to a HANA-backed account on NW Cloud you'd get a DataSource provisioned to you that automatically uses the right JDBC driver.
For more information please read this help document: https://help.netweaver.ondemand.com/default.htm?persistence_jdbc.html
More info on the Persistence Service: https://help.netweaver.ondemand.com/default.htm?persistence_service.html
Please note that HANA DB is not yet available for public (e.g. on trial landscape.)
Thanks for your quick response. I have SAP HANA Server Access. In JAVA Servlet i used following code for Oracle database initialization. How to initialize SAP HANA DB into JAVA Servlet and how to deploy this application into Cloud.
connection = DriverManager.getConnection("jdbc:oracle:thin:@10.138.14.22:1521:testdb", "test", "test");
statement = connection.createStatement();
Thanks and Regards,
I just would like to confirm what I am understanding from this post.
You did actually connected to your own HANA DB (I do have one at AWS) using the Orcale jdbc driver?
So you are actually able to select/insert/update/delete data from/to your HANA DB tables.
Have you managed to deploy your application to the cloud?
Hm, still not sure about your setup. Are you using NW Cloud at all? If so, then Erhan told you the current situation already: for security reasons we only allow HTTP/HTTPS Ports on the cloud platform. Very soon, you will have access to HANA from within NW Cloud thoug, and then you can use the code snippets provided in the JDBC tutorial linked in my first post to your question.
IF however, you got access to HANA voa out developer license and hosted on AWS you can of course connect to it. For that you'd need of course access to the JDBC driver on the system executing the servlet. I'm on the road at the moment nd hence i do not have the concrete jdbc connection string at hand. If this is the scenario - then you may be better off posting it in the SAP HANA developer center though...
Hi all - Thanks for all your responses. I get that there is no test access to a HANA cloud server service currently available
Can we connect from a netweaver cloud PAAS application to a onPremise Hana.
What are the steps that we need to follow for that? Do we need any installation on onPremise server side?
Yes, you are correct. It seems the needed jar is ngdbc.jar and can be pulled from a sub directory of the SAP HANA Client Developer Edition after it is installed. Thanks for the response.