I'm not sure what level you're at so I'll just say what I can remember off the top of my head.
Configure your SSO to use your chosen access method.I used privaledged group (make sure the default crawler account has access to your table/view).
Use BDC metadata editor from the SDK (it wont do everything for you but it will get a good chunk underway). Connect to LOBSystem use ODBC and "DSN=". Pull in the table you want to use.(having a primary key helps here but only for using the editor). Configure your RDB command text and and add the primary key as the identifier. Syntax for the variable passed to the BDC is either :VARIABLENAME note the colon or (?) for ODBC.
Add input parameters and return collections
There is an article on the specifics of this available.I'll to try post the link when I get home.
Export this and you should have a file with DataBase <LOBSystem> etc
For the Database connection <RDBConnectionProperties> you only need properties below
AuthenticationMode - RdbCredentials
DatabaseAccessProvider - Oracle
RdbConnection Data Source - (either oracle driver or ODBC conn string)
SsoApplicationId - (your SSO AppID configured in operations)
RdbConnection Pooling - false
There will be others after the export that I found were not needed.
the export will only have given 2 mthods an IDEnumerator and a specificFinder method. To get Profile import work you need to add a "Finder" method. Fortunatly its is just a question of adding Another line
<MethodInstance Type="Finder" ReturnParameterName="same as specificefinder" ReturnTypeDescriptorName="same as Return Typedescriptor Name" " ReturnTypeDescriptorLevel="0" Name="AnythingFinderInstance" />
Then add a line to the default values of the input typedescriptor
<DefaultValue MethodInstanceName="YourNewFinerInstance" Type="System.String">*</DefaultValue>
This is it for the file
Load it up to the BDC and check by the Profile page.
Go to the SSP profiles and properties
Go to configure connections and add a connection of type BDC.
Map a 1:many connection to the a filter descriptor defined in you ADF file.
Ok go for an import, check the crawl log for errors.
(small gotcha, had me for hours!! if you are using an enterprise setup i.e you search server is on another box, make the ODBC drivers are on that box!)
Ok, so you're incredibly lucky and you see no errors.
Go to the profile properties and start mapping attributed from BDC application. You're done.
Hope this at least gets you going.
Cheers