Wednesday, January 28, 2009

Using File Store Provider to Store Content files in database

Using File Store Provider to Store Content files in database

Here are the steps for doing this
  1. Open Content Server providers page

  2. From the providers page edit “DefaultFileStore” provider, by opening “Info” link

  3. Enable file store provider by clicking on “Upgrade” button

  4. Restart content server
  5. Repeat Sep 1 and 2, and then click on “Edit” button
  6. By default, there is a Storage Rule created for you, and we will edit this rule (if you want, you can add new rule). In “Edit File Store Provider” page, click on “Edit Rule”

  7. “Storage Rule” page, choose “JDBC Storage” option, and in “Renditions” list, don’t choose anything (not choosing any rendition option means, we will store both the original file and weblayout file in the database). Don’t change Path information.

  8. Open “File Store Administration” page

  9. Click on “Add Partition” button

  10. On “Add Partition” page, add “Partition Name” field that you want, and in “Duplication Methods” choose link which means that if the original file has not been converted, a link to the original file will be used (instead of making a copy of the file, which is duplicating the content)

  11. Note, choosing link in “Duplication Method”, will save space in the database, because large part the content will not be converted

  12. Restart content server
  13. We want to test what we did, so we will check-in a new file into the content server.
  14. Query the database table “FileStorage”, you will find primary file and weblayout files added into two records and that two records identified by dID


I still have questions about File Store providers, and I wish some can help me
  • How many partitions should I create?
  • What about the old content that is already stored in file system?

7 comments:

Anonymous said...

HI Hisham,
Please send me your gmail id pls.

Thanks
Roshan

Anonymous said...

Hi Hisham,
is it possible to give us a sample how to use File Store Provider to store content on CAS (for example, EMC Centera or similar one)
Thanks,
Bilja

Hisham Galal said...

Hi Bilja,
I didn't work before with CAS servers, but what I know that CAS servers is designed for fixed content, which will not be changed a lot, and I think you shouldn't use it with UCM.

But If you will use CAS for archiving, I think you can save UCM's vault and webalyout files on the database, and using database archiving tools you can archive them directly to CAS storage.

try that link http://www.snwonline.com/tech_edge/best_practices_07-11-05.asp?article_id=575

W650 said...

i think you must hv full archive before change target store to db.

Anonymous said...

Hi Hisham,

I have followed the same steps provided in your site and created a file store provider to store all the files in database, also created a partition. Still found contents are stored in filesystem. Even tried by deleting the partition, resulted in same.

Thanks,
Sundar.

Khadim said...

I am trying to follow your step but i don't see the button Upgrate.

I am user 11.1.1.6 version of UCM

What can I do?

Hisham Galal said...

Currently I don't have access to 11.1.1.6 instance, please tell me what you see in that page and what is your needs for File Store Provider.