odpd
|
|
Oracle Direct Path Daemon
|
| | |
Overview
The Oracle Direct Path Daemon (odpd) is an utility that moves data from
flat files to a running instance of Oracle 9i using the Oracle Call Interface
Direct Path API.
It is written in C/C++ on Linux.
In a typical usage scenario, a business partner could FTP flat files in a previously agreed upon format to a predetermined
directory. odpd could then detect the new data and send it on to Oracle.
Specifications
- Should be able to handle any data file that could be handled by SQL*Loader.
- Should "poll" a specified "data directory" and detect when new data has arrived for loading.
- Each loading operation should run an independent thread of execution.
Goals
- Along the way, we want to create true C++ wrappers for OCI Direct Path API, and
- Provide exceptionally clear examples of OCI and Direct Path programming
Dependencies
- Oracle 9i, obviously. In particular, $ORACLE_HOME/lib/libclntsh.so.
- Oracle XDK for parsing config files. In particular, $USR_LOCL_LIB/libxml9.a.
- Log for C++ for logging.
- Loki Int2Type.
- g++. A port to Solaris/CC is planned.
Docs & info
- Preview UML diagram. (Requires Dia.)
- OCI discussion forum.
Download
Use CVS for now.
Contact
@todo
- multi-threading
- ensure that odpd can handle all SQL*Loader examples
- allow data file names to be specified by pattern
- collection of Load objects should be hash?
- loader should block until odpd.xml is touched
- each Load should block until one of its data files is touched
$Id: index.html,v 1.13 2003/03/12 11:52:27 asdrury Exp $