topic Talend Big Data 6.2 Oracle stored proc execution in Talend Studio

Talend Big Data 6.2 Oracle stored proc execution

Anonymous — Sat, 16 Nov 2024 06:45:10 GMT

Hi,

In need to call Oracle SP Stored Proc in Talend Big Data. but in pallete I am unable to see any SP related transformations only seeing Input Output and Connection component in the pallette.

Thanks,

Vig

Re: Talend Big Data 6.2 Oracle stored proc execution

vapukov — Fri, 25 Jan 2019 14:04:36 GMT

it very strange, it must be there

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/nZLZAcmLjEt8X8yaaf3lfQ

did you try to search by name?

Re: Talend Big Data 6.2 Oracle stored proc execution

Anonymous — Fri, 25 Jan 2019 14:53:01 GMT

Hi, thank you for replying.

Much Appreciated , I am using Big data edition. so the components are shown as below:

Capture.PNG

Re: Talend Big Data 6.2 Oracle stored proc execution

Anonymous — Mon, 04 Feb 2019 09:23:50 GMT

Bumping this thread.. anyone with Talend BigData integeration experience ???

Re: Talend Big Data 6.2 Oracle stored proc execution

manodwhb — Mon, 04 Feb 2019 09:32:22 GMT

@vigneshm247 ,are you creating standard job or batch job?

Re: Talend Big Data 6.2 Oracle stored proc execution

manodwhb — Mon, 04 Feb 2019 09:43:58 GMT

@vigneshm247 ,can you show me the palette settings in Edit project setting >>Designer>>Palette Settings

Re: Talend Big Data 6.2 Oracle stored proc execution

Anonymous — Mon, 04 Feb 2019 12:58:13 GMT

I have not hidden anything in the pallette, and BTW I am using Big Data Batch , not standard job. As I have already mentioned Big Data edition.

Re: Talend Big Data 6.2 Oracle stored proc execution

vapukov — Mon, 04 Feb 2019 13:28:53 GMT

@vigneshm247 wrote:

I have not hidden anything in the pallette, and BTW I am using Big Data Batch , not standard job. As I have already mentioned Big Data edition.

🙂

this is what you forget to include

you are wrote only - Talend Big Data, but it just a name and Talend for BigData support and standard jobs and batch
in batch mode database and other paletes much shorter than in DI mode

Re: Talend Big Data 6.2 Oracle stored proc execution

Anonymous — Mon, 04 Feb 2019 15:11:41 GMT

Any suggestions on executing DB procs through BigData Batch Jobs (Spark)?

Re: Talend Big Data 6.2 Oracle stored proc execution

vapukov — Mon, 04 Feb 2019 21:04:09 GMT

not sure - Spark execute code on many nodes

for processing data it is good, but how run partially stored procedure on 12 nodes?

think - how you can avoid it