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.

• To get started we need,
  • To configure the EASA server to connect to the database
  • Have an active Excel Server available

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.

• This session requires both,
  • login access to the EASA Server
  • an account with Administrator role privileges

The EASA Server comes with a running database. To configure this database, login into EASA and select:

• EASA→Set Mode→Administrator
  • Go to the database configuration page,
    • EASA→Configure→Databases
      • Click 'Configure Databases'

The database named StockData should be visible, as in the image below:

• Check the check box
• Click the Edit Database button
  • → A new window appears as 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.

• Let's run a test query to confirm that the data we need is available.
  • Go to EASA→Configure→Databases
    • To the left of the 'Generate Optimal Validation Query' button is an automatically generated SELECT statement
      • → We will run this from the prior page.
  • Click Cancel to return to this page.
  • Click on the 'Run Test' icon for StockData
    • → If the query runs, a 'Test Passed' message should be displayed.
  • Click back button in the browser.
  • Now click the 'Query Tester' icon
    • →This new page allows SQL to be entered and run.
      • Type → Select * from Exchange where id=1
      • Click 'Test Query'

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.

• Once the Excel Server software has been installed, configure it with the following steps,
  • Go to EASA→Administrator→Configure→Compute Servers
    • Click the compute server configuration link to open the Compute Server Configuration Tool
      • In order to open the Compute Server Configuration Tool, we will need to have the EASA Client software installed
        • Go to EASA→Set Mode→User→Install Client and click on the 64-bit or 32-bit installer
          • After the download, open the installer and follow the instructions.
  • In the Compute Server Configuration Tool,
    • Find the COMPUTE SERVER LIST branch.
      • Add an EXCEL SERVER to the branch and then set its parameters, below:

my_server_name is the hostname of the computer on which EASA Server software was just installed.

• Save
• Exit the Compute Server Configuration Tool.
• Go to EASA→Set Mode→Administrator→Configure→Compute Servers
  • Click on the Update Excel Servers
    • →We now see the new Excel Compute Server in the table on this page and its Status should be 'active'.

The database and the Excel Server are now configured.

Let's continue to the next session….

Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8