topic Re: DB Connection Save Query in Talend Studio

DB Connection Save Query

Anonymous — Sat, 16 Nov 2024 06:58:47 GMT

I've created a DB Connection to a SQL Server database and that works fine. I have a schema built for the table/query. Whenever I click on the [...] to go to the SQL Builder I can see and run the query fine. However, every time I try to save the/any query, I get the message "Please define name (*) and comment." I would like to save several queries for this DB Connection but can't find what it's talking about with the message, or where I enter this name and comment in order to save the query in the repository. I've been searching online for several days for a solution with no luck.

Re: DB Connection Save Query

Anonymous — Thu, 27 Dec 2018 03:15:52 GMT

Hello,

Could you please show us your query on forum?

Best regards

Sabrina

Re: DB Connection Save Query

Anonymous — Thu, 27 Dec 2018 12:54:46 GMT

First image shows the schema, query, and results all work properly.

Next image is the message I get every time I try to save the query.

I'm trying to get several queries saved in the repository for this db connection and just change the "where" clause in each. I haven't been able to find where or how to save the queries, without getting the above message.

Re: DB Connection Save Query

Anonymous — Thu, 27 Dec 2018 13:48:42 GMT

Hi,

what is your talend version ??

Regards,

Avinash

Re: DB Connection Save Query

Anonymous — Thu, 27 Dec 2018 14:13:14 GMT

Talend Open Studio for Data Integration v 7.1.1

Thanks

Re: DB Connection Save Query

Anonymous — Mon, 07 Jan 2019 12:13:54 GMT

Still looking for some help in saving queries in the repository.

Re: DB Connection Save Query

Anonymous — Wed, 30 Jan 2019 19:29:12 GMT

I had the same thing happen to me. Here is the resolution I found:

Using your mouse, grab the corner or bottom of of the Save As query dialog box and pull (over, down, etc.). After the dialog box is sufficiently big, the Name and Comment text boxes will appear along with the Save / Cancel buttons. Enter the info, Save and you are good to go.

Hope this helps.

Re: DB Connection Save Query

Anonymous — Wed, 30 Jan 2019 20:15:11 GMT

Thank you !!! That worked exactly. The fields were hidden and I had to stretch out the box to show them. Once done and I filled them it, the queries are saving now. Thank you so much StvMtchlFV.