Integration

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. Physical Data server

   

   and Test connection is successful

2. Physical Schema

   

3. Logical Schema

   

4. Create a model

   

5. Create the datastore

   

6. Reverse Engineer, select the Agent B which start on windows

   

   I want the data from emp_tab.csv like this

   

What steps did I miss? please advise thank you.

@user1025929