Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tsaphanaconnection does not have use or register a share connection

Hi team,
I am new to Talend so stuck with many issues in my developement. One of my issue is that I need to share a db connection from prejob to main job and then close that connection in post job.
Talend Version: Talend data Febric (6.2.1)

I am stuck with this connection thing.I am using hive and hana connection component. Hive connection component has "use or register a shared db connection" but hana component do not have that. My job structure is
Prejob->hivecon->hancon
Mainjob
Postjob-hanaconclose->hiveconclose

My mainjob structure is like this:

tparellelize->hiveinput1-tmap-hanaoutput1
hiveinput2-tmap-hanaouput2
and so on..

my questions are: 1) how to share hana connection with main job
2) do i need to have hive connection in main job also and there also do I need to check"use or register a shared connection"? I guess yes(after reading other articles from net)
3)Since I am using prejob component , do i need to join prejob components and mainjob with "onsubjob ok" trigger.

Can you please suggest how to sort out these things.

Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi,
Could you please post your job design screenshots into forum so that we can understand your work flow very well?
Best regards
Sabrina
Anonymous
Not applicable
Author

Thanks Sabrina for responding to my query. I am stuck with few issues and among them some I am able to resolve but some doubts/issue are still left and I am working on them.
Can you please respond to my another post also. It would be great help to me. Screenshot 1 is valid for below post also:
https:// https://community.talend.com/t5/Design-and-Development/Job-recovery-mode-in-Talend-for-jobs-running-...
Regarding this post, please find my current flow design attached (First screen shot). This is not the real design.
0683p000009MGEo.png
Second screenshot tells what I originally wanted. Subjob basically a separate job which has 5 jobs running in parallel like shown in 3rd screen shot But after googling, i found out that I need to enable "use or register a share db connection" but this checkbox in there in hive component but not there for Hana. 
Also I found out that I need to drag those connection components in subjob also and enable the same check box there again.
I can still go with my design shown in first screen shot, but there I am stuck with re-execution of just failed jobs which is quite a blocking for me. I do not want to rerun whole job in case of failure of 1 subjob.
Any help would be much appreciated.
0683p000009MGDN.png 0683p000009MGEt.png
Anonymous
Not applicable
Author

0683p000009MGEo.png 0683p000009MGDN.png 0683p000009MGEt.png somehow screen shot did not got attached