ODI can't load the local csv file on windows

KevinLii

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:

1. and Test connection is successful
2. Physical Schema
3. Logical Schema
4. Create a model
5. Create the datastore
6. I want the data from emp_tab.csv like this

What steps did I miss? please advise thank you.

RVohra

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