Cascade Server Schema Diagram

rvaldez's Avatar

rvaldez

04 Nov, 2011 04:36 PM

I posted the following in regard to obtaining a CS schema diagram in March 2011 and never received any feedback. I'm going to proceed with creating my own diagram. We are currently at v6.8 in prod. If you would like a copy of the diagram when I'm done, just let me know and I'll post it.

March 2011:
Our users have a need to view users, groups, and roles data in report format to assist with a rather large project they are working on in Cascade Server. This data is not reported within the tool in a format that is useful to the project team. We would like to create the reports ourselves through queries against the Cascade Server database. Two questions:

1) Are there plans to provide reporting for Cascade Server?

2) In the interim, can you provide us with a copy of the Cascade Server schema? We are currently at version 6.7.6.

Thank you.

  1. 1 Posted by Charlie Holder on 15 Mar, 2012 12:25 AM

    Charlie Holder's Avatar

    I've been visiting some older posts and saw this one. I do apologize that it was overlooked.

    You're looking for the database schema correct? Not a Cascade Entity Relationship diagram of some kind? There are some example reports in the Default Database. In the example.com Site there is a folder called _reports that does some generic reporting for stale content and pages without certain fields filled in. Does that help at all?

    1) Are there plans to provide reporting for Cascade Server?

    Integrating reports into Cascade Server is on our radar.

    2) can you provide us with a copy of the Cascade Server schema?

    I will certainly ask.

  2. 2 Posted by Charlie Holder on 15 Mar, 2012 03:55 PM

    Charlie Holder's Avatar

    Update:

    We don't provide the schema or an explanation of it publicly.

    I would always encourage you to use the Web Services API to programmatically access/manipulate data in Cascade. However, in this case, if you let me know what information you're interested in, it might be a few relatively simple SQL queries. It will probably easier to assist with that if possible then spend time spinning wheels.

  3. 3 Posted by Charlie Holder on 03 Apr, 2012 07:42 PM

    Charlie Holder's Avatar

    Hi rvaldez --

    Just wanted to check-in to see if you found my comments helpful.

    Let me know!
    Thanks.

  4. Tim closed this discussion on 02 Oct, 2012 03:45 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac