OLE DB Provider for OLAP
In this article we will study on OLE DB Provider for OLAP.
Introduction
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.
Coding
Include "Provider=MSOLAP" in the connection string to use this provider.
|
Standard
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
|
HTTP
Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;
|
Security
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