function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Muhammad AmerMuhammad Amer 

Importing Salesforce data directly to Oracle using java

Hi there

I am trying to export notes data from one slesforce instance to another. I exported the notes data into CSV but when I tried to load the CSV into Oracle, I ran into numerious challenges due to contents of 'notes' (for example, embedded double-quotes and multiple double-quotes, embedded newlines, etc to name a few). Notes are free format and allow users to type-in whatever they want and however they want. I was able to fix many issues using a combination of sed and nawk (unix) but the list of issues seems endless. 

Now I am thinking of exporting the notes data from salesfocrce and directly load to oracle database without first dumping them into CSV - using Java.

My first question  - is this even doable. If yes, please provide me some guidance. There are almost 7million notes to transfer.

Thank you in advance!