I am using Tableau desktop to create a workbook. When I am going to publish it to the tableau online server I am getting following error.
The tableau server you are publishing to does permit external database connections. Use the Data menu to create and extract for the following data sources.
Data Extract Required
"My data source name"
I have created a data source which get data from SQL on premises database. Can anyone give me a solution for this.
Out-of-the-box, Tableau Online only allows direct connections to specific cloud data sources. If you want to refresh your extract to on-premises data sources, you'll want to leverage the Tableau Bridge client
As the warning says, one needs to create an Extract.
Though there are several options in your Tableau workflow for creating an extract, the primary method is described below.
- After you connect to your data and set up the data source on the Data Source page, in the upper-right corner, select Extract, and then click the Edit link to open the Extract Data dialog box.
- (Optional) Configure one or more of the following options to tell Tableau how to store, define filters for, and limit the amount of data.
- When finished, click OK.
- Click the sheet tab. Clicking the sheet tab initiates the creating of the extract.
- In the subsequent dialog box, select a location to save the extract, give the extract file a name, and then click Save.
For more information on how to Extract Data, check the official documentation.
Use the Data menu to create and [sic] extract for the following data sources.- Oso