I have been asked to connect or update a sharepoint list with data from an oracle database. I have found a few limited examples that really did not get me too far. My understanding is that there are a few approaches I might take but I wondered if anyone here has already done something like this. I do have access to Visual Studio and can write custom code if I need to.
Update: I have more of an idea of what I need and some direction would be greatly appreciated. I need to have a sharepoint list that gets new data and appends data from an oracle database. The list also needs to be able to have data that users can update that does not come from oracle. I would also like to enable minor versioning on this list to track changes that come from both oracle data and user data. We only have WSS 3 but as I stated above, I can write custom code if I need to.