Skip to Content
I had blogged about [xMII Illuminator Services | xMII Illuminator Services : A Primer…] and how can one start utilizing them.
This is a followup to that post and it shows how easy it is to create a simple Database Browser (it’s the favourite of all examples, isn’t it ? How could i resist ? ๐Ÿ™‚ ) using AJAX (which stands for Asynchronous Javascript and XML) and [xMII Illuminator Services. | xMII Illuminator Services : A Primer…]

First lets walk through the application.


1. The Initial Screen looks somewhat like  :


image


2. On clicking on Get Data from xMII, the Server List fills up.


image


3. Selecting a Server from the list displays the Tables from the SQL server in the Table List.


image


4. Select the Columns you want to Query on and click on Display Data.


image


5. The data from the selected Table is displayed in an IFrame :


image


Now the Big Question : How did we do it ?

We used the basic Illuminator service itself with the parameters it supports to acheive this.

A Ready Reference is given below :

&Mode=ModeList
               
             Tag       GroupList
             SQL       TableList
             XML      
             Xacute    Query
             Alarm     []
             OLAP      CubeList
             Aggregate


To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member
    Hi,

    I am not able to display the list of available servers abnd table list. Its showing an alert message as “Error parsing XML”.

    Can you please help me.

    Regards
    Muzammil

    (0) 

Leave a Reply