- Excel Desktop Client new !
Estimated completion time → 20 minutes.
Here we create an EASAP that searches for stock data within a database and writes the search results to an Excel spreadsheet.
Please follow the instructions below to complete this practical session. Detailed information on the tasks completed in this session can be found at Connect to an External Database.
The EASA Server comes with a running database. To configure this database, login into EASA and select:
The database named StockData should be visible, as in the image below:
If we were configuring EASA to use an external database we would need all the configuration information on this page for our application. However the tutorial data, StockData, is already configured.
A results set should appear as below,
We have now confirmed that the StockData database exists and we can connect to it and that there is data in the table Exchange. The next step is to configure the Excel Server in EASA.
To see StockData from a remote EASAP Server, change the URL from localhost to an IP address or hostname.
If the Excel Server software was installed on the EASA Server during installation, then we may skip to Session 2.
For this tutorial, we need to configure an active Excel Server. The Excel Server component must be installed on a Windows computer, which has 32-bit version of Microsoft Excel installed on it.
Instructions for installing the Excel Server software are given at Add a new Compute Server or Excel Server.
my_server_name is the hostname of the computer on which EASA Server software was just installed.
|Parameter Name||Parameter Value|
|Server Processing:||default excel server processing|
The database and the Excel Server are now configured.
Let's continue to the next session….