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
- the datastore didn't load the data from emp_tab.csv , but load the C: driver, like this
- this is the file I want to load.
What steps did I miss? please advise thank you.