Provision SAP HANA Cloud trial account
Below are the steps to provision SAP Hana Database using a trial account
Let’s start with creating a temporary email for registration purposes
![0](../../_images/hanadb/0.png)
Don’t close the above window, otherwise a new email id would get generated. |
Go to sap.com and navigate to products
→ Trials and Demos
![1](../../_images/hanadb/1.png)
Click Advanced Trials
![2](../../_images/hanadb/2.png)
Click SAP BTP Trial
![3](../../_images/hanadb/3.png)
Click Start your free 90-day trial
![4](../../_images/hanadb/4.png)
Paste the temporary email id
that we created in the first step, and click Next
![5](../../_images/hanadb/5.png)
We fill in our details and click Submit
![6](../../_images/hanadb/6.png)
It’s time to check the inbox of our temporary email account
![7](../../_images/hanadb/7.png)
Notice that there is an email received in our temporary email account
![8](../../_images/hanadb/8.png)
Open the email and click to activate
the trial account
![9](../../_images/hanadb/9.png)
It will prompt to create a password
. Provide a password and click Submit
![10](../../_images/hanadb/10.png)
The trial account is now created. Click to start the trial
![11](../../_images/hanadb/11.png)
Provide your phone number and click Continue
![13](../../_images/hanadb/13.png)
We receive an OTP on the phone number. Provide the code
and click continue
![14](../../_images/hanadb/14.png)
Select the region
as US East (VA) - AWS
![15](../../_images/hanadb/15.png)
Click Continue
![16](../../_images/hanadb/16.png)
The SAP BTP trial
account is ready. Click Go to your Trial account
![17](../../_images/hanadb/17.png)
Click the Trial
sub-account
![18](../../_images/hanadb/18.png)
Open Instances and Subscriptions
![19](../../_images/hanadb/19.png)
It’s time to create a subscription. Click the Create
button
![20.1](../../_images/hanadb/20.1.png)
While creating a subscription, Select service
as SAP Hana Cloud
and Plan
as tools
and click Create
![20.2](../../_images/hanadb/20.2.png)
Notice that SAP Hana Cloud
subscription is now created. Click Users
on the left panel
![21](../../_images/hanadb/21.png)
Select the username (temporary email that we supplied earlier) and click Assign Role Collection
![22](../../_images/hanadb/22.png)
Search hana
and select all the 3 role collections that gets displayed. Click Assign Role Collection
![23](../../_images/hanadb/23.png)
Our user
now has all the 3 role collections. Click Instances and Subscriptions
![24](../../_images/hanadb/24.png)
Now, click SAP Hana Cloud
application under subscriptions
![25](../../_images/hanadb/25.png)
There are no instances yet. Let’s click Create Instance
![26](../../_images/hanadb/26.png)
Select Type as SAP HANA Cloud, SAP HANA Database
. Click Next Step
![27](../../_images/hanadb/27.png)
Provide Instance Name
, Description
, password
for DBADMIN administrator.
Select the latest version 2024.2 (QRC 1/2024)
. Click Next Step
![28](../../_images/hanadb/28.png)
Keep everything as default. Click Next Step
![29](../../_images/hanadb/29.png)
Click Next Step
![30](../../_images/hanadb/30.png)
Select Allow all IP addresses
and click Next Step
![31](../../_images/hanadb/31.png)
Click Review and Create
![32](../../_images/hanadb/32.png)
Click Create Instance
![33](../../_images/hanadb/33.png)
Notice that the provisioning of SAP Hana Database
instance has started. It takes some time to provision - please be patient.
![34.1](../../_images/hanadb/34.1.png)
Once the instance is provisioned (status is displayed as Running
) we can get the datasource url (SQL Endpoint
) by clicking the instance and selecting Connections
![34.2](../../_images/hanadb/34.2.png)
We navigate to SAP Hana Database Explorer
by click the …
![35](../../_images/hanadb/35.png)
Provide the administrator credentials and click OK
![36](../../_images/hanadb/36.png)
Open SQL console and create the table CRICKET_WORLD_CUP
using the following DDL statement:
CREATE TABLE CRICKET_WORLD_CUP ( _ID VARCHAR2(255) PRIMARY KEY, CONTENT CLOB, EMBEDDING REAL_VECTOR(1536) )
![37](../../_images/hanadb/37.png)
Navigate to hana_dev_db → Catalog → Tables
to find our table CRICKET_WORLD_CUP
![38](../../_images/hanadb/38.png)
Right-click on the table and click Open Data
![39](../../_images/hanadb/39.png)
Notice that the table data is now displayed. There are now rows as we didn’t create any embeddings yet.
![40](../../_images/hanadb/40.png)
Next steps: SAP Hana Vector Engine