gram77
asked on
Exploring SAP at database level using Sql Command Editor in DBACOCKPIT
I want to explore SAP at the database level, the various tables, views, index triggers, procedures, functions, packages etc..
My SAP application uses SqlServer and i have access to Sql Command Editor in DBACOCPIT to run database queries.
How do i carry this out?
My SAP application uses SqlServer and i have access to Sql Command Editor in DBACOCPIT to run database queries.
How do i carry this out?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh I missed "My SAP application uses SqlServer and i have access "
You can install SSMS and connect database server.
You can install SSMS and connect database server.
If you want to have a complete overview, use SQL Server Management Studio.
Otherwise there are sys,tables, sys,indexes,m sys.columns etc. to get corresponding info. Or the INFORMATION_SCHEMA views (https://msdn.microsoft.com/en-us/library/ms186778.aspx).
Otherwise there are sys,tables, sys,indexes,m sys.columns etc. to get corresponding info. Or the INFORMATION_SCHEMA views (https://msdn.microsoft.com/en-us/library/ms186778.aspx).
ASKER
Any idea which schema SAP stores it's objects. I have heard it's SAP schema.
No clue. If we connect to SAP on MSSQL, we only have to provide the correct DB and user, and the default schema works fine. The DB is named like the system, usually something like YCP for "YourCompanyProductive" (vs. ...Development / Quality / Test).
ASKER
Downloading Microsoft® SQL Server® 2014 Express:
file ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.e xe
https://www.microsoft.com/en-in/download/details.aspx?id=42299
file ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.e
https://www.microsoft.com/en-in/download/details.aspx?id=42299
You don't need SSMS for nothing. DBACockpit should be enough since gives you a SAP interface. If you work with SSMS you'll be more confused and you may perform any action that can be very bad to your database unless you're a SQL Server expert.
ASKER
Victor, i agree working on SAP objects at database level may be dangerous as it may make the system unstable.
I just want to view the objects: only SELECTs no DMLs/ DCLs or TCLs.
Hope SAP allows me do to so unless there are restrictions on SELECT too!
I just want to view the objects: only SELECTs no DMLs/ DCLs or TCLs.
Hope SAP allows me do to so unless there are restrictions on SELECT too!
No. SAP account has SA role. He need to and that's why is dangerous. You need to be careful.
ASKER
Successfully installed Sql Server 2014 Express:
However, looks like i will need to set parameters like hostname and ip address which are not mentioned in SAP. How do i connect?
SqlServer Log:
Login failed for EH5. Reason: An attempt to login using SQL authentication filed. Server is configured for Windows authentication only. [Client: <local machine>
However, looks like i will need to set parameters like hostname and ip address which are not mentioned in SAP. How do i connect?
SqlServer Log:
Login failed for EH5. Reason: An attempt to login using SQL authentication filed. Server is configured for Windows authentication only. [Client: <local machine>
You are connecting to host CRMEHP2 ?
ASKER
yes. But it is not asking me for hostname or ipaddress.
CRMEHP2 is something you have to provide prior to connect. In the screenshot above you used SAP where CRMEHP2 should be.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have access do DBACockpit you'll be able to query the database. Can you be more explicit?