Adding System - SAP HANA studio console
1) Adding System: Once the SAP HANA is installed and when we click on ‘HANA Studio’ the below screen will come up.
In the above screen left side, ‘Navigator’ space will show what are all the system available in this Studio. As this is new system the first step we have to do is add the system.
Step1: right click in the Navigator space, click on ‘Add System’
Step2: In the next screen we have to mention ‘Hostname’ and ‘Instance Number’.
Note: We can have multiple systems with same hostname but different instance number.
Select the language and click on ‘Next’.
Step3: Here we have to authenticate this system by providing user name and password
Click on ‘Next’ and then ‘Finish’ to see you system in the Navigator.
Once the system is added, a schema will be created based with the ‘user name’ we provided for authentication. In this if we drill down the ‘catalog’, we can see the schema with name ‘P1001301’. Schema contains the objects(tables, views) created and customizations done by that particular user.
We have 2 main perspectives in SAP HANA.
i) Administration Console: Where in we can perform all DB level monitoring and activities.
ii) Information Modeler: This is the place where all can create their models in SAP HANA.
Hi Syamala,
ReplyDeleteThanks so much for this article! I tried to follow some instructions from few other article and got in over my head. This worked so quickly and your instructions were very easy to follow. Really appreciate this.
after installing and configuring Agile Data Preparation SP23 on my HANA Express Edition 2.2 Server, I encounter the following error when trying to de-duplicate my data:
pop.addInputNodeMapping('INPUT_1sap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1_TEMPLATE_','INPUT_1sap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1_TEMPLATE_')
[4437]{205738}[26/1426526] 2018-03-05 08:00:19.066832 e cePlanExec cePlanExecutor.cpp(08147) : Error during Plan execution of model HXE::SAP_HANA_IM_ADP_STAGING:sap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1 (t -1), reason: executor: plan operation failed;Execution of Adapter operation within node CLEANSE_Addresssap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1_TEMPLATE_ failed: exception 141005: Failed to create or initialize HanaTransform object
[2727]{-1}[-1/-1] 2018-03-05 08:00:20.584812 e xsa:sap.hana.im. SandBox.cpp(01560) : Found the following errors:
===========================
ApplicationException: Last transformation was unsuccessful while running flowgraph. (line 30 position 1 in /sap/hana/im/adp/adp/Errors.xsjslib)
Could anyone point me into the director where to look for the cause? I could not find any SAP Notes or other documentation regarding this behavior.
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Obrigado,
Kevin
Hello Buddy,
ReplyDeleteThank u For sharing this unique article. Definitely a life saver.
Can we directly update tables in SAP HANA systems which has HANA as the database.
If yes, then please guide me with the process .
If not what is the best practice to be followed to update the table(specifically in HANA).
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Ciao,
Irene Hynes
Hi There,
ReplyDeleteThanks so much for this article! I tried to follow some instructions from few other article and got in over my head. This worked so quickly and your instructions were very easy to follow. Really appreciate this.
I need to connect to SAP Hana to retrieve Some data from database tables using Microsoft .net connector.
Could you please let me know the user name and password on connection string. SAP HANA Training Is it the same SAP credentials used on Netwaver and to open any SAP transaction like MM01 or I have to create separate database user on Hana DB for this connection activity?
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Thank you,
Preethi.