Estimated completion time = 20 minutes.
In this tutorial, you will be creating an application in EASA that searches for stock data within an Access database and writes the search results to an Excel spreadsheet. In order for your application to be able to complete these tasks, you will need to configure the EASA server to connect to the database and have an active Excel Server for you to use.
Please follow the instructions below to complete this practical session. Detailed information on the tasks completed in this session can be found at Configuring Connections to External Databases.
Note: The tasks in this Practical Session require both login access to the computer acting as the EASA Server and an account with Administrator role privileges within EASA.
To connect to an Access database, EASA needs to have the database exposed as an ODBC data source. Once the ODBC data source has been created, the connection to the database can be configured in EASA and then tested.
Note: For most other relational database products, such Microsoft SQL Server, Oracle, MySQL, etc., the following step of creating an ODBC Data source is not required and you could proceed to Step 2 - Configuring the Database within EASA.
To setup the MS Access database you must first setup an ODBC System data source with Microsoft’s ODBC Data Source Administrator using the following procedure:
StockData.mdbfile to the file system of the computer acting as the EASA Server.
odbcad32.exefound in the C:\Windows\System32 folder.
odbcad32.exefound in the C:\Windows\SysWOW64 folder.
StockData.mdbfile. Click the OK button.
With the ODBC data source created, you are now ready to configure the connection to the StockData database within EASA.
Note: If Administrator is not available within the Set Mode tab, you currently don’t have Administrator privilege for your user account. Contact your EASA administrator to receive Administrator privileges or have them configure the EASA server to connect to the database.
|Parameter Name||Parameter Value|
|Validation Query:||SELECT * FROM Exchange|
The URL parameter is jdbc:odbc:<ODBC Data Source name>. Please refer to 'Step 1 - Setting up an ODBC Data Source'
The Driver Name parameter refers to an integrated Java JDBC-ODBC-Bridge driver. This driver is shipped with EASA.
The Validation Query is for testing purposes. A simple SELECT query is all that is required. INSERT, UPDATE and DELETE queries should NOT be used for Validation purposes
You will want to test the connection to the database by performing the Validation Query which you entered above.
You should now see the new StockData database in the table of databases on this page
Locate the last column Run Test.
The Test Results page appears. You should see a Test passed message along with the validation query results
The Access database named StockData is now configured within EASA and is ready for use within EASA applications.
Note: If the Excel Server software was installed on the EASA Server during installation, then you can skip to Practical Session 2.
In order to complete this tutorial, your EASA system also needs to have an active Excel Server configured for you to use. The Excel Server component must be installed on a Windows computer, which has MS Excel installed on it.
Instructions for installing the Excel Server software are given at Adding a New Compute Server or Excel Server.
Once the Excel Server software has been installed, the computer needs to be configured as an Excel Server in EASA using the following procedure:
Note: <your_server_name> is the name of the computer on which EASA Server software was just installed.
|Parameter Name||Parameter Value|
|Server Processing:||default excel server processing|
At this point, the Access database and the Excel Server required to complete this tutorial are now configured in EASA and you can continue with the next practical session.