OLE DB Provider for OLAP

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

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.