Hi all, I have two SD application servers on Solaris platform and I need to perform Data Exchange task from CSV or TXT file.
Unfortunately HR department is not able to provide data in DB format - only CSV or TXT is possible.
But on Solaris platform I can use only JDBC drivers to access data and I miss JDBC to CSV. I've already tried to use csvjdbc utility from sourceforge.org. It was working OK in Java application but with sd_export it failed.
there is one possibility to use "external table" in oracle db. You have to create external table in oracle db or your schema and when you define external table you specify your csv or txt file as datasource for external oracle table.
Then you can access csv or txt file as regular oracle table, it means you can use standard data-exchange process.