Q:

Question: We have Oracle as our RDBMS for all the applications. We have field sales force who want to gather some information from the customers and enter it into the Notes database. We have all our reports generated from an Oracle database. Because the infrastructure exists for Notes already, they want to use notes database to enter in the customer information. For reporting purposes the notes data have to be moved to Oracle database. We have not started this data capture. Initially we are expecting to have few megabytes of data but later only sporadic updates. Do we really need an ETL tool to take the data from Lotus Notes to Oracle or we can use some simple way of doing this (e.g., SQL Loader)? Please advise.

A:

Scott Howard’s Answer: The relational database will not be a problem as there are many tools and utilities, both Oracle and third party, that you could effectively use to load the report database. Lotus Notes is where you’ll have the most fun. Consider Lotus Notespump.

Clay Rehm’s Answer: If the data maps directly one to one, then use a utility like SQL Loader.  The reason you would use the ETL tool is to handle transformations of data and to capture the meta data of the transformations and the source of the data.  Determine what is more important and then proceed.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access