Providers to external Data Base other than Oracle

Andy weaver from Fishbowl has a written a how to blog to do external database look up in check in form. Check link here.
    In case your external database is some thing other than oracle than you can follow these steps to create a provider to this DB.

• Add all your database driver jars into InstallDir/shared/classes folder
• In InstallDir/bin Intradoc.cfg file add java class path variable to your jar files ex: JAVA_CLASSPATH_defaultjdbc=$SHAREDDIR/classes/ojdbc14.jar
• Go to Administration --> Providers page
• Click on Add Provider against Database provider
• Fill new provider form and click on Add button
• Restart content server

Now you can follow Andy's  blog create a component and do a look up to external db.