Creation of SAP HANA Database Instance in SAP BTP Trial

[ChiranjeeviAppapogu_123456789]

Introduction:

SAP HANA Cloud is a database as a service (DBaaS) , provides a single place to access, store, and process all enterprise data in real time with high availability .You can develop smart applications with embedded machine learning , analytics (advanced data processing capabilities , insights ) ,document store . SAP HANA Cloud provides all of the advanced SAP HANA technologies for multi-model data processing ,store and access data in-memory and column-based [ it Process mission-critical data at proven in-memory speed] or on disk . By combining in-memory storage with columnar store, data operations are performed faster than in a traditional database with a disk-based storage. Using SAP HANA Cloud, you can set up and manage SAP HANA databases and bind them to applications running on SAP Business Technology Platform (SAP BTP) or elsewhere. You can benefit from cloud qualities such as availability, security, automatic software updates, elasticity, and low total cost of ownership by using SAP HANA Cloud either as a stand-alone solution or as an extension to your existing on-premise environment.

1. Open SAP BTP  Cockpit and click on subaccount.

2. Click on Instances and Subscriptions and then click on create button. 

3. Select Service as SAP HANA Cloud and Plan as tools. 

4. SAP HANA Cloud is now subscribed. 

5. Click on Security -> Users and select the user. 

6. Click on Assign Role Collection. 

7. Assign the following three roles. 

8. Click on SAP HANA Cloud Application; it will open in new window(Hana Cloud Central). 

9. Click on create Instance. 

10. Select SAP HANA Cloud, SAP HANA Database and Next Step 

11. Provide the instance name and password (next step). 

12. Click on Next Step. 

13. Click on Next Step. 

14. Select Allow all IP addresses, Enable Cloud Connector, and select Allow all IP addresses --> Next Step. 

15. Click on Review and Create(No need to select Data Lake). 

16. Click on Create Instance. 

17. Wait until the Instance status turns into Running state and click on Actions three dots. 

18. Go to Open in SAP HANA Database Explorer; it will open in new window. 

1. Enter the Credentials 

Username: DBADMIN   

Password: “use the password which was created at previous steps”. 

1. Click on SQL Console Icon at the top left. 

Now the SAP HANA Database is ready to use. 

Conclusion:

Here in this post I have completed only setting up Hana Cloud Instance, but this is only the first part of my blog. I will be completing my blogs by working on Hana Database Integration HDI, schemas and tables in Hana Database Instance. I will be posting this in my up coming blog.