-
1. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
khalid norat Jun 13, 2016 3:03 AM (in response to Sunal Gupta)1 of 1 people found this helpfulWhat you require is currently not within the functionality of Tableau.
Cross Data base joins are being introduced in Tableau 10. Currently available in the Beta version.
See Link below
-
2. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Tom WJun 13, 2016 9:28 AM (in response to Sunal Gupta)
You could create a view in the Access DB to pull in the data from the SQL Server.
Otherwise you'd need some sort of ETL process or middleware to pull everything together.
-
3. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
khalid norat Jun 13, 2016 9:32 AM (in response to Sunal Gupta)1 of 1 people found this helpfulIf this is an urgent requirement and you cant wait for Tableau 10 look at tools like Alteryx - will definitely get the job done for you.
Alteryx can perform ETL task without coding and create Tableau Data Sources.
-
4. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Sunal Gupta Jun 16, 2016 11:05 AM (in response to khalid norat)Wouldn't tableau's function "append from data source" help?
-
5. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Sunal Gupta Jun 16, 2016 11:06 AM (in response to Tom W)Wouldn't tableau's function "append from data source" help to achieve this?
Thanks a lot for your comments.
-
6. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Sunal Gupta Jun 16, 2016 11:21 AM (in response to khalid norat)I want to append the data vertically (same no of columns, but more no of rows). Something like a union where for an example; the sales data from March (SQL Server) needs to be combined with that of January and February (MS Access) to visualize the sales in the quarter.
Would "append from data source" suffice the requirement?
Appreciate your valuable comments!