Page 89 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes Choose a Data Provider

You can connect utilizing an organized Microsoft .NET Framework or native OLE DB provider.
For Oracle and other third-party data causes, check if the third-party provides a native OLE DB
provider and if it does try that first. If you get errors, try one of the other .NET providers or
native OLE DB providers listed in connection manager. Be certain that any data provider you use
is established on all computers utilized to develop and run the analysis Services solutions.

Set Credentials and Impersonation Options

A data source connection can occasionally use Windows authentication or an authentication
service provided by the database administration scheme, such as SQL Server authentication
when connecting to SQL Azure databases.

!
Caution The account you identify should have a login on the isolated database server and
read permissions on the external database.

Windows Authentication

Connections that use Windows authentication are specified on the Impersonation data tab of the
Data Source Designer. Use this tab to choose the impersonation option that identifies the account
under which analysis Services runs when connecting to the external data source. Not all options
can be utilised in all scenarios.

Database Authentication

As an alternate to Windows authentication, you can specify a connection that uses an authentication
service provided by the database administration scheme. In some situations, utilising database
authentication is required. Scenarios that call for utilising database authentication includes SQL
Server authentication to connect to a Windows Azure SQL Database, or accessing a relational
data source that runs on a different operating system.

For a data source that uses database authentication, the username and password of a database
login is particular on the attachment string. Credentials are supplemented to the attachment
string when you enter a client name and password in connection manager when setting up the
data source connection in your Analysis Services model. Remember to identify a client identity
that has read permissions to the data.
When retrieving data, the client library making the connection formulates a connection request
that includes the credentials in the connection string.

Notes By default, SQL Server Data Tools (SSDT) does not save passwords with the
connection string. If the password is not saved, Analysis Services prompts you to enter the
password when it is needed.
Create a Data Source Using the Data Source Wizard

To create data source using the data source wizard follow these steps:
1. In SQL Server Data Tools, open the Analysis Services project or connect to the Analysis
Services database in which you want to define the data source.

84 LOVELY PROFESSIONAL UNIVERSITY