Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →How to publish and share Bitbucket Data dashboards with Tableau Server
The CData ODBC driver for Bitbucket enables you integrate Bitbucket data into Tableau dashboards.
Integrate connectivity to Bitbucket data into your enterprise reporting capabilities. The CData ODBC Driver for Bitbucket enables you to access live Bitbucket data in business intelligence tools like Tableau Server. Connectivity to Bitbucket APIs enables you to monitor changes to your data in real time. Other members of your organization can access your dashboards from a Web browser and get updates from their mobile phone.
This article walks through the process of configuring a DSN on the client and server machines, publishing a data source for Bitbucket to Tableau Server, and publishing an entire Workbook to Tableau Server (including the data source). If you publish a data source, you will be able to create new, refreshable workbooks in Tableau Server.
Connect to Bitbucket as an ODBC Data Source
To create a data source or workbook in Tableau Desktop and publish the data source or workbook to Tableau server, you will need to configure a DSN on each machine (Desktop and Server), specifying connection properties and creating DSNs using the same name on each machine. Information for connecting to Bitbucket follows, along with different instructions for configuring a DSN in Windows and Linux environments.
For most queries, you must set the Workspace. The only exception to this is the Workspaces table, which does not require this property to be set, as querying it provides a list of workspace slugs that can be used to set Workspace. To query this table, you must set Schema to 'Information' and execute the query SELECT * FROM Workspaces>.
Setting Schema to 'Information' displays general information. To connect to Bitbucket, set these parameters:
- Schema: To show general information about a workspace, such as its users, repositories, and projects, set this to Information. Otherwise, set this to the schema of the repository or project you are querying. To get a full set of available schemas, query the sys_schemas table.
- Workspace: Required if you are not querying the Workspaces table. This property is not required for querying the Workspaces table, as that query only returns a list of workspace slugs that can be used to set Workspace.
Authenticating to Bitbucket
Bitbucket supports OAuth authentication only. To enable this authentication from all OAuth flows, you must create a custom OAuth application, and set AuthScheme to OAuth.
Be sure to review the Help documentation for the required connection properties for you specific authentication needs (desktop applications, web applications, and headless machines).
Creating a custom OAuth application
From your Bitbucket account:
- Go to Settings (the gear icon) and select Workspace Settings.
- In the Apps and Features section, select OAuth Consumers.
- Click Add Consumer.
- Enter a name and description for your custom application.
- Set the callback URL:
- For desktop applications and headless machines, use http://localhost:33333 or another port number of your choice. The URI you set here becomes the CallbackURL property.
- For web applications, set the callback URL to a trusted redirect URL. This URL is the web location the user returns to with the token that verifies that your application has been granted access.
- If you plan to use client credentials to authenticate, you must select This is a private consumer. In the driver, you must set AuthScheme to client.
- Select which permissions to give your OAuth application. These determine what data you can read and write with it.
- To save the new custom application, click Save.
- After the application has been saved, you can select it to view its settings. The application's Key and Secret are displayed. Record these for future use. You will use the Key to set the OAuthClientId and the Secret to set the OAuthClientSecret.
When you configure the DSN, you may also want to set the Max Rows connection property. This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations.
Windows
If you are installing the CData ODBC Driver for Bitbucket on Windows, DSN configuration is the last step of the driver installation. If you already have the driver installed, or you wish to configure new DSNs, you can use the Microsoft ODBC Data Source Administrator.
Linux
If you are installing the CData ODBC Driver for Bitbucket in a Linux environment, the driver installation predefines a system DSN. You can modify the DSN by editing the system data sources file (/etc/odbc.ini) and defining the required connection properties.
/etc/odbc.ini
[CData Bitbucket Source]
Driver = CData ODBC Driver for Bitbucket
Description = My Description
Workspace = myworkspaceslug
Schema = Information
For specific information on using these configuration files, please refer to the help documentation (installed and found online).
Publish the Bitbucket Data Source to Tableau Server
With the connections to Bitbucket data configured, you are ready to publish a Bitbucket data source on Tableau, ready to be leveraged by users in your organization to create workbooks based on Bitbucket data.
Create and Publish a Data Source
In the Connect pane, click More -> Other Databases (ODBC). Select CData Bitbucket Sys, the system DSN.
The driver installation automatically creates matching user and system DSNs: The system DSN is needed to connect from Tableau Server.
- In the Database menu, select CData.
- In the Table box, enter a table name or click New Custom SQL to enter an SQL query.
- Drag the table onto the join area.
- From the Server menu, click Publish Data Source -> (YOUR DATA SOURCE).
- Enter the URL to the server. For most instances, you will authenticate with the Tableau Server username and password. Other authentication scenarios can be found below:
- If Tableau is configured to use Kerberos and your computer has valid Active Directory credentials, Tableau connects to the server.
- If Tableau is configured to use SAML, a login prompt for your external identity provider is displayed.
- If Tableau is configured to use Active Directory, enter your Windows username and password.
- In the resulting dialog, set the Project, Data Source, and other properties. If you want to schedule refreshes, select Embedded Password in the Authentication menu. Click Publish.
You and other users in your organization can now create and share workbooks based on the published data source.
![Connectivity to your data source from the Web authoring environment in Tableau Server. (Salesforce is shown.)](../articles/odbc-tableau-server-4.png)
Refresh Workbooks
With a system DSN configured on the client (Tableau Desktop) machine and server (Tableau Server) machine, you can refresh workbooks connected to the Bitbucket data source. From the Web interface for Tableau Sever, click Data -> (YOUR DATA SOURCE) -> Refresh.
![Refresh the data extract on demand from Tableau Desktop. (Salesforce is shown.)](../articles/odbc-tableau-server-5.png)
Publish a Completed Workbook with Bitbucket Data to Tableau Server
If you have a specific Workbook that you wish to share with your organization, you can create the Workbook on Tableau Desktop and publish the Workbook directly to Tableau Server.
- To connect to Bitbucket and select data, follow steps 1-5 above.
- Click Server -> Sign in and configure the connection to the server. For most instances, you will authenticate with the Tableau Server username and password. Other authentication scenarios can be found below:
- If Tableau is configured to use Kerberos and your computer has valid Active Directory credentials, Tableau connects to the server.
- If Tableau is configured to use SAML, a login prompt for your external identity provider is displayed.
- If Tableau is configured to use Active Directory, enter your Windows username and password.
- With the data selected, select dimensions and measures to visualize and select a type of chart or graph to build your visualization(s).
- Once the Workbook is complete, click Server -> Publish Workbook to publish the Workbook to Tableau Server.
- In the resulting dialog, set the Project, Name, Description and other properties. If you want to schedule refreshes, click Edit under Data Sources and change the Authentication option to Embedded Password. Click Publish.
You and other users in your organization can now review the published workbook from Tableau Server.
![Connectivity to your published Workbook from the Web authoring environment in Tableau Server. (Salesforce is shown.)](../articles/odbc-tableau-server-9.png)