topic Re: tDBLastInsertId - Empty component list in Talend Studio

tDBLastInsertId - Empty component list

Anonymous — Thu, 18 Apr 2019 14:59:47 GMT

Hi. So I'm trying to use tDBLastInsertId with SQLServer. When I drag this component into my project and after I select SQL Server as the target DB to use, the component list is always blank; it doesn't see the two existing SQL Server Db Connections I have. If I drag an existing connection onto my job, I don't see tDBLastInsertId as a suggested component option, but I see everything else (e.g. tMSSqlInput, tMSSqlOutput, etc) in the drop down. Even if I connect a tMSSqlOutput (using one of the aforementioned connections) to a tDBLastInsertId, I still don't see any component list being generated.

Do I need to somehow associate the tDBLastInsertId that is in my component palette to SQLServer to be able to see the valid connections in the component list? Thanks!

Re: tDBLastInsertId - Empty component list

vapukov — Thu, 18 Apr 2019 15:13:12 GMT

Hi,

could you share your design and what steps you do?

because it shows all connections already presented in the job (not in a repository)

Re: tDBLastInsertId - Empty component list

Anonymous — Thu, 18 Apr 2019 15:37:51 GMT

Hi, thanks for getting back to me. So, I built a silly little job with my existing connections to illustrate my issue.

When I use my existing SQLServer connection:

To designate the table I'd like to use:

And then I build my sample job:

I see:

Screen Shot 2019-04-18 at 10.35.21 AM.png

Re: tDBLastInsertId - Empty component list

vapukov — Fri, 19 Apr 2019 00:31:35 GMT

Hi,

thank you, this confirms my guessing

as I mentioned before - you must have tMSSQLConnection component on your job screen, but not in the repository

in your tDBInput component you have also checkbox - use an existing connection, same for tDBOutput

so, you define connection once and use it for all components

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/tR5sAkr~80fPFhrYZNlNWQ