OLE DB Provider for OLAP

In this article we will study on OLE DB Provider for OLAP.
  • 2355


OLAP is a category of software technology that enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user.


Include "Provider=MSOLAP" in the connection string to use this provider.


Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;


Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;


Provider=MSOLAP;Data Source=https://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;

Using Integrated Security

Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=False;Data Source=https://serverName/;Initial Catalog=myDataBase;

Integrated Security with Kerberos

Provider=MSOLAP;Integrated Security=SSPI;SSPI=Kerberos;Persist Security Info=False;Data Source=https://serverName/;Initial Catalog=myDataBase;

You may also want to read these related articles : here

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answer here


More Articles

© 2020 DotNetHeaven. All rights reserved.