Use Sybase ASE as External Data

1. Login ES Management Console by admin and no password.

2.Right click External Data, choose "New"-"Data Source":

3.Click the name of Sybase External Data,  choose the table to add excel server, and right click to select "Add Table":

4.Click columns as primary Key:

5.Choose Reading Authority:

6.Choose Writing Authority:

7. "Displayed Name" and "Displayed Column Name" can be modified as references in excel server.

8.Click "OK", defining External data is finished.

Excel Server homepage