I'm very new to TOS and I have almost a similar situation in MS SQL where i'm suppose to insert latest records to a table AC. So I'm trying to get max Date from AC to know which records to fetch from another SQL DB. For this as per above diagram i have started with a tMSSQLinput_1 component with above mention query then i want to store the result set of tMSSQLinput_1 to tSetGlobalVar_2 (not sure if this is the best approach). As you can see i have added a Key and just to test if the results are stored i have used tLogRow_1 Component. but i am getting this error
"Execution failed : object is not an instance of declaring class
Job AgentCubeNew ended at 20:59 06/03/2019. [exit code=0]"
I would like to know is this the right approach?, also where should i write globalMap.put("myValue",*value*) to set the value in my variable from the query ?
Once i'm able to set the variable i would like to call it in another MSSQLinput component to get records from another db table which > max(date) of table AC
my talend is Version: 5.6.1
@abdulbasit,you can do multiple one is creating context and loading that max date into context and reading that context variable in the next component where you were writing query based on date.
and another way is set using tsetGlobalvar. on which component are you getting an error?
@abdulbasit ,i see the problem in tSetGlobalVar,value should be like row1.colum with out " ". can you provide that way.
@abdulbasit ,on which component are you getting that error?
@abdulbasit ,check the below example,
@abdulbasit ,I relay not able to test your issue. we have dig into one step down,with out tSetGlobalvar was that job running successfully just to keep toracleinput and tlogrow
i think its because of the format of datetime can you try with "yyyy-MM-dd HH:mm:ss"
@abdulbasit ,i am not getting in error in talend Open studio 7.1.1,check below
i tried it without tGlobalVariable still the same Class Cast exception. i even tried changing the date format by
"Select format(max(Date), 'dd-MM-yyyy') as mdt from AgentCube" same error. when i guess schema after this updated query the system reads it as string with 400 length
@abdulbasit ,can you check the schema and query of the tOracleInput.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema