TDBSP oracle with parameters Input

Highlighted
Four Stars

TDBSP oracle with parameters Input

Dear All,

can you help me how to put parameters for the procedure DO_ETL:

this is my procudere DO_ETL with parameter In V_NUMDATE:

1.PNG

this is tDBSP oracle: i want input parameter get from server file or some table in the DB server.

2.PNG

regards,

Tr

Twelve Stars

Re: TDBSP oracle with parameters Input

sans-titre.png

to add parameters click on the green "+" button on the bottom.

 

help is here: https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/L0CYRx_eeECbzhM8vJAMFg

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: TDBSP oracle with parameters Input

thank Francois Denis,

i know that, but How can I get the parameter values ​​from the text file and put in the TBSP oracle component?

Twelve Stars

Re: TDBSP oracle with parameters Input

Capture.PNG

read file first.

use tmap to extract your params

use column names to select Schema Colune name.

 

 

Francois Denis

Tag as "solved" for others! Kudos to thanks!

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 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog