User Tools

Site Tools

EASA Server configuration

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

To get started we need to:

A. Configure a database

The EASA Server comes with a builtin running database.

1. Let's start by looking at the off-the-shelf configuration.

  • Login into EASA and select: EASA > Set Mode > Administrator
  • Go to: EASA > Configure > Databases
  • Click: Configure Databases
  • The database named 'StockData' should be visible, as in the image below,

  • Tick the check box
  • Click: Edit Database
    …The window below appears:

Use this page to configure EASA to use an external database for this tutorial, StockData is already configured.

2. Let's run a test query to confirm that the data we need is available.

  • Select: EASA > Configure > Databases
    To the left of 'Generate Optimal Validation Query' button is an automatically generated SELECT statement
    We will run this query from the prior page
  • Click 'Cancel' to return to the prior 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
  • 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,

3. We have now confirmed that:

  • The StockData database exists
  • We may connect to it
  • There is data in the Exchange table
    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

B. Configure an Excel Server

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.

For instructions to install Excel Server software see Add a new Compute Server or Excel Server

1. Once the Excel Server software has been installed, we open the Compute Server Config Tool.

  • Go to: EASA > Administrator > Configure > Compute Servers
  • Click the 'compute server configuration' link
  • A file will download via the browser: atos.easa

2. At this point we will need to install the EASA Client software, if it is not already installed:

  • Go to: EASA > Set Mode > User
  • Go to: EASA > Install Client
  • Click on the 64-bit or 32-bit installer
  • After the download, open the installer and follow the instructions

3. Let's launch the Compute Server Configuration Tool:

  • Navigate to the download folder in 1. and to the file: atos.easa
  • Open the file
    A Tree of objects is visible
  • Add an EXCEL SERVER to the branch
  • Set
    Name: my_server_name (the hostname of the recently installed EASA Server)
    Server Processing: default excel server processing
  • Save
  • Exit the Compute Server Configuration Tool

4. Let's check the status of our Excel Server.

  • Go to: EASA > Set Mode > Administrator
  • Go to: EASA > Configure > Compute Servers
  • Click: Update Excel Servers
    …We 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 Session 2

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