-
1. Re: How to pass parameters to Custom SQL datasource
Robert MortonAug 2, 2011 5:24 PM (in response to Taufek Johar)
Hi Taufek,
This is not currently possible but it is a common request and is a feature we would like to eventually support. I cannot comment on when this might happen.
-Robert
-
2. Re: How to pass parameters to Custom SQL datasource
guest contributor Dec 3, 2011 7:17 AM (in response to Taufek Johar)This is REALLY unfortunate.
Tableau is unusable for our purpose without the ability to limit custom sql based on initial parameters.
Otherwise Tableau & Tableau Server would be our clear #1 solution.
Is there no ETA to add this feature?
:(
-
3. Re: How to pass parameters to Custom SQL datasource
Robert MortonDec 3, 2011 12:12 PM (in response to Taufek Johar)
Hi Tom,
I'm sorry that this is such a show-stopper for your needs. Perhaps there are alternate ways of meeting your requirements? While you cannot yet use Parameter controls from your worksheets and dashboards to influence the Custom SQL parameters, you certainly can supply hard-coded values in your Custom SQL connection. I understand that this does not provide a fully dynamic experience, so you may wish to consider formulating your Custom SQL as a database view, since Tableau can connect to the view as if it were a table. Because Tableau pushes computations (queries) to the database, you will be able to use filters and parameters within your visualizations and be assured that the queries to your database are properly constrained by filters and aggregation to maintain efficiency.
Regarding an ETA or roadmap, this is not something we can usually offer because we need the flexibility within the development team of reprioritizing features and reacting to shifts in the technical landscape, customer needs, etc. However I will reiterate that we recognize how important this feature is for many customers, and I sincerely hope (but cannot promise) that we can address your needs by 8.0.
Thanks for your feedback,
Robert
-
4. Re: How to pass parameters to Custom SQL datasource
guest contributor Dec 9, 2011 11:05 AM (in response to Taufek Johar)to the extent it helps - add me to the list of users interested in this functionality.
thanks,
steve
-
5. Re: How to pass parameters to Custom SQL datasource
guest contributor Jan 23, 2012 12:24 PM (in response to Taufek Johar)Yes this would be a huge help for me too - I work mostly with Custom SQL as our BI team doesn't give permissions to create views or tables.
-
6. Re: How to pass parameters to Custom SQL datasource
Bill Rainey Jan 25, 2012 5:38 PM (in response to Taufek Johar)This would a great feature for me as well - want to use it to filter down the data source based on start and end time parameters on the dashboard.
-
7. Re: How to pass parameters to Custom SQL datasource
Mark Holtz Mar 22, 2012 8:49 AM (in response to Taufek Johar)Consider this my signature on this petition!
We are looking to be able to confine our data source using parameters passed into the custom SQL itself, not just a filter within Tableau. This would greatly assist with run times of our source data--currently we have extracts running every couple hours, but our users are clamoring for live data. Due to the time it takes to run our extracts, live data is just not feasible until we can reduce the queries (using dynamically controlled SQL) to only the data they're after.
Any developments, changes or further developments from anyone at Tableau?
-
8. Re: How to pass parameters to Custom SQL datasource
kevinloh Mar 22, 2012 9:46 AM (in response to Taufek Johar)This would be really nice.
A bandaid solution is to pull in everything and then create the parameters in Tableau. Which is good when the data extract is small or medium, but unwieldy when it's really large.
-
9. Re: How to pass parameters to Custom SQL datasource
Andrew Pandre Apr 12, 2012 3:45 PM (in response to Taufek Johar)Yes, please count my vote too. I need to be able to say something like that
select * from TableOrView where Field1 = Parameter1 and Field2 > Parameter2
Andrei,
-
10. Re: How to pass parameters to Custom SQL datasource
Michael Wilson May 2, 2012 3:38 PM (in response to Taufek Johar)+1 vote for us also. Not to gripe but this is a pretty useful feature and I'm very surprised the software doesn't already support it. Just about every other reporting/BI tool I've ever used has this capability and it would be a great addition to Tableau.
-
11. Re: How to pass parameters to Custom SQL datasource
Yume Gregersen Sep 4, 2012 2:11 PM (in response to Taufek Johar)Both Crystal and Cognos support this feature. It makes it much easier to limit the data set to something reasonable before being available to the tool.
-
12. Re: How to pass parameters to Custom SQL datasource
Alex Melnikov Jan 22, 2013 1:49 PM (in response to Taufek Johar)I cannot wait to have this feature available too.
Or maybe another option is allowing stored procedures as currently the choice is limited to tables/views only.
Inability to narrow down data set right away for many is definitely a show stopper!
-
13. Re: How to pass parameters to Custom SQL datasource
Sriram Srinivasan Jan 22, 2013 3:20 PM (in response to Taufek Johar)Count me as well
-
14. Re: How to pass parameters to Custom SQL datasource
Lukas Granecki Jan 29, 2013 12:58 AM (in response to Taufek Johar)vote