Access to cmf DB trought dbreader.html

[leorob123]

Hi folks!

I need to query the CommonServices cmf DB, but trought the dbreader.html utility I didn't able to connect.

Anybody knows which are the credendial that I have to use?

Thanks a lot!

Leonardo

[akemp]

The DBreader is only supported for troubleshooting with TAC.

The DCRcli is what is supported for querying the DCR.

[leorob123]

Yes I know,

TAC gave me the credential, but I don't know how to use it.

I don't know the DB name to insert.

I need to know the table name and other usefull things.

Any helps would be appreciate.

Leonardo

[Joe Clarke]

Akemp is correct, dbreader is not a general purpose utility. It is used only for troubleshooting purposes by TAC. We do not publish the schema to our databases as they are subject to change.

That said, what data do you want? There are a few command line utilities which can be used to get to this data in a supported manner.

[leorob123]

well...

I need to analyze the DB in order to verify if is it possible to insert data directly via SQL instead of dcrcli.

[Joe Clarke · Accepted solution]

Doing so is not supported, and could lead to data corruption.

[leorob123]

ok thanks