Update on Oracle Database best way & General Questions on data Translation

Four Stars

Update on Oracle Database best way & General Questions on data Translation

Morning - 

My name is Jeb & I am new to Talend. I did Informatica for 10 yrs and now working for small company and we are sub-contracting for a company who won a state (RI) contract & needed someone to do Oracle SQL.  Now they want us to do a little Talend & I got selected.  Actually gotten little information  from  State as to what is behind the curtain, except I have to feed new design Web file input into a Legacy Oracle database. I have gone thru the Tutorial here and got the basics. 

I have several questions and would appreciate some feedback.

To be a vendor with the State of RI the company fills in a screen (HTML pgm) and the data gets loaded to an Oracle database record. I have not got a logon with the State & dataflows are non-existant, We are told they do it using Talend, but have not seen it.


This new company is doing a Web based and I need to add/update the vendor to the Oracle Database. I have been looking solutions & would like feedback on best Update/Add for Oracle Database update (tETLOracle etc).  I have seen to determine if add/Update this SQL (Select Count(*)  from db using key if count > 0) and then routing to Add or Update componet depending on results answer.  Best way/Better way?

Another question - translation of data ie. Female Owned Company question is Checkbox - where would I translate the "X" to a  0/1 or Y/N to load to the database field - have not seen it in tutorials.

Was told by Talend sales rep a lot of good Youtube videos on Talend - any suggestions on a good one to watch.


Hoping all I have to do is accept new input from Web and feed thru existing Talend program as backend Oracle DB not changing, as far as I know.


Thanks you for your help -- Jeb






What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.