It is possible to store the report result into a database instead of having the report data as xml.

To store the report result into a database, you have to specify both the ODBC connection string and the name of the destination table.

The table name is the 'TableName' attribute of the ReportOptions tag:

<ReportOptions

    xmlns="http://www.teradp.com/schemas/GN4/1/ReportOptions.xsd"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    NavOptions="None"

    TableName="myReportTable">

  <Xslt xmlns="http://www.teradp.com/schemas/GN4/1/XmlExportOptions.xsd">

...

If the table does not exist, then it is automatically created. Note that the target database must already exist.

The ODBC connection string is specified as the 'db' parameter.

For example, to store the report data into a SQLServer table, you can run the Srv4 'report' command:

srv4 report -opt report_FolderObjectSize.xml -out c:\temp\fo.xml

-pars folderPath:/system/users/administrator -db "Driver={SQL Server};Server=myServer;Database=myDatabase;uid=myUser;pwd=myPassword;"

or call the 'Report' REST web command:

http://myserver/myapp/do.ashx?Cmd=report&name=FolderObjectSize

&pars=folderPath:/system/users/administrator&db=Driver={SQL Server};Server=myServer;Database=myDatabase;uid=myUser;pwd=myPassword;

If no ODBC connection string is specified, then the report result is returned as xml, as usual.

Here are some samples of ODBC connection strings.

 

Incremental reports: