Oracle Data Integrator 12c - Creating a Project and Mapping: Flat File to a Table (Recorded Webcast)

[@kamangelov]

Thanks a lot for this presentation. I like it and your approach to teach the technology, making references and remembering notes.

[@vayunandu]

This is a perfect example how to teach!

[@MagaMuni-y8w]

This is an excellent session very helpful thanks a lot

[@sravyag600]

Hello, an excellent tutorial. Exactly shows how to achieve a basic integration use case end to end. Thank you very much. But I am facing an issue. When I am trying to create a Data Store under a model (which is Oracle ADWC model and which is reverse engineered), I am not able to look up in the field "resource_name", the search icon is totally disabled. I am using ODI Studio 12c. Could you please help me out? I really appreciate your help. Thanks in advance.

[@vchirilov]

Hi Steve, Many thanks for this lesson. I downloaded "Developer's Guide for Oracle Data Integrator 12c (12.1.2).pdf" from Oracle.com. Read a lot but didn't understand nothing from that book. It looks like that book has been written by 5 philosophers not programmers. Your post helped me much more. Do you have any other posts?

[@vchirilov]

+Oracle Learning Library Hello, Will have a look into it. However, I would like to bring this up that books written by Microsoft are more oriented to developers. Your (Oracle) books and documentation doesn't have any examples, only words... a lot of definitions and theoretical aspects with a lack of examples. The same idea is repeated 10 times under different contexts. Steve's post helped me much more than entire book from Oracle in managing and creating mapping and projects. I am sorry for this negative feedback but, this is reality.

[@jamesroman6905]

In ODI 12c, a JSON dataset can be used as the source for an export to, for example, a relational table or tables. The following OTN article provides a detailed example: community.oracle.com/docs/DOC-1005678

[@stevefriedberg9010]

Vishal, if you are not doing anything fancy to the target tables, not transforming them but simply loading ascii data into them, I think you'd be happier with Oracle Database native SQL*Loader (sqlldr) function. See www.oracle.com/technetwork/database/enterprise-edition/sql-loader-overview-095816.html for more info.

[@ashishkel]

Is there anyway to transform and load comp3 ebcdic data ? I mean how to use the mainframe o/p files in ODI ?

[@stevefriedberg9010]

Ashishkumar Lakshmanan Check out this discussion: community.oracle.com/thread/1104911

[@indianExploringInUK]

Steve Friedberg Hi Thanks for this video.. This is really helpful I am trying to insert data from a simple .txt file to a DB but while creating Data Source inside model, what should I select under Record Separator.? Other .? . Please suggest.. I have selected other but it's not working

[@stevefriedberg9010]

Nilay Mishra Nilay, As with all ODI stuff, the answer is, "It depends." What it is asking is what is the character that marks a new line (like a carriage return or Enter). DOS and UNIX do it differently in files for the end of each line, and IBM mainframes are the "Other." So if your text file is on Windows, then say MS-DOS. If the text file is on UNIX, you could go either way but probably it is UNIX. If you get it wrong, the symptom is that the file reads only the first line and won't read past what it is expecting for the new line. That should fix it for you.

[@indianExploringInUK]

Steve Friedberg Thanks Steve for your valuable feedback, now I am able to fetch the data from .txt format file as well.