Category Blogs

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)...

September 22, 2015 Posted in Blogs

Prerequisites: Salesforce.com, Force.com, Portal, Authentication, Authorization

I built up a PowerPoint presentation for a potential client to eliminate the security concerns of Salesforce.com and Force.com. This presentation offers a thorough introduction of the security solutions on Salesforce.com and Force.com, including platform security, user security (authentication, OAuth and social SSO) and programmatic security on Force.com.

For anyone who wants to have a quick overview of Salesforce.com security solution, this is a shortcut to get on road.