Page 1 of 1
how to read xml file into oracle database
Posted: Mon Mar 13, 2006 11:08 pm
by yugandhar
i have requirement like this
xml input stage----->xml transformer stage------>odbc stage
what kind of parameters i have to set for these stages to work.
Posted: Mon Mar 13, 2006 11:38 pm
by chulett
If your
requirement is it read XML files and load them into Oracle, then your job would look more like:
Folder --> XML Input --> OCI (or ODBC)
With maybe a transformer between the XML and OCI/ODBC stages. As a general rule of thumb, you should parameterize
anything in these stages that could change from run to run or environment to environment. Things like:
XML source directory
XML file pattern
Oracle DSN
Oracle Userid
Oracle Password
...come immediately to mind. However, none of them need to be parameters to get this to work. You could hard-code everthing, it's just not a good idea.
