December 30, 2015 Posted in Blogs

Prerequisites: Oracle WebCenter Content, UCM, Security, Roles

To manage enterprise content security is always a sensitive and important task since it involves the intellectual property, legal documents and business contracts of an organization.

Oracle WebCenter Content (WCC, previous UCM) provides comprehensive security features through Security Groups, Roles, Permissions, Accounts, Access Control List (ACL) and WebLogic-based Oracle Platform Security Services (OPSS). It is complex, isn’t it? But once you read through this article, you will understand how it works.

Oracle WCC runs as a managed server on WebLogic Server. How does the security login connect to directory services? The answer is Oracle WCC security is driven by WebLogic Server...

November 25, 2015 Posted in Blogs

Prerequisites: Oracle WebCenter Content, UCM, BatchLoader

BatchLoader utility is an aged Java Swing application that performs batch content check-in to Oracle WebCenter Content (UCM). It’s especially useful for migrating millions of legacy files from file system to content repository.

It’s a bit tricky to make it work. So I try to document this in order to make everybody’s life easier.

My content server runs under Linux environment. Since BatchLoader
is a GUI application, you’ll need have a terminal with X11 forwarding capability. I strongly recommend free MobaXTerm here.

I’m using Oracle WebCenter Content 11gR3. The BatchLoader utility is under: /oracle/domains/webcenter/ucm/cs/bin

Before you run it, you need check whether the content server configuration is correct...

September 29, 2015 Posted in Blogs

During past two decades, I have been working on many database design and migration projects. There are a lot of decisions to make in creating new database schema. Any database schema changes can be very expensive in a later date. Some may even result in rewriting the front end applications. So to understand a few best practices and apply them in your database schema design is vital important.

1. Take the advantages of UML

Most people use ERWin to create ERD, then use forward engineering to build up database schema. If we may move further and think about how to use object-oriented UML to describe the world, it might be very helpful. UML brings lots of benefits like composition relationship and inheritance (generalization relationship)...