8 Replies Latest reply on Nov 21, 2012 3:04 AM by Mary Rani

Custom SQL

Mary Rani Nov 6, 2012 1:34 AM

Hi All,

I have a worksheet in tableau desktop which is connected to Oracle.

My requirement is :

Based on the input parameter given by user, the custom SQL should be formed and accordingly the data should be retrieved from the database.

Can anyone please let me know if this is possible? If yes, then how can one achieve it?

Kind Regards

Mary

1. Re: Custom SQL

Alex Kerin Nov 6, 2012 4:56 AM (in response to Mary Rani)

What is going to be different about the SQL when the user intervenes?
Like Show 0 Likes(0)

Actions
2. Re: Custom SQL

Mary Rani Nov 6, 2012 6:53 AM (in response to Alex Kerin)

Hi Alex,

The value given by the user in the parameter, will be included in the SQL query. This query will then be executed against the database and the corresponding result set will be shown in the worksheet.

I hope I have answered your question.

Please let me know if this is possible.

Thanks
Mary
Like Show 0 Likes(0)

Actions
3. Re: Custom SQL

Susan Anderson Nov 21, 2012 2:01 AM (in response to Mary Rani)

Hi Mary,

Did you get a reply to this? I am wondering the same??

Thanks
Susan
Like Show 0 Likes(0)

Actions
4. Re: Custom SQL

Mary Rani Nov 21, 2012 2:05 AM (in response to Susan Anderson)

Hi Susan,

No.

I haven't got any reply.

But I got to know that this will be supported in Tableau 8. Maybe going through the features on Tableau 8 beta would give more information on this front.

Hope this is helpful.

Thanks
Mary
Like Show 0 Likes(0)

Actions
5. Re: Custom SQL

Susan Anderson Nov 21, 2012 2:08 AM (in response to Mary Rani)

Thanks Mary,

I have raised a similar question on the Beta 8 forum, I'll let you know if I get a response.

Thanks
Susan
Like Show 0 Likes(0)

Actions
6. Re: Custom SQL

Mary Rani Nov 21, 2012 2:09 AM (in response to Susan Anderson)

Thanks Susan. I will wait for your update.

Regards
Mary
Like Show 0 Likes(0)

Actions
7. Re: Custom SQL

Susan Anderson Nov 21, 2012 3:01 AM (in response to Mary Rani)

Hi Mary,

I think I have got this working on Beta 8 version, see screenshot.
Like Show 0 Likes(0)

Actions
8. Re: Custom SQL

Mary Rani Nov 21, 2012 3:04 AM (in response to Susan Anderson)

wow. This is good news.

I can update the same to my customer as well.

Thanks Susan. Good work .

Cheers
Mary
Like Show 0 Likes(0)

Actions