Hello Thomas,

Thank you for contacting Infragistics. We have a topic called Using ADOMD, in the PivotGrid's online documentation as well as a sample to walk you through this in our Windows Forms Samples Browser.

The code for the sample is listed below:

https://es.infragistics.com/samples/windows-forms/pivot-grid/pivot-grid-binding-to-adomd

Let me know if you have any questions.

Sincerely,

Michael Di Filippo
Associate Software Developer
Infragistics, Inc.
www.infragistics.com/support

Take a look at this thread:

https://es.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/118862/creating-flatdatasource-from-datatable-dynamically-and-use-it-in-pivotgrid 

For more details please visit our online documentation for the WinPivotGrids's FlatDataSource

Let me know if you have any questions.

I recommend referring to MSDN for more details on accessing Data from ADO.
https://msdn.microsoft.com/en-us/library/ms524771(v=vs.90).aspx

The OLE DB Connection string for SQL Server is:

Provider=SQLOLEDB.1;Data Source=path to database on server

The cube is the class specified in the data source as main data holder. This is arbitrary as to what ever the table is. Filter and measures extend how you wish to organize your data and isn't a requirement for setting up. A catalog isn't required either, from my understanding.

You may read more about the pivot grid's features here:
https://es.infragistics.com/help/wpf/xampivotgrid-features

The XamPivotGrid supports several different datasource types. You would probably benefit from using the the FlatDataSource.

eg.

SalesDataSample DataSample = new SalesDataSample();
FlatDataSource DataSource = new FlatDataSource();
FlatDataConnectionSettings DataConnectionSettings = new FlatDataConnectionSettings();
DataConnectionSettings.ItemsSource = DataSample;
DataSource.ConnectionSettings = DataConnectionSettings;
this.PivotGrid.DataSource = DataSource;

The SalesDataSample class that implements ObservableCollection

http://help.infragistics.com/Help/Doc/WPF/2016.1/CLR4.0/html/SalesDataSample.html

ObservableCollection is just one example, as the FlatDataSource can bind with any collection that implements IEnumerable.

Since you are interested in binding to SQL Data you can either use a SqlDataAdapter or LINQ to query your sql data into an object that the FlatDataSource can understand, like a DataTable object. The DataTable exposes a DefaultView property is IEnumerable

eg.
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/creating-a-datatable-from-a-query-linq-to-dataset

code snippet: Using a Data Adapter

var table = new DataTable();    
using (var da = new SqlDataAdapter("SELECT * FROM mytable", "connection string"))
{      
    da.Fill(table);
}

Binding the table with the FlatDataSource:

FlatDataSource DataSource = new FlatDataSource();
FlatDataConnectionSettings DataConnectionSettings = new FlatDataConnectionSettings();
DataConnectionSettings.ItemsSource = table.DefaultView();
DataSource.ConnectionSettings = DataConnectionSettings;
this.PivotGrid.DataSource = table.DefaultView();

We also have a SQL Data Binding sample using the XamDataGrid, which would work very similar to the FlatDataSource/XamPivotGrid.

https://es.infragistics.com/samples/wpf/data-grid/sql-data-binding

Let me know if you have any questions.

Sincerely,

Michael Di Filippo
Associate Software Developer
Infragistics, Inc.
www.infragistics.com/support