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

Why the need for Javascript ?

Just connect Tableau directly to SQL Server and it will work

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 ?

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]

Hi 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.

If it ends up being a feature request you'd like to see, feel free to add it to our Ideas board.....

Ideas

How to write an idea Tableau Program Managers will look at

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