4 Replies Latest reply on Jun 9, 2011 1:44 PM by James Baker

    Change to datasource with different schema

      Hello, I'm very new to Tableau.

      One of my end-users put together an Access database and created a Tableau workbook against it. I am being asked to upsize the workbook to SQL server, but the schema is different. Simplified:

      Access:

      Sales.OrderID

      Sales.OrderTotal

      Sales.CustomerName

      SQL Server:

      SalesHeader.OrderID

      SalesHeader.CustomerID

      SalesLine.OrderID

      SalesLine.LineTotal

      Customer.CustomerID

      Customer.CustomerName

       

      I read http://www.tableausoftware.com/support/knowledge-base/replacing-data-source but that article only seems to deal with different datasources that have the same schema. I don't really want to create a view because the user has denormalized the data to the point that it will just keep causing headaches in the future and I also don't really want to start from scratch with the workbook.

       

      Thanks!

      Mischa.