Providers to use when connecting to OLAP, Analysis Services
» ADOMD.NET
» Microsoft OLE DB Provider for OLAP
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» Microsoft OLE DB Provider for OLAP
» .NET Framework Data Provider for OLE DB (OleDbConnection)
ADOMD.NET
Type: .NET Framework Class Library
Usage:
Usage:
Manufacturer: Microsoft
Standard
Data Source=myServerAddress;Catalog=myDataBase;
Encrypted Connection
This one authenticates the user and encrypts the communication. This is the highest level of security.
Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=PktPrivacy;
Signed Connection
This one authenticates the user and and prevents the content in the communication to be modified.
Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=PktIntegrity;
Authenticated Connection
This one authenticates the user but does not secure the communication.
Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=Connect;
Unauthenticated Connection
This one provides no form of authentication.
Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=None;
Microsoft OLE DB Provider for OLAP
Type: OLE DB Provider
Usage: Provider=MSOLAP
Usage: Provider=MSOLAP
Manufacturer: Microsoft
Standard
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
Over HTTP
Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;
The username and password will be sent in clear text over the network using this connection string. If this is an issue, consider using the Secure HTTP (HTTPS) connection string instead.
Over Secure HTTP
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;
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
Bridging to OLE DB Provider for OLAP
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;