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:

• Database Connection Wizard
• Web Data Connection Wizard
• Text File Connection Wizard

However, the wizard creates a pivot table on the final step.

Below are the steps to connect to database objects:

1. Selecting a provider
2. Connecting to a database
3. Selecting an object
4. Selecting parameters
5. 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: