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.