Use SQL Server as External Data

1. Enter Excel server management Console, select "External Data", click right mouse  key, choose "New-Data Source" in the pop-up:

2. Fill the textbox:

Data Source Type supports MS SQL Server and MS Access.

Data Source Name is the name used in Data fetcher and Back writer.

Server or Data file:

    MS SQL Server:       the name of MS SQL Server 2000 or its instance.

    MS Access:             the name of database.

Database Name:

    MS SQL Server:   The name of database in MS SQL Server.

3.Click "OK":

4.Click "Pubs in the SQL server", its tables appear in the right:

5.Click the table required to use in excel server, choose "Add table":

6.Set "Displayed Name", "Display Column Name" and "Primary Key":

Displayed Name is the name of data table in Excel Server.

Actual Column Name is the name in MS SQL Server.

Data Type is the data type in MS SQL Server.

Required is "Not Allow Nulls"  of Column in the table in MS SQL Server:

Display Column name is the name of field in excel server.

Primary Key must be set as the primary key in excel server data table.

7. Set "Reading Authority":

Reading Authority allows to use the table data in excel server.

Selecting Reading Depts- choose the departments can utilize the data in this table.

Selecting Reading Roles-choose the roles can utilize the data in this table.

8. Set "Writing Authority":

Writing Authority allows to write data into this table from  excel server.

Selecting Writing Depts- choose the departments can write data into this table.

Selecting Writing Roles-choose the roles can write data into this table.

9. Click "OK":