data from external file to oracle table

Four Stars

data from external file to oracle table

hi team ,

i want to extract data from external file (only one value e.g 100) and pass this value to oracleSp this has a stored function and this returns a value that is to be stored in another table (oracle) ,for test i am using logrow .

i have created tFileInputDelimited_1->tFixedFlowInput_1-> tOracleSP_1-> tLogRow_1

the above does not work

this works tFixedFlowInput_1-> tOracleSP_1-> tLogRow_1

but if i put tFileInputDelimited_1 then blank value .

Please advise, thanks in advance

Fifteen Stars TRF
Fifteen Stars

Re: data from external file to oracle table

Hi,

I think (sorry can't try cause I've not Oracle installed on my laptop), you can connect tOracleSP to tFileInputDelimited.

Supposing the tFileInputDelimited schema is made of 1 integer field (called value for example) configure the tOracleSP like this:

Capture.PNG

The output schema contains a field in which the result will be return by the called function.

Select this field in the list "Return result in".

Let me know if it works.


TRF
Four Stars

Re: data from external file to oracle table

 

a) ParentJob: tFileInputDelimited_1->tFlowToIterate_1-> tRunJob_1 with context parameter for SubJob

b) SubJob: tFixedFlowInput_1-> tOracleSP_1-> tLogRow_1

tFixedFlowInput_1with Modus 'Use Single Table'

'column_1' with value context.param_1,

'column_2' with value context.param_2 etc... all needed Input-Parameter from tOracleSP_1

 

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch