You can connect to SQL Azure with ODBC correct? ODBC works for the Tableau Desktop.
If you want to have users connect to live charts/graphs/maps you would need Tableau server which would need to run on a different server from SQL Azure.
Yes, my need would be to install Tableau Server on SQL Azure. Running my DB in the cloud but not my BI server makes little sense so I am forced to use SQL Aure Reporting Services for my BI needs.
Obviously it first depends on Microsoft adding more platform-as-a-service capabilities to Azure to allow such compatibility with thrid party BI.
Does Azure not allow you to set up server instances that you can install your own apps on? We run both our db and our Tableau Server in the cloud, and it's working nicely.
Note: I would not recommend using Amazon's cloud for this. There are a number of valid and useful ways to use Amazon's cloud, but running an app like Tableau Server is not one of them.
As far as I know, it is not possible today to install Tableau on Windows Azure. I would love to be proved wrong though! ;)
It sounds like you are NOT using AWS for your cloud platform. Curious who you are using, since Azure doesn't seem like viable cloud option either....
Is there any plans in Tableau for allowing your users to either install Tableau Server in a Windows Azure instance or any other cloud provider (AWS, GAE)?
You can install Tableau Server on Amazon, Terremark, and other cloud providers... just manage the machine instances yourself.
Btw, I recommend staying away from Amazon... not because of the recent issue they had, but because their performance is highly variable. I've seen a full order of magnitude difference in response time when I run the same query at 2 am and 2 pm.
Whoops... I just saw that I posted earlier in the thread about Amazon... that's what I get for not rereading the thread before posting.
And in response to Jeff H, we use Terremark at the moment. They've been pretty solid... not perfect, but pretty solid.
Further comment... we are gradually moving towards running Tableau in a non-virtualized environment. Performance per $ spent is just better on a dedicated box.
Following up on the discussions above, I have subscribed to Amazon Web Services and created a EC2 server instance.
I have installed the trial version of Tableau Server. I can connect to it locally via remote desktop (/localhost) and through the web as well.
I uploaded a workbook in twbx format. It worked fine.
However, when uploading a workbook in twb format, I got the following error message:
An error occurred on the server. The details of the error are:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Unable to connect using the DSN named "SQL Azure - BSAP". Check that the DSN exists and is a valid connection.
Errors occurred while trying to load the workbook "/views/TCSAnalytics-CharteredSpeed". The load was not able to complete successfully.
Both workbooks use the same connection string. Any idea as to what I should be looking for here?
Any help would be great!
Not sure if you got sorted. From what i can recall, that error message normally comes up if either some drivers are no installed that you need, or else if you have x64 drivers installed and not x86 ones. i assume that the packaged workbook publishes fine as the data is in tde format.
Got it all sorted out. Can't remember what the issue was back then (driver may be).
We have moved Tableau Server to a WIndows Azure instance now.
Works just fine.
I am looking into hosting our Tableau Server on some IaaS provider such as AWS or Azure. I was wondering what was your reason in switching from AWS to Windows Azure? Were there configuration issues in AWS you could not overcome such as your original post here? Or was there another reason for choosing Azure over AWS?
Also how many users do you have utilizing that instance of Tableau Server and have you experienced any performance or availability issues?
One more...do you have sensitive data in your workbooks that you publish to server? Security is another major concern considering you will usually be publishing a packaged workbook with all data along with it. Did you address or consider this?
Did you ever get any more info about Tableau on AWS v. Azure? I am interested in the same thing. I am going to deploy Server in AWS because I am more familiar with the platform, but am open to using Azure if its a better fit.