Database Reference
In-Depth Information
Figure 2- 31.
Configuring a flat file connection
Configuring a SQL Server Connection
When configuring a SQL Server connection, the editing window allows you to identify the server name as well
as the database name, as shown in Figure
2-32
. This dialog window is almost identical to the one you used while
connecting to the data warehouse in Exercise 2-2. Microsoft reuses this same dialog window in all of the BI
projects, so expect to see it a number of times as you proceed through the book.