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.

40 comments:

  1. This comment has been removed by the author.

    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. 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
  6. Great Article… I love to read your articles WEBLOGIC Training

    ReplyDelete
  7. 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
  8. This is very informative thank you for sharing
    Tableau Online Training

    ReplyDelete

  9. Thank you for sharing this Blog, It includes very well information.
    iphone job Oriented course
    Mobile App Training Institutes

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

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

    ReplyDelete

  12. 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
  13. Really Thanks For Posting and sharing such an useful Information...

    Vizag Real Estate

    ReplyDelete
  14. Nice article and explanation is good.Thank you for sharing.
    backend development company

    ReplyDelete
  15. Thank you for this post!! I have just discovered your blog recently and I really like it! I will definitely try some of your insights.
    Regards,
    SQL Training in Chennai | SQL DPA Training in Chennai | SQL Training institute in Chennai

    ReplyDelete
  16. Best Backend Development Agency in Delhi | Green Web Technologies

    Green Web Technologies is an expert PHP Development organization with 15+ long stretches of strong involvement in web improvement utilizing Linux, Apache, MySQL, PHP (LAMP) and AJAX advancements.

    For More Info: https://www.greenwebtechnologies.co/
    Email: info@greenwebtechnologies.co
    Contact Number: 011-43008737 / +91-8851144135
    Company’s Address- A-7, Naraina Industrial Area, Phase – 1, New Delhi

    ReplyDelete
  17. Best Backend Development Agency in Delhi | Green Web Technologies

    Regardless of whether you require a custom PHP web application or need a unique Internet business store created utilizing PHP and MySQL, we are a one-stop solution.

    For More Info: https://www.greenwebtechnologies.co/
    Email: info@greenwebtechnologies.co
    Contact Number: 011-43008737 / +91-8851144135
    Company’s Address- A-7, Naraina Industrial Area, Phase – 1, New Delhi

    ReplyDelete
  18. Hi, thank you very much for new information , i learned something new. Very well written. It was so good to read and usefull to improve knowledge. Keep posting. If you are looking for any python related information please visit our website python training in pune.

    ReplyDelete
  19. I am really happy with your blog because your article is very unique and powerful for new. Apache Spark Training Institute in Pune We provide Blog, LMS, Regular Course, Self Paced Course, Webinar Session: Marketing, Project: Sell, Technical Support, Lab Service: Sell.

    ReplyDelete
  20. Nice information for a new blogger…it is really helpful
    Artificial Intelligence build and understand intelligent entities or agents 2 main approaches: “engineering” versus “cognitive modeling”
    AI Training in Bangalore

    AI Course in Bangalore

    ReplyDelete
  21. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site
    SQL Server DBA Training in Bangalore

    ReplyDelete
  22. Excellent and very cool idea and great content of different kinds of the valuable information's.

    Spark Training In Bangalore
    Apache Spark Training in Bangalore

    ReplyDelete
  23. Excellent blog. Lots of useful information here, thanks for your effort!
    Gated community Plots in Vizag

    ReplyDelete
  24. This blog is so cool. I am learning SQL Online course online. This blog helps me find out a better understanding of dot net training. Thank you for this blog!

    ReplyDelete
  25. Hi, I read your whole blog. This is very nice. Good to know about the career in. Tableau Administrator Resumes - 7 Steps to Write One + Free SamplesTableau Administrator for making their career in this field .

    ReplyDelete