My Oracle Support Banner

Frequently Asked Questions Regarding the Use of Jython Scripting Features in ODI 11G and Earlier (Doc ID 566475.1)

Last updated on DECEMBER 05, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.


Purpose

Now included all the examples, hints and tips on using Jython in ODI. These are specific technical questions only and are used to show how Jython could be used in ODI to meet specific requirements and as well as any known problems. Recommended to read the Jython Quick Reference included in ODI Documentation Library.

NOTE: In this article any details... ie ORACLE_HOME used, usernames, variables, etc., represent a fictitious sample. Any similarity to actual configurations, persons, living or dead, is purely coincidental and not intended in any manner.

Note: Oracle is not responsible for any instructions/information/drivers obtained from 3rd party site.

 

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Troubleshooting 
 Known Issues 
      1. Same Jython code that used to run fine in ODI 10g fails in 12c with ImportError: No module named xxx.
      2. OS Commands Launched From Jython Fail When Run Under Recent Versions of Windows
      3. An ODI User Function Fails Due to Brackets In the Jython Code Implementation
      4. No Data Is Transferred And No Error Message Signaled When Sending iDocs to SAP Implemented On A Unicode Database
      5. Problems Concerning Persistence Scope of Jython Variable Content
 When Using ODI Knowledge Modules That Use Jython
      1. May I Use My Customized Knowledge Modules After Upgrading ODI?
      2. Incorrect VARCHAR Attribute for 'DOUBLE PRECISION" Data Types With Teradata (FastLoad)
      3. Incorrect CHAR(0) Type Of Columns Generated With ODI "File to Teradata (FastLoad)" Loading Knowledge
  
 When Using ODI snpsftp Jython Module
      1. Incorrect EndOfLine Characters When Transferring Ascii Files With The FTP Protocol With ODI snpsftp Tool
     2. Is It Possible To Specify An FTP Proxy Port With ODI snpsftp Tool ?
 Problems From Setup/Environment/Usage
      1. "ImportError: no module named java" Message Displayed When Running Jython Scripts With ODI
      2. Unprintable Characters When Send Emails With The ODI SendMail Tool ?
 When Using ODI Knowledge Modules That Uses Jython 
      1. ODI Integration Interfaces Using 'LKM File to Oracle (SQLLDR)' Execution Fails With The Following Error On Unix
      2. "Invalid argument for username/password" When Calling SQL * Loader Based Knowledge Modules in ODI
      3. "Invalid column name" Message When Reverse Engineering An Oracle Database Schema With JDBC (Jython) Reverse Knowledge Module
      4. Error During Reverse Engineering Operations On Netezza
      5. Problems With Reverse Engineering of an SQL Server Database After Importing
 When Using ODI snpsftp Jython Module
      1. "no module named ftplib" Message When Using ODI snpsftp.
      2. FTP Size Limited On The Vax Operating System When Used With ODI
 General Questions
 Best Practices
      1. Respecting Jython Syntax
      2. ODI And The Use Of Jython Scripts In Jython Technology Specific Procedures
      3. Jython code on the Source tab of an ODI Procedure
      4. 'IOError: File not found' Message When Specifying Filepaths
With Jython Scripts Launched From ODI Jython Technology Specific Procedures
      5. Loops and Jython Class declarations.
      6. Escaping < ? ... ? > Tags in Jython scripts
      7. Recommendations for Decrementing Jython Variables
      8. User Defined Functions and Technology Restrictions
      9. Using Java BeanShell With ODI
      10. Running Jython Scripts In ODI On Intel Itanium (64-bit) Hardware
 Working With Files
      1. How To Insert Root Level Elements With ODI XML Driver?
      2. Using Jython and JDBC To Set Up Automatic Conversion Processes Of Excel Files To CSV Files (Internal Only)
      3. Using Jython To Generate a PDF File From a Dataset Retrieved With an SQL Instruction.
      4. Using Jython to Manage .gz Files.
      5. Using Jython To  Process RAR and GZ files
      6. Using Jython Procedure To Substitute OdiFileDelete Tool of ODI
      7. Platform Independent Sorting Of Lists Of Files For Processing In ODI
      8. Accessing File Folders With Jython In A Context Independent Way From ODI
      9. How Is It Possible to Pass The File Path or The Name of The File to Jython without Hard Coding It Into The Jython Script By Using an ODI Variable?
 Using JDBC
      1. Calling Stored Procedures From Jython Scripts In ODI
      2. Launching an Ingres Stored Procedure through Jython in ODI
      3. How Do I Run Multistatement In ODI (Sunopsis)?
      4. Conditionally Sending Email If Rows Are Inserted Into The ODI Error Table?
 Using Jython With Mails
      1. How To Set Mail Priority Attribute With ODI SendMail Tool ?
      2. How To Send Email Messages Through An Authenticated SMTP Server with ODI ?
      3. Specifying The Port Number To Be Used With The OdiSendMail (SnpsSendMail) Tool.
 Web Services
      Example of invoking a Web Service from Jython
 Using FTP
      1. How To Set Up FTP File Exchange Operations With ODI ?
      2. Implementing The FTP "rename" Function With The ODI Jython SnpsFtp Script.
      3. Is There A Way Of Implementing A Multiple FTP Rename Function In Jython For Remote Files With ODI ?
      4. Best Practices For Network Security Policies And ODI Configurations
      5. Using ACTIVE and PASSIVE Exchange Modes With FTP From ODI Using Jython
      6. Problems Arising With The ANT tool And File Exchange With the FTP Protocol
 Miscellaneous
      1. Is It Possible To Start A Scenario From Jython?
      2. Using Jython to Execute System Commands.
      3. How To Launch A Set Of Commands With The MySQL Program From ODI
      4. Loading Custom Jython Modules in ODI.
      5. Data Scrambling / Encryption With ODI
      6. Recuperating Bind Variable Values In ODI Jython Scripts
      7. ODI Variables And Jython Scripts
      8. How To Automate Exporting And Importing of ODI Objects Into The Repositories.
      9. Displaying ODI Variables Values In ODI Operator Log
      10. How Is It Possible To Retrieve The Current ODI Work Repository Schema Name And Related Data In A Jython Technology Specific Procedure ?
      11. How To Retrieve ODI Context Information In A Jython Technology Specific Procedure ?
      12. Using Jython code to Force An ODI Session To Terminate With An In-error Status.
      13. Is It Possible To Call ODI Tools From Jython Scripts? 
      14. Can ODI Interact With Other Software Tools Supported By The Operating System?
      15. Using the Jython Interpreter
      16. We have upgraded our ODI 10g (10.1.3.5.2) to ODI 11g (11.1.1.6.3). While doing the testing after the upgrade, one of the ODI procedure with Jython technology failed with the below error.
          "No Module named xreadlines"
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.