Exploring SAP at database level using Sql Command Editor in DBACOCKPIT

gram77
gram77 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
I'm not sure what you really want.
If you have access do DBACockpit you'll be able to query the database. Can you be more explicit?
Commented:
SAP application usually use ORACLE or SQL server .

This is depend If Oracle then use SQL developer gui tool to explore the database.

If Microsoft SQL server then install SSMS (sql server management studio) to connect to database server and explore the database.

Commented:
Oh I missed "My SAP application uses SqlServer and i have access "

You can install SSMS and connect database server.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
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).

Author

Commented:
Any idea which schema SAP stores it's objects. I have heard it's SAP schema.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
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).

Author

Commented:
Downloading Microsoft® SQL Server® 2014 Express:
file ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe

https://www.microsoft.com/en-in/download/details.aspx?id=42299
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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.

Author

Commented:
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!
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
No. SAP account has SA role. He need to and that's why is dangerous. You need to be careful.

Author

Commented:
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>

SqlServer.png
SqlServer.png
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
You are connecting to host CRMEHP2 ?

Author

Commented:
yes. But it is not asking me for hostname or ipaddress.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
CRMEHP2 is something you have to provide prior to connect. In the screenshot above you used SAP where CRMEHP2 should be.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017
Commented:
Let's go back a little bit?
Do you know I which server is your SAP database? If affirmative, do you have access to it? If affirmative, you don't need to install the SQL Server Express Edition but SQL Server Management Studio only.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial