Using Custom SQL Queries
Connecting to a Custom SQL Query
Tableau normally determines what query should be run against Bullhorn CRM in order to build a visualization. However, these queries requres may request data than is needed, or you may need to use features specific to Bullhorn CRM that Tableau does not expose. In these cases you can write a custom SQL query.
- After you have connected to Bullhorn CRM, navigate to the Data Source tab.
- In the left pane, select your Database and Schema.
- Instead of selecting one of the available tables, click New Custom SQL.
- You are then be prompted for your query. Provide any filters aggregates or joins you want here.
- Click OK.
With your custom SQL query provided, proceed to Visualizing Data as if the selection were a normal table.