My goal is to automate the process of importing data from Views in an Oracle Database. I have built a model with modelbuilder in ArcGIS Desktop 9.3.1 SP2. The model utilizes the quick import tool available with the Data Interoperability Extention. The model runs great in ArcCatalog, but if I export it out into python, it throws the following error:
arcgisscripting.ExecuteError: Java reader not found -- no reader named `ORACLE8I' is available in this FME version
Tool execution failed.
Why will the tool run great from ArcCatalog, but not execute in python? Below is the python script I am using. I will leave out the connection information contained in the parantheses of the last line.
# Import system modules
import sys, string, os, arcgisscripting
# Create the Geoprocessor object
gp = arcgisscripting.create()
# Check out any necessary licenses
gp.CheckOutExtension("DataInteroperability")
# Load required toolboxes...
gp.AddToolbox("D:/Program Files (x86)/ArcGIS/ArcToolbox/Toolboxes/Data Interoperability Tools.tbx")
# Local variables...
DPWtest_gdb = "D:\\TEMP\\DPWtest.gdb"
# Process: Quick Import...
gp.QuickImport_interop(