SQL Database

DCIM_Support · ‎2020-07-03

How can I do to query information in the SQL database from another program?

DCIM_Support · ‎2020-07-03

Hi Diego

You are not permitted to access the DCO internal DB.

But, you can export the data to another DB so you can write SQL to read it.

and

There are many of us on the forum who have a lot of experience with this environment so please ask your questions and share your experience here.

Cheers

Ed

DCIM_Support · ‎2020-07-03

And a question on DCO or DCE? Judging by the tag - DCE.

DCIM_Support · ‎2020-07-03

I have this video tutorial about accessing StruxureWare Data Centre Operation database:

Note that the part about creating ETL databases is slightly outdated - this interface is moved to Webmin, but otherwise it is good.

DCIM_Support · ‎2020-07-03

Hi Diego,

For DCE, you can't pull directly from the database but you can pull information from the server using the web API. INfo on this can be found here:

Steve

DCIM_Support · ‎2020-07-03

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.