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?
gram77Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
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?
0
Deepak ChauhanSQL Server DBACommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Deepak ChauhanSQL Server DBACommented:
Oh I missed "My SAP application uses SqlServer and i have access "

You can install SSMS and connect database server.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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).
0
gram77Author Commented:
Any idea which schema SAP stores it's objects. I have heard it's SAP schema.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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).
0
gram77Author 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
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
gram77Author 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!
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
No. SAP account has SA role. He need to and that's why is dangerous. You need to be careful.
0
gram77Author 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
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You are connecting to host CRMEHP2 ?
0
gram77Author Commented:
yes. But it is not asking me for hostname or ipaddress.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
CRMEHP2 is something you have to provide prior to connect. In the screenshot above you used SAP where CRMEHP2 should be.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SAP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.