6 Replies Latest reply on Sep 16, 2016 2:10 AM by Periyasamy S

Custom SQL function in Tableau 9.3

Periyasamy S Sep 8, 2016 4:18 AM

Hello !

I have a requirement for using the cursor concept in the custom sql and I used declare statement in my SQL. But I am unable to execute the query in tableau and giving me the error message as "Incorrect syntax near the keyword 'DECLARE'." and "Incorrect syntax near ')'."

On exploring the other community results for this error, I got to know that tableau accepts only simpler SQL and declaring any new variable is not possible. (This was some a post from 2 years back!)

In tableau 9.3, is there any way or workaround for using DECLARE statements in the Custom SQL.

Thanks.!

1. Re: Custom SQL function in Tableau 9.3

Tom W Sep 8, 2016 4:32 AM (in response to Periyasamy S)

You could put your code inside a stored procedure and connect to that.
Like Show 1 Likes(1)

Actions
2. Re: Custom SQL function in Tableau 9.3

Tharashasank Davuluru Sep 8, 2016 5:36 AM (in response to Periyasamy S)

Hi,

Please create a store procedure and try to connect to that.
Like Show 0 Likes(0)

Actions
3. Re: Custom SQL function in Tableau 9.3

Periyasamy S Sep 15, 2016 5:38 AM (in response to Tom W)

Hi Tom,

I tried it after creating a stored procedure. But while executing the stored procedure, I am again facing the same problem with 'EXEC' keyword.

Can you plz help me on this.?

Thanks.!
Like Show 0 Likes(0)

Actions
4. Re: Custom SQL function in Tableau 9.3

Periyasamy S Sep 15, 2016 5:38 AM (in response to Tharashasank Davuluru)

Again facing the error as
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'EXECUTE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.

Please help me on this.
Like Show 0 Likes(0)

Actions
5. Re: Custom SQL function in Tableau 9.3

Tom W Sep 15, 2016 9:33 AM (in response to Periyasamy S)

You will need to provide the definition of the stored procedure.
Like Show 0 Likes(0)

Actions
6. Re: Custom SQL function in Tableau 9.3

Periyasamy S Sep 16, 2016 2:10 AM (in response to Tom W)

Thanks Tom.! I have created a user defined function and called it from tableau and it worked.!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Custom SQL function in Tableau 9.3

1. Re: Custom SQL function in Tableau 9.3

2. Re: Custom SQL function in Tableau 9.3

3. Re: Custom SQL function in Tableau 9.3

4. Re: Custom SQL function in Tableau 9.3

5. Re: Custom SQL function in Tableau 9.3

6. Re: Custom SQL function in Tableau 9.3

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account