How to Add SAP HANA Database into SAP HANA Studio

-

Single or multiple systems can be added to HANA Studio for administration and information modeling purposes. To add new HANA system, host name, instance number and database user name and password is required.

  • Port 3615 should be open to connect to Database
  • Port 31015 Instance No 10
  • Port 30015 Instance No 00
  • SSh port should also be open 
Following are the steps to add a system to HANA Studio

Step 1: Right-click the Navigator space and click Add System. Enter HANA system details, i.e. Host name & Instance number and click Next



Step 2: Enter Database user name and password to connect to SAP HANA database. Click Next and then Finish.



Comments

Post a Comment

Popular posts from this blog

SAP Business One Web Client Tiles Not Loading (tiles.svc 500 Internal Server Error)

-
Image
Error: W hile trying to read the field 'bind' of a null object loaded from field com.sap.b1.infra.meta.tile.Tile.action of an object loaded from local variable 'tile" when we are logging into specific company Issue: This issue mainly occurs when adding any web client extension tile to the web client home page and you unassign the extension from the extension manager. Solution: Delete the existing users from the SAP Business One and OUSR table and then recreate the user. Then tiles should load in the Web client.
Read more

SAP Business One Company Initialization Error SAP DBTech JDBC: [259]: invalid table name: Could not find table/view M_TIME_DIMENSION in schema _SYS_BI

-
Image
 Error:  2022-04-29 11:03:39|ERROR|ENABLEMENT|Failed to re-initialize company :module id=Hana Model Deployer; cause:com.sap.businessone.model.renew.exception.ModelException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name:   Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)| 2022-04-29 11:03:38|ERROR|MODEL_DEPLOYMENT|Failed to execute sql statement: Create View Next6MonthEndView  as Select Top 6 Year, Month, Max(Date_SQL) as MonthEnd From _SYS_BI.M_TIME_DIMENSION Where Date_SAP <= Last_Day(Add_Months(Add_Days(CURRENT_DATE, 1-DayOfMonth(CURRENT_DATE)), 6)) and Date_Sql >Last_Day(CURRENT_DATE) Group By Year , Month Order By Year Desc, Month Desc, root cause: SAP DBTech JDBC: [259]: invalid table name:   Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)| Solution:   Login to HANA studio  Run the below Query from SYSTEM...
Read more