We're evaluating Jitterbit (by using the community edition). The system seems quite promising, but we've bumped into quite a problem with Oracle backend database.
First, we tried using Oracle JDBC Driver. It connects fine, and is able to download table listing. But when trying to download column information, we get the following error:
- Code: Select all
An error occurred when downloading the column information: Error on the server: ; nested exception is:
org.xml.sax.SAXParseException: Premature end of file.
There does not seem to be a way around this. Here's some additional details:
Server: Oracle9i Release 184.108.40.206.0
JDBC Driver: ojdbc14.jar (220.127.116.11.0) and ojdbc6.jar (18.104.22.168.0-Production)
Java: Java 1.6.0_18
Secondly, we tried using Oracle Instant Client ODBC Driver. It works fine, and is able to download column listing, and we actually managed to create a transformation with it. But the problem with it is that the character encodings are messed up. Our simple transformation fetches information from Oracle database and outputs it to a text file. In the result all occurences of å appear as ?.
Has anyone had similar problems and was there any way around them?