We are migrating from Oracle to Vertica. We have our business logic written in Pl/Sql today to process the data. Our Front end is C#.
What do you suggest for migration of the pl/sql code. Will that be External Procedures or User Defined Extenstions? I am newbie learning Vertica. I am open for suggestions.
Vertica is on Unix Server.
+2Hi ,
I will advice to go with pure java or some 3part ETL process , UDX will be bad choice .
Thanks
Thank you sir. I will research this Java perspective.
If let's say I have developed my entire business logic (pl/sql) code in Java, should I deploy that to Vertica as External Procedures?
I am not sure if Vertica accepts External Procedures written in Java. If it doesn't and if UDx is a bad choice, then I just need to write all my code 100% in Java and operate the DML based on a DB Connection to Vertica.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
