How do you configure the InetSoft Report Designer for SCTM 8.0?

0 Likes

Problem:

How do you configure the InetSoft Report Designer for SCTM 8.0?

Resolution:

QUESTION
----------------------------------

How do you configure the InetSoft Report Designer for SCTM 8.0?

ANSWER
----------------------------------

To configure the Report Designer, it may be beneficial if you are familiar with the tool itself.

In the report designer;

  1. Go to File->Configure

    You will see a dialog box, select the "Registry" tab and click on the "Select Registry Directory" button.

    First consider where you have installed the InetSoft Report Designer. You can either install the report designer on the same machine as the SilkCentral Test Manager (SCTM) Application Server or not.

    If you install on the same machine as the SCTM application server, then you simply need to point the Report Designer to the SCTM registry folder. Remember that this is the folder that contains the datasource.xml, query.xml and stylereport.srl files. By default this should be

    C:\Program Files\Segue\SilkCentral Test Manager X.X\conf

    If you installed on a separate machine to the SCTM application server, then you need to copy the files datasource.xml, query.xml, stylereport.srl from

    C:\Program Files\Segue\SilkCentral Test Manager X.X\conf

    to a folder on the machine that has InetSoft Report Designer e.g.

    c:\registry_sctm

    This folder will become the InetSoft Registry.

  2. From here you will need to add the .jar files, which are used to hold the database drivers among other things. Click on the "Classpath" tab and the files that are to be added are found in the SilkCentral Test Manager x.x\lib folder and they are called:

    axis.jar
    commons-discovery.jar
    commons-logging.jar
    jaxrpc.jar
    Opta2000.jar
    saaj.jar
    scc.jar
    silkvision.jar
    

  3. To be able to manipulate the information from the database in SCTM, you will have to create a data source using JDBC.

    To do this you will need to go to Query->Query Builder

    Click on the first icon in the top left-hand corner - "Data Source Wizard".

    Then enter the database information in this window. The username and password are the same as you use for SCTM.

    Put the following details in the final window below:

    JDBC URL: jdbc:inetdae7::1433
    Driver: com.inet.tds.TdsDriver
    Select Change Default DB - Type the name of your database in this textbox.
    

    Click on save and you should be able to see all the views within the database. The Report Designer is now configured to use with SilkCentral Test Manager.

Old KB# 24847
Comment List
Anonymous
Related Discussions
Recommended