Apex Code Development You need to sign in to do that
Don't have an account?
Muhammad 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!
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!