Tableau supports connecting to a good sort of data, stored during a sort of places. for instance , your data could be stored on your computer during a spreadsheet or a document , or during a big data, relational, or cube (multidimensional) database on a server in your enterprise. Or, you would possibly hook up with property right data available on the online like U.S. Bureau of the Census information, or to a cloud database source, like Google Analytics, Amazon Redshift, or Salesforce.
Starting in 2019.3, Tableau Catalog is out there within the Data Management Add-on to Tableau Server and Tableau Online. When Tableau Catalog is enabled in your environment, additionally to connecting to published data sources, you’ll hook up with databases and tables from Tableau Server on the Connect pane in Tableau Desktop. For more information about Tableau Catalog, see “About Tableau Catalog” within the Tableau Server or Tableau Online Help.
Tableau Desktop
When you launch Tableau Desktop, the info connectors that are available to you’re listed on the Connect pane, which is that the left pane on the beginning page. Under look for Data, select Tableau Server to seek out data using Tableau Server or Tableau Online. File types are listed next, then common server types, or servers that you’ve got recently connected to. Click More to ascertain the entire list of knowledge connectors you’ll use.
For supported files and databases, Tableau provides native connectors that are built for and optimized for those sorts of data. If your file or database type is listed under Connect, use this native connector to attach to your data. If your file or database type isn’t listed, you would possibly have the choice of making your own connection using Other Databases (JDBC), Other Databases (ODBC), an internet Data Connector, or a Connector Plugin built using the Tableau Connector SDK. Tableau provides limited support for connections that you simply create using these options.
The data connectors supported by your copy of Tableau Desktop are determined by the version you bought . For more information, see the list of knowledge connectors on the Tableau website. After you’ve connected to data, you’ll save the connections to possess them show up under the Saved data sources section on the Connect pane.
You supply different information for every data connection that you simply want to form . for instance , for many data connections, you’ll got to supply a server name and your sign-in information. With some data connections, you’ll Run Initial SQL statements, and SSL-enabled servers require that you simply select the Require SSL check box once you connect. the subsequent sections discuss the precise information you would like to supply for every sort of data you would like to attach to.
Tableau Server and Tableau Online web authoring
Sign in to your Tableau site and choose Create Workbook on the house page to open the hook up with Data page. The tabs that you simply see on the page depend upon the merchandise you’ve got .
The data connectors supported by your Tableau site are determined by your site’s server and your license level. For more information, see What am i able to Do with a Tableau Site?
After you’ve connected to data, you’ll save the connections to possess them show up within the Data Sources section of your site.
Request a replacement connector
If Tableau doesn’t have a native (built-in) connector for your data, consider requesting one on Tableau Community. Use Ideas on Community to look for your connector to ascertain if it has been requested, and if it’s been, vote for it. If it isn’t listed, add it. Tableau regularly reviews Ideas on Community to assist determine what features should be added to the merchandise .