The most comprehensive way to do this is to use the Generator that comes with the Enterprise. The Omniscope Enterprise Generator automates the creation and deployment of personalised snapshots of database views/tables on-demand as downloaded Omniscope files, starting from pre-defined (empty) Omniscope files configured as templates for future refreshed and personalised files.

Note: The Generator should run on a continuously-running server machine that acts as a server which can be connected to using the HTTP protocol.

A link to downloadable toolkit to help you get started is located on the KnowledgeBase page about the Generator:

http://www.visokio.com/generator-help

I downloaded toolkit and setup the tomcat.
Everything went ok, except it failed to connect sql server.

http://localhost:8080/SqlServer/servlet/template.iok gives the following error message.

javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host CSSQL-DEV, named instance epdefault has failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.
com.visokio.gtk.FileOnDemandServlet.doGet(FileOnDemandServlet.java:91)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Somehow it fails to connect to sql server. I can connect the sql server from other applications. Port# 1433 and 1434 are open.

\SqlServer\WEB-INF\config.xml is



http://localhost
8301
com.microsoft.sqlserver.jdbc.SQLServerDriver
CSSQL-DEV
1433
hello
hello
epdefault
template


CSSQL-DEV is sql server name
epdefault is database name
template is table name

Thanks,

Thank you for your enquiry.

You are entering wrong values in config.xml, the config.xml should be as follows:

The name of the computer running SQL Server
1433
user name
password
The instance name of the server
database name

You can find out the database instance name by looking at the connection properties of SQL Server, and see the value with "Instance name".

If you do not have an instance name of server. The default is blank, please use MSSQLSERVER as the instance name. Please run this SQL query to verify the name "select @@servicename".

Please restart the Apache service for the edits to take effect.

Also, please install the Visokio service as instructed in this link http://www.visokio.com/kb/windows-service.

After installing the service, please enter this URL "http://localhost:8301/servicecheck.txt". You should get back the value "true", if you get "false". This means the service is not installed.

Please enter this URL "http://localhost:8080/SqlServer/servlet/template.iok" again, you need to make sure that the template should have exactly the same name as the table from which the data is being loaded. E.g. if the table is called "Laptops" the template must be called "Laptops.iok".