Microsoft SQL Server Database

This example discusses how to connect Tableau to a Microsoft SQL Server database.
  1. Select Data > Connect to Data to open the Connect to Data page.
  2. Select Microsoft SQL Server.
  3. Follow the steps in the Microsoft SQL Server Connection dialog box to complete the connection.
    1. Step 1 – Enter the server name or select it from the drop-down list.
      You can select a server from the drop-down menu. This menu will contain all the SQL Server databases on your computer and on the network to which you have access. Alternatively, you can type in the name of a specific server.
    2. Step 2 – Provide log in information for the server.
      Specify whether to use Windows NT Integrated security or a specific username and password.
    3. Step 3 – Test the connection.
      If the connection is successful, Tableau will alert you. If the connection is unsuccessful, verify that your user name and password are correct. If the connection continues to fail, your computer is having trouble locating the server. Contact your network administrator or database administrator.
    4. Step 4 – Use the drop-down list to select the database that you want to connect to.
    5. Step 5 – Select a table or view from the database.
      Microsoft SQL Server databases can contain multiple tables and views. Specify which table or view within the database you want to connect to. You can also connect to multiple tables or a specific query by selecting the Multiple Tables and Custom SQL options.
    6. Step 6 – Give the connection a name for use in Tableau.
      Specify a unique name for the connection. The default name is automatically generated based.
A completed Connection dialog box for Microsoft SQL Server is shown below.

23 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Nice Information...Thanks for Sharing
    Microsoft SQL Server training Certification. For more information Visit : www.ssdntech.com/sql-server-training.aspx

    ReplyDelete
  3. Hi friend iam providing theTableau training in hyderabad various cretification training.

    ReplyDelete
  4. its good to see "how to connect Tableau to a Microsoft SQL Server database"" made this one so easy to learn. Good Example. SQL Server 2016 Training | MS SQL
    Corporate Training
    teaches you basic concepts of relational databases and the SQL programming language. "

    ReplyDelete
  5. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.
    SQL Server Training in Chennai

    ReplyDelete
  6. Hi
    This blog gives very important information about SQL database. A nice article and I was really impressed by reading this article

    SQL Server 2016 Training

    ReplyDelete
  7. This is very nice blog,and it is helps for student's.Thanks for sharing
    Read more about ms sql Corporate training, sql server 2016 training

    ReplyDelete
  8. Great Article… I love to read your articles WEBLOGIC Training

    ReplyDelete
  9. Awe! What An Blog Very Helpful and interesting Really A great center for acquiring knowledge.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts .Really Thankfull For the blogger providing such a great information.Thank you. Have a Nice Day.

    ReplyDelete
  10. Whatever We Are Gathering the information from the blogs,we have to keep on updating it,Urgent Care in Chicago.By getting them into one place.Really thanks for posting.Very Thankful for the Informative Post.Keep On Posting Latest And Interesting Information About Tableau.Vert Informative Blog.

    ReplyDelete
  11. This is very informative thank you for sharing
    Tableau Online Training

    ReplyDelete
  12. I Just Love to read Your Articles Because they are very easy to understand US Medical Residency thanks for posting

    ReplyDelete
  13. This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up selenium Online Training Bangalore

    ReplyDelete
  14. It's so nice article thank you for sharing a valuable content. SQL server dba Online Training

    ReplyDelete

  15. I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging. SQL server dba Online Training Bangalore

    ReplyDelete