question

Samy-7940 avatar image
0 Votes"
Samy-7940 asked HimanshuSinha-MSFT edited

On-prem and Cloud Consolidated Data in Report

I have Teradata database that sits on on-premise and data is on ADLS Gen2. I need to show that in

Tableau report that should dynamically show consolidated data in the dashboard. What is approach should I follow. Appreciate your help. Thanks

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ShaikMaheer-MSFT avatar image
2 Votes"
ShaikMaheer-MSFT answered HimanshuSinha-MSFT edited

Hi @Samy-7940 ,
Thanks for the ask and using the Microsoft Q&A platform .

You need to check list of data storage resources with which Tableau can connect and move your consolidated data to that resource.

Below link has list of connectors which can be supported by Tableau.
https://help.tableau.com/current/pro/desktop/en-us/exampleconnections_overview.htm

Please check below link to know list of data storage resources supported by Azure data factory as target/sink.
https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-data-stores-and-formats

Kindly go through above two documentations and choose a target resource to place consolidated data and connect Tableau with it for your reporting. Thank you.

Hope this helps.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered HimanshuSinha-MSFT edited

Hello @Samy-7940 ,

Just to add what @ShaikMaheer-MSFT suggested , if you are trying to connect to Teradata which is in-premise , you will have to Tableau Bridge . Please do read about the same here .
In your case the data is already in ADLS Gen2 , I suggest you to connect the Tableau to ADLS GEN2 and avoid the installing the bridge .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.