topic Re: [resolved] tContextLoad - how to use in Talend Studio

[resolved] tContextLoad - how to use

Anonymous — Sat, 16 Nov 2024 13:48:59 GMT

I see how to load context variables using tContextLoad from a text file that has a name-value pair of columns.
How can you use it in other scenarios? Ex: Can you load from an upstream input compoment? Is so, how - cannot get that to work.

Re: [resolved] tContextLoad - how to use

Anonymous — Tue, 18 Aug 2009 03:13:45 GMT

Hello

Ex: Can you load from an upstream input compoment?

Yes, you can load them from any input component, tMysqlInput etc...
Note that you should define the corresponding context vars to mapping the key column, eg:
You are quering the following rows from mysql
host localhost
database talend
username root
password shong
port 3306
You need define the context vars: host,database,username,password,port.
Best regards

shong

Re: [resolved] tContextLoad - how to use

Anonymous — Tue, 18 Aug 2009 04:00:10 GMT

David,
Did you have download the Talend documentation which you can find here ? You'll find a description and a use case of "how use the tContextLoad component".
You can also in the LoginPage when you start the produt "Import Talend demo project"; into the project you have several use cases and components in action. We are trying to have a sample of "HOW TO USE" per components for our new users.
From a tMSSQLInput or tOracleInput (metadata schema : 2 columns= key | value) you can try with this following SQL query : "SELECT 'myContextVar', columnA FROM table where id ='3'"
In this example you have a contextVariable named myContextVar and you push the ROW from tOracleInput to the tContextLoad.
The mechanism is pretty much the same if you're working on a dataflow itself. You have to operate with an association KEY/VALUE in all cases.
Best regards

Re: [resolved] tContextLoad - how to use

Anonymous — Tue, 18 Aug 2009 15:57:47 GMT

David,
Did you have download the Talend documentation which you can find here ? You'll find a description and a use case of "how use the tContextLoad component".
You can also in the LoginPage when you start the produt "Import Talend demo project"; into the project you have several use cases and components in action. We are trying to have a sample of "HOW TO USE" per components for our new users.
From a tMSSQLInput or tOracleInput (metadata schema : 2 columns= key | value) you can try with this following SQL query : "SELECT 'myContextVar', columnA FROM table where id ='3'"
In this example you have a contextVariable named myContextVar and you push the ROW from tOracleInput to the tContextLoad.
The mechanism is pretty much the same if you're working on a dataflow itself. You have to operate with an association KEY/VALUE in all cases.
Best regards

Cannot get this to work. Do not know how to use.
attached image

Re: [resolved] tContextLoad - how to use

Anonymous — Tue, 18 Aug 2009 16:03:42 GMT

David,
Did you have download the Talend documentation which you can find here ? You'll find a description and a use case of "how use the tContextLoad component".
You can also in the LoginPage when you start the produt "Import Talend demo project"; into the project you have several use cases and components in action. We are trying to have a sample of "HOW TO USE" per components for our new users.
From a tMSSQLInput or tOracleInput (metadata schema : 2 columns= key | value) you can try with this following SQL query : "SELECT 'myContextVar', columnA FROM table where id ='3'"
In this example you have a contextVariable named myContextVar and you push the ROW from tOracleInput to the tContextLoad.
The mechanism is pretty much the same if you're working on a dataflow itself. You have to operate with an association KEY/VALUE in all cases.
Best regards

Cannot get this to work. Do not know how to use.
attached image

Re: [resolved] tContextLoad - how to use

Anonymous — Wed, 19 Aug 2009 04:07:55 GMT

Hello
Add a tMap between tOracleInput and tContextLoad to change the column name.
See my screenshots.
Best regards

shong

Re: [resolved] tContextLoad - how to use

Anonymous — Wed, 19 Aug 2009 17:51:52 GMT

For your example, do I have to first have to define context variables? Or, does the context variable get created automaticallym named as name of the value in the key ?
Dave

Re: [resolved] tContextLoad - how to use

Anonymous — Thu, 20 Aug 2009 07:34:33 GMT

Hello Dave
Yes, you must define the context vars mapping the key column first.
Best regards

shong

Re: [resolved] tContextLoad - how to use

Anonymous — Thu, 20 Aug 2009 16:34:56 GMT

thanks - I will try that.
Dave