Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application. 

Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application. 

Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application. 

Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application. 

------------------------------
Luke Peterson
Business Analytics Advocate
IBM

Original Message:
Sent: Tue April 07, 2020 10:20 AM
From: Predrag Stojic
Subject: Content Store tables description

Hi all,

I am looking for documentation regarding Cognos Content store tables descriptions for v11.0 and v11.1. So far my search turned up only old Cognos 8 descriptions, but they don't seem to match. 

Thanks in advance.

------------------------------
Predrag Stojic
------------------------------

#CognosAnalyticswithWatson

Anyone with permissions can query the Content Store. I do it all the time. Querying any database data does not alter/change/update/modify/delete any data. No harm will be done. 

------------------------------
brenda grossnickle
BI Programmer Analyst
FIS

Original Message:
Sent: Thu April 09, 2020 12:44 AM
From: Luke Peterson
Subject: Content Store tables description

Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application. 

------------------------------
Luke Peterson
Business Analytics Advocate
IBM

Original Message:
Sent: Tue April 07, 2020 10:20 AM
From: Predrag Stojic
Subject: Content Store tables description

Hi all,

I am looking for documentation regarding Cognos Content store tables descriptions for v11.0 and v11.1. So far my search turned up only old Cognos 8 descriptions, but they don't seem to match. 

Thanks in advance.

------------------------------
Predrag Stojic
------------------------------

#CognosAnalyticswithWatson