Monday, October 04, 2010

LANSA aXes Includes a Remote SQL Access Tool called the Data Explorer

In addition to aXes being a web-based graphical application that transforms your RPG and COBOL 5250 programs into rich internet applications, another feature aXes provides is a Data Explorer, which is included with the product. Many companies pay big bucks for SQL GUI tools they can use to develop queries and reports. aXes comes with the Data Explorer built into it.

Below are screen snapshots that can start to give one an idea of what the aXes Data Explorer can do. aXes not only provides you a browser based GUI interface, it also gets you the Data Explorer that can replace other expensive tool sets or provide additional capabilities for one fee.

The screens show a sample file that is included the standard LANSA "Demo" called the Personnel Master (PSLMST). These files have been part of the standard LANSA demonstration for many years. Some of you may be familiar with this data file so this should be a good example to use. The sample screens show how to setup a Datasource, illustrate reviewing the fields in the table as well as a view of the data from the table.

Datasource Control



Table Schema Viewer



SQL Table View



To use the aXes data explorer, a few prerequisites must be configured. Once these are ready, you can use the data explorer. We have provided a list of the prerequisites for your reference; please contact us for specific setup assistance.

  • The TCP/IP IBM DDM server is required to be configured.
  • The aXes DE HTTP server instance must be started. e.g. the one that says AXESDE in our example screens above.

Lastly, you will need to have at least one file available in your LANSA environment to be used to access. In our examples we used a demonstration file provided with LANSA's base tool called PSLMST, the personnel master, located in a library called LW@DEMOLIB.

Click here to learn more about LANSA aXes. If you would like to download a free 30 day aXes evaluation, click here. For questions, contact us at 800-877-1834.