Hi Guru's,
I Created a Flat file from which i'm suppose to read data and move data to oracle tables.
To - Test the same when i created my topology with following details i was able to load data from flat file to oracle table.
Odi version: 12c
Created Data Server: Test
Gave ODI Account user name and password
jdbc driver: com.sunopsis.jdbc.driver.file.FileDriver
Jdbc url: jdbc:snps:dbfile
Inserted new Physical schema for above data server
Schema: C:\Users\UserAccountname\Desktop
Work Schema: C:\Users\UserAccountname\Desktop
Logical schema: LS_Test
With above details - i was able to read the flat file and view data when i click on Datastore in the model and load the data into target tables.
However, i was not able to do the same when the file is in remote server.
Server: ABC
File path: /user/remote/ext_tables --- is the path in which actual file exists.
This time i didn't modify anything except Schema and work schema to this path.
But, it says file doesn't exists.
Appreciate your help to resolve my issue.