-
1. Re: Data Extraction
amar savale Dec 2, 2019 10:51 PM (in response to Bangaru Saivivek)Hi,
Please refer below links, I hope it' s useful for you. If Useful then marked as correct band helpful.
Link:- Tableau JavaScript API: Working with sheets - YouTube
Link:- Tableau Data Connector: Microsoft SQL Server w/ SQL Server Management Studio - YouTube
Link:- Tableau Desktop Connect to SQL Server - YouTube
Thanks,
amar D. Savale
-
2. Re: Data Extraction
Chris McClellanDec 2, 2019 10:51 PM (in response to Bangaru Saivivek)
Why the need for Javascript ?
Just connect Tableau directly to SQL Server and it will work
-
3. Re: Data Extraction
Bangaru Saivivek Dec 2, 2019 10:57 PM (in response to Chris McClellan)Its not about loading data, I am having a sheet in that if i click on one name it has to display data in that in other sheet, in backend i need javascript API so that it has to directly call all the data in that table and has to display in my sheet
Have you got that ? -
4. Re: Data Extraction
Chris McClellanDec 2, 2019 11:53 PM (in response to Bangaru Saivivek)
Not really .... do you want the data to automatically from the dashboard ?
Can you create a mockup of what you're trying to do ?
If you have a bar graph, and when you click on the bar you want to see all the records that are used to create that bar .... and stay in Tableau the entire time, then you don't need the Javascript API at all.
Does that help or not ?
-
5. Re: Data Extraction
Bangaru Saivivek Dec 3, 2019 1:05 AM (in response to Chris McClellan)No you are just telling me how to get filter data its not the case here.
-
6. Re: Data Extraction
Bangaru Saivivek Dec 3, 2019 1:11 AM (in response to Bangaru Saivivek)Look If we connect oracle database or any excel sheet for example in the data source tab we will get all the data in the sheet right.
Same as that i have to directly access to that data if i click on some sheet holding that data table if i click that all the data in the sheet shouls display in my worksheet.
To understand you better i am having multiple data sources i am calling them through an ID mentioned in database so if i click on ID corresponding data table should display in 1 sheet its not possible in tableau so i asked for Javascript API.
-
7. Re: Data Extraction
Bangaru Saivivek Dec 3, 2019 10:49 PM (in response to Chris McClellan)are you there ?
-
8. Re: Data Extraction
Ciara BrennanDec 4, 2019 1:17 AM (in response to Bangaru Saivivek)
Hi Bangaru, just a friendly reminder that most of the folks here that respond to Forum questions are actually not Tableau employees. They kindly volunteer their time to help others with their Tableau questions. If you're looking for a direct link to Tableau Support, I would recommend raising a case --> Support & Services | Tableau Software
Kind Regards
Ciara
[Program Manager | Tableau Community Forums]
-
9. Re: Data Extraction
Bangaru Saivivek Dec 4, 2019 1:44 AM (in response to Ciara Brennan)Thank you ciara
-
10. Re: Data Extraction
Bangaru Saivivek Dec 4, 2019 1:45 AM (in response to Bangaru Saivivek)But ciara I think this was not by default provided by tableau, so need to have out of box idea to crack this that's why i have posted in forum
-
11. Re: Data Extraction
Steve Wood Dec 4, 2019 2:22 AM (in response to Bangaru Saivivek)1 of 1 people found this helpfulHi Bangaru,
Would it help if you drew us a picture of what you're trying to achieve? I don't think we're understanding your requirement. My first thoughts were similar to those posted by Chris. I've had another think but am still not really getting what you're after. I've drawn an example below of what I think you could be meaning, but throw that away and draw us a better picture if you think it'll help!
Thanks
Steve. -
12. Re: Data Extraction
Ciara BrennanDec 4, 2019 2:49 AM (in response to Bangaru Saivivek)
If it ends up being a feature request you'd like to see, feel free to add it to our Ideas board.....
-
13. Re: Data Extraction
Bangaru Saivivek Dec 4, 2019 8:57 PM (in response to Steve Wood)yes steve the same one
-
14. Re: Data Extraction
Steve Wood Dec 4, 2019 9:15 PM (in response to Bangaru Saivivek)Thanks Bangaru.
An interesting requirement - sounds like a fun project!
I have some follow up questions for you:
- Are the tables all the same structure (same columns) or do they differ?
- How many tables are we talking about? A handful, more, everything in the database?
- Will that list of tables change over time? "No, it's always the same 10 tables" or "Yes, as new tables are added to the database we want to see them in the dashboard!"
Depending on the answers the advice may change but ...
If the tables are all the same structure then you may actually be able to do what Chris has already suggested. E.g. could you UNION them together along with an indication of table name in the query, then use the table name as a filter?
If the tables differ in structure then do they differ by much? If not then the above option may still be workable. If the tables differ lots then continue reading.
Okay, so the tables differ quite a bit. Sweet that makes it a more challenging task. Fun times! How many tables are there? If there's always a set small number of tables then could you consider: Defining a sheet per table. Then adding a parameter and using sheet swapping in your dashboard? That would mean no need for the API side of things eh. https://www.thedataschool.co.uk/hashu-shenkar/tableau-tip-switch-between-views-dynamically-on-a-dashboard/
Still no good? Lots of tables, lots of different columns? ... or small number of tables but looking for the dashboard to cater for new tables as and when they're added to the SQL Server database? I shall have to think further on this but my first thought here would be that you're trying to build in Tableau what might be better achieved by giving someone very basic database querying access via a different tool.
If I'm still not getting please do have another go at explaining the complexity!
Ta,
Steve