ODI can't load the local csv file on windows

Question

I have two server

A: it's my oracle database server, installed odi studio, repository, alone agent A

B: it's a windows server, installed odi studio, alone agent B

I tried to load a csv file from B to A's database. but I can't correctly read the csv file on windows server B.

Here is the setup on windows B:

* and Test connection is successful

* Physical Schema

* Logical Schema

* Create a model

* Create the datastore

* I want the data from emp_tab.csv like this

What steps did I miss? please advise thank you.

RVohra · Answer

Thanks for asking the question but this is not the correct community for ODI.

I would suggest posting it on following customer connect so that ODI experts can help.

Data Integration — Cloud Customer Connect