Skip to main content

Oracle Data Integrator tools: OdiFileDelete and OdiOutFile

Hello everyone!
It’s time for another cool ODI tutorial. Last time, I spoke about the OdiZiptool and how it can be used to create zip files from a directory. Through this post,I will talk about two more tools related to Files namely OdiFileDeleteand OdiOutFile.
1. OdiFileDelete
The OdiFileDelete is a tool used to delete files present in a directory or a complete directory on the machine running the agent.
Usage
OdiFileDelete -DIR=<dir> | -FILE=<file> [-RECURSE=<yes|no>] [-CASESENS=<yes|no>] [-NOFILE_ERROR=<yes|no>] [-FROMDATE=<fromdate>] [-TODATE=<todate>]
If -FROMDATE is omitted, all files with a modification date earlier than the -TODATE date will be deleted. If -TODATE is omitted, all files with a modification date later than the -FROMDATE date will be deleted. If both parameters are omitted, all files matching the -FILE parameter value will be deleted.
It is important to note that both FILE and DIRECTORY cannot be deleted at the same time. In such a case, we need to use two instances ofOdiFileDelete.
Pre-requisites: Oracle Data Integrator 11g (build version 11.1.1.7.0)
Now let’s implement the ODI using Oracle Data Integrator. Open ODI Studio and create a new Package named odifiledelete_test inside any of your existing Projects.
Create package
create_package_2
create_package_3
Command
OdiFileDelete "-FILE=C:\programs\odi_work\*.txt" "-RECURSE=YES" "-CASESENS=YES" "-NOFILE_ERROR=YES"
Save all the changes and run the package. Check the status of the operation under the Operator tab. If the operation was successfully completed, the files present in the directory specified will be deleted.
Output
2. OdiOutFile
The OdiOutFile is a simple tool used to generate a text file (.txt) in the path defined by file_name and contains the text specified by text.
Usage
OdiOutFile -FILE=<file_name> [-APPEND] [-CHARSET_ENCODING=<encoding>] [-XROW_SEP=<hexadecimal_line_break>] [CR/LF <text> | -TEXT=<text>]
To use this tool, let’s create another Package named odioutfile_test in any of the existing Projects and follow the below steps!
Create package
create_package_2
create_package_3
Command
OdiOutFile "-FILE=C:\programs\odi_work\my_output.txt" "-CHARSET_ENCODING=ISO8859_1"
Hi! This is a test message using OdiOutFile tool.
Save all the changes and run the package. Check the status of the operation under the Operator tab. If the operation was successfully completed, you should see a new file created in the directory specified.
Output
output_2
Labels:

Comments

  1. 21st Century Software Solutions30 September 2014 at 14:49:00 GMT+5:30

    Oracle Data Integrator Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/oracle-data-integrator-online-training-125.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Oracle Data Integrator Online Training, Oracle Data Integrator Training, Oracle Data Integrator, Oracle Data Integrator Online Training| Oracle Data Integrator Training| Oracle Data Integrator| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete
  2. rocheblanche29 May 2019 at 13:11:00 GMT+5:30

    obsolete now : http://www.21cssindia.com/courses.html

    ReplyDelete
  3. Ezra Abram12 January 2021 at 14:55:00 GMT+5:30


    Thanks for the nice blog here.I was searching this one for a long time.This blog is very helpful for my studies..I got another one site also,which is same as yours Oracle ODI .Check this one also Oracle Fusion Manufacturing .Sure it will be helpful for you too..Once more iam thanking you for your creative blog.

    ReplyDelete
  4. Unknown7 April 2021 at 17:10:00 GMT+5:30

    Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Same as your blog i found another one Oracle ODI 12c .Actually I was looking for the same information on internet for Oracle ODI 11g and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.


    ReplyDelete

Post a Comment

Popular posts from this blog

ODI KM Adding Order by Option

You can add Order by statement to queries by editing KM.I have edited IKM SQL Control Append to provide Order by.  1) Add an option to KM named USE_ORDER_BY, its type is Checkbox and default value is False. This option determines you want an order by statement at your query. 2)Add second option to KM named ORDER_BY, type is Text. You will get order by values to your query by this option. 3) Editing Insert New Rows detail of KM. Adding below three line code after having clause. That's it! <% if (odiRef.getOption("USE_ORDER_ BY").equals("1")) { %> ORDER BY <%=odiRef.getOption("ORDER_BY" )%> <%} %>  If USE_ORDER_BY option is not used, empty value of ORDER_BY option get error. And executions of KM appears as such below; At this execution, I checked the KM to not get errors if ORDER_BY option value is null. There is no prove of ORDER BY I'm glad.  Second execution to get  Ord...
132 comments
Read more

Creating Yellow Interface in ODI

Hello everyone! In Oracle data integrator (ODI), an  interface  is an object which populates one datastore, called the  target , with data coming from one or more other datastores, known as  sources . The fields of the source datastore are linked to those in the target datastore using the concept of  Mapping . Temporary interfaces used in ODI are popularly known as  Yellow Interfaces . It is because ODI generates a yellow icon at the time of creation of a yellow interface as opposed to the blue icon of a regular interface. The advantage of using a yellow interface is to avoid the creation of  Models each time you need to use it in an interface. Since they are temporary, they are not a part of the data model and hence don’t need to be in the Model. So let’s begin and start creating our yellow interface! Pre-requisites : Oracle 10g Express Edition with *SQL Plus, Oracle Data Integrator 11g. Open *SQL Plus and create a new table  Sales ...
Post a Comment
Read more

Synchronous and Asynchronous execution in ODI

In data warehouse designing, an important step is to deciding which step is before/after. Newly added packages and required DW data must be analyzed carefully. Synchronous addings can lengthen ETL duration. Interfaces, procedures without generated scenario cannot be executed in parallel. Only scenario executions can be parallel in ODI. Default scenario execution is synch in ODI. If you want to set a scenario to executed in parallel then you will write “-SYNC_MODE=2″ on command tab or select Synchronous / Asynchronous option Asynchronous in General tab. I have created a package as interfaces executes as; INT_JOBS parallel  INT_REGIONS synch  INT_REGIONS synch  INT_COUNTRIES synch  INT_LOCATIONS parallel  INT_EMPLOYEES parallel (Interfaces are independent.) Selecting beginning and ending times and durations from repository tables as ODI 11g operator is not calculating these values. It is obvious in ODI 10g operator. SELECT    sess_no...
Post a Comment
Read more