Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Correct ODI File Location + ODI Agent

3123015Jan 29 2016 — edited Feb 2 2016

I am using ODI 12.1.3 version , I have my ODI and ODI J2EE Agent in the same server.

Requirement :  If the location of the source files(CSV files) are in different server . can the ODI read the files , do the reverse engineering & load the file data into tables?

If the ODI Studio is installed in different machine I can't do the reverse engineering in models.

What is the possible way to resolve the issue.

Comments

Utsav Jan 29 2016

You can create a new agent pointing to the new serve where your CSV files are in.

3123015 Jan 29 2016

Only the Agent or for doing reverse engineering when also need to install ODI Studio in the new server where the csv files are?

Do we also need to install weblogic server in the new server?

Aramast Oghiguian Jan 29 2016 — edited on Jan 29 2016

Hi,

We need to separate 2 different ideas:

  1. Reverse-Engineering remote file
  2. Reading the remote file (and eventually loading it as you mentioned)

Reverse-Engineering remote file:

In order to Reverse-Engineer any file, the given file must be local (in the same server) of the ODI Studio.

  • How to solve then your problem if you want to extract the files from their remote locations and not copy and process them?

Bring the file once to the location where the ODI studio resides. Reverse-Engineer as it is a local file (specify the local paths in the Topology), check the data can be viewed (view data), then change the paths in topology (Data and Work Schema) back to the remote server path. This way the Reverse-Engineering is done, tested, and the remote location is specified.

Reading the remote file:

In order to read a remote file (and eventually load it), the file should be Accessible by the ODI Agent (any type of agent).

  • Install an ODI agent on the remote file server and run the interface (the mapping) with it
  • Or, Copy the file(s) to the target server and process it locally to the ODI agent
  • Or, Share Drives between the 2 servers
3123015 Feb 2 2016

Thank you so much for your detail explanation.

I tried with ODI Agent and File Server in different locations.

In Data Server(with the credentials of file server different from ODIAgent Location) - Test Connection is getting passed with J2EE agent.

But while running the mapping with J2ee agent the mapping fails with error - ODI-40438: File Not found.

My qns if it's passing the connection in Data Server then why it's falling while running the mapping.

Aramast Oghiguian Feb 2 2016 — edited on Feb 2 2016
I tried with ODI Agent and File Server in different locations

That's why the "ODI-40438: File Not found" error is raised.

if it's passing the connection in Data Server then why it's falling while running the mapping

It is not enough to put the path of the remote file when the Agent is on another server. In ODI, agents need to have local access to the files. That's why you need either to install standalone agent on the file server and run the mapping with the given agent on the file server instead, or bring the file to the server where your current Agent is located, or share drives.



I suggest you to take a look at the following article: http://www.ateam-oracle.com/understanding-where-to-install-the-odi-standalone-agent/ and you can go for now to the section: Other considerations: accessing files, scripts, utilities.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 1 2016
Added on Jan 29 2016
5 comments
2,523 views