cancel
Showing results for 
Search instead for 
Did you mean: 

Where is KM content stored

Former Member
0 Kudos

Hi there

Can anyone tell me where KM content is stored ... is it on the file system somewhere, or within SAP tables?

Perhaps that is too broad a question, so I will elaborate a bit ...

We are delivering a 2004s BW system, and the templates are delivered through the portal. Part of the functionality of our templates is to allow the users to add/view/edit comments for a dataprovider.

I have been requested to delete comments that are more than a month old, so was hoping I could write a Java / ABAP program to read the comments from wherever they are stored, and delete the old ones accordingly.

From what I can see, comments are handled like other KM content, hence the question as to where KM content is stored.

Any information would be greatly appreciated.

Cheers,

Andrew

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Andrew ,

the storing of data depends on the type of repository ,u r creating.Whether it is

1.DB mode

2.DBFS mode

3.FSDB mode

u can chk this link for internal repository-CM repository manager

http://help.sap.com/saphelp_nw70/helpdata/en/4c/9d953fc405330ee10000000a114084/frameset.htm

i think it will help u.

Former Member
0 Kudos

Hi Andrew,

if you know the id of the KM repository where the comments are stored, you can easily find out where the content is stored. Prerequisite is that you can access the portal with system administration rights. Then you can take a look into the Content Management configuration.

To do this select System Administration / System Configuration in the top level navigation. In the detailed navigation select Knowledge Management / Content Management. This will open the Content Management Configuration.

Select the area 'Repository Managers'. Now you should see the different types of Repository Managers. Most likely your repository manager will either be a CM Repository or a File System Repository. Click on the respective sub areas and check the list of configured repository managers for a repository with the id you are searching for.

If your content is stored in a file system repository you will find the storage location in the 'Root Directory' column of your file system repository manager's configuration.

If the content is stored in a CM repository, then at least part of the information is stored in a database. This depends on the 'Persistence Mode' of the repository manager.

To delete content that is older than a certain date I recommend that you write a KM report which walks over the repository content, checks the date and deletes the old resources via the KM API. This will work for any type of repository.

Hope that helps!

Martin

Former Member
0 Kudos

Hi Martin,

We have a SAP Content Server in our landscape which we are using to store documents generated from SAP.

We have a EP 7 with KM, My question is ,can we use SAP Content Server as a KM repository ? is it possible ? if yes please help me how we can do that.

Please help me

Thanks

Aravida

Former Member
0 Kudos

It depends (on the repository manager and its configuration). It may be in the file system, in the database, or somewhere else.

If you want to access it, you should use the KM Java API, or a protocol supported by KM (such as (HTTP/WebDAV).

Best regards, Julian

Former Member
0 Kudos

OK, so how do I tell how the repository manager has been configured.

And if it uses the file system, how do I determine the path?

And if it uses database, which tables?

I have downloaded the Repository Framework Explorer, which seems quite useful, but still not giving me quite what I want at the moment, although it does show me what all is being stored in KM, and I can at least confirm that the comments associated with a dataprovider and template are indeed stored in the KM repository (wherever that may be)

Thanks for the help so far.

Cheers,

Andrew

Former Member
0 Kudos

You are not supposed to bypass the KM API. The way the content is stored is an implementation detail and can change between releases.

Best regards, Julian