Pivot Table Connection Wizard
Pivot Table Connection Wizard allows creating pivot tables.
It supports the following data sources:
- Database tables, views, and stored procedures on all supported database platforms
- Web and file data sources in JSON, XML, HTML, CSV, and plain text
- Data services including OData
- DBF and Excel files
Moreover, the add-in places query parameters to the ribbon.
So, you can easily change query parameters and refresh data.
The wizard steps are similar to the following wizard:
However, the wizard creates a pivot table on the final step.
Below are the steps to connect to database objects:
- Selecting a provider
- Connecting to a database
- Selecting an object
- Selecting parameters
- Inserting a pivot table
Step 1. Selecting Provider
Select the desired data provider as described in the Database Connections topic.
Use the Gartle Web Data Provider to connect to web data sources and data services.
Use the Gartle Text Data Provider to connect to file data sources.
Step 2. Connecting to Database
Connect to a database as described in the Database Connections topic.
Step 3. Selecting Object
Select a source table, view, or stored procedure.
Here is a sample screenshot:
Step 4. Selecting Parameters
The add-in detects stored procedure parameters automatically.
You can select parameters to place on the ribbon using the rightmost column W.
You can choose fields to select in the leftmost column S and the fields to filter data in the rightmost column W for tables and views.
Here is a sample:
Step 5. Inserting Pivot Table
Paste a table into a worksheet.
Here is a sample table: