Here is a cool site for instructing how to define OCBC connection strings for different data sources:
When preparing for a BAM demo I needed to show information from BAM external data source (MS Access sample database Northwind). Manual only described how to configure Oracle Database, but didn't give a sample how to configure Access DB.
After a while of tweaking out the configuration I got Access DB set up as an external data source. The key is to define following values as a sample:
Driver: Microsoft Access Driver (*.mdb)
Connection string: Dbq=d:\demodb\Nwind.mdb;