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 , MS Access, Oracle, Informix.
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.
Database Name:
MS SQL Server: The name of database in MS SQL Server.
Port:
SQL Server TCP/IP port.
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 "Permission of accessing table":
The settings control who can read, write or map this table in excel server.
Name- The name of one who has the role of Report Designer.
Query-Data can be read from this table by data fetcher.
Write- The data can be written into this table by back writer.
Mapping- The data table of a form or report can be mapped on this table, the data can be written into this table.
Note:
1. Write and Mapping can be set only on non-view tables.
2. If ExcelServerRCID and ExcelServerRN are added in non-view table, mapping can be set in this table only.
8. Click "OK":
