Extensible development platform, with access to the Excel Add-in API.
Installing the Excel Add-in
This section describes the ALDSP Excel Add-in system requirements and how to install the add-in.
The ALDSP Excel Add-in adds the following system requirements:
Microsoft Excel 2002 (SP2) or Excel 2003 (SP1)
Windows XP (with Service Pack 2)
Disk space: 43MB (only 6 MB if Microsoft .NET Framework with SP1 is already installed)
RAM: 256K MB or more recommended
The Data Services Platform Excel Add-in is provided with Data Services Platform as a separate installation program. The Excel Add-in installs on your local machine and is accessible from Excel as a menu item.
Preparing To Install
Before installing the Excel Add-in, uninstall any previous versions of the add-in by clicking Start All Programs BEA AquaLogic Data Services Platform Excel Add-In 3.0 Unload Add-in from Excel.
Installing the Add-in
This section describes how to install the AquaLogic Data Services Platform Excel Add-in.
Microsoft .NET with SP1 is required for the ALDSP Excel Add-in installation. If Microsoft .NET Framework is not installed on your system, or you have .NET 1.1 or earlier without SP1, the Excel Add-in prompts you to confirm its installation from the Microsoft Web site. Once the correct .NET install is complete, the system proceeds with the ALDSP Excel Add-in installation. (The installation of .NET could take up to 10 minutes for download and configuration.)
To install the Excel Add-in, complete the following steps:
Launch the Excel plug-in installation program by double-clicking the following file:
You can find this file in the following directory:
where <bea_home> is the location of the BEA installation on your system. The installation program displays the welcome screen shown in Figure 6-1.
Figure 6-1 Excel Add-in Installation
Click Next to continue.
If you do not already have Microsoft .NET Framework 1.1 installed on your system, you will need to install it. You can do this using the Excel Add-in installation dialog.
Determine the user of the application. (Typically anyone with access to your system would be able to use the Add-in.)
Determine the location of the Add-in.
By default the Add-in is installed in the following directory:
C:\Program Files\BEA\AquaLogic Data Services Platform Excel Add-in
Complete the installation, and optionally launch Excel.
The ALDSP Excel Add-in adds a new item, My Data, to the Excel main menu.
Accessing Excel Add-in Documentation
After you have completed the installation, you can reference the Excel Add-in documentation, available in the following document:
AquaLogic Data Excel User Guide.pdf
This file is, by default, located in the following directory:
C:\Program Files\BEA\AquaLogic Data Services Platform Excel Add-in\Documentation
The documentation includes the following topics:
Installation and uninstallation of the Excel add-in
Using the Add-in
Managing Web Services
Refreshing Web Service Data in Excel
Information on using the Add-in is also available from the Excel MyData menu option (see Figure 6-2).
Preparing to Use the Excel Add-in
Before accessing data service operations using Excel, you must determine the WSDL URL for the web service.
To prepare to use the Excel Add-in, complete the following steps:
Create a Web Service Map for the dataspace you want to access using Excel, if one does not already exist.
To create a Web Service Map, do the following:
Launch the ALDSP Data Services Studio.
Right-click the dataspace in the Project Explorer and choose New Web Service Map.
Type a file name for the map and click Finish.
Drag-and-drop the services you want to include in the newly-created map.
Set the listen address of the WebLogic server to the host name or IP address of the machine hosting the web services.
The Excel Add-in requires that the host or IP address specified in /definitions/service/ port/soap:address/@location in the WSDL file match the host name or IP address in the WSDL URL.
To set the listen address of the server, do the following:
Using ALDSP Data Services Studio, double-click the server and click the Open WebLogic Server Admin Console link.
Log in to the WebLogic Admin Console and click Servers in the Environment section.
Click the server in the list.
Click the Lock & Edit button.
Type the host name or IP address of the machine hosting the web services in the Listen Address field.
Click the Activate Changes button.
Restart the server.
Using ALDSP Data Services Studio, right-click the Web Service Map in the Project Explorer and choose Copy WSDL URL.