InetSoft Reporting Software - Specifying Report Data Source

It's easy to specify the report data source with InetSoft's reporting software, a multifaceted all-in-one reporting solution that is powerful enough to stand alone and flexible enough to be embedded into complementary programs. View the example below to learn more about the Style Intelligence solution.

The 'Configuration' > 'Datasource/Lib' page allows you to set the location of the following registry files:

• datasource.xml: Database connection information and data model definition.
• query.xml: Query definitions.
• stylereport.srl: Reusable report components.

The 'Query variable names are unique' option allows you to indicate whether repeated query variable names should be treated as unique (and utilize a common prompt).

View a five-minute Flash demo to get an overview of what InetSoft's Reporting Software can do.

 

 

 

The 'Connection Pool' option allows you to specify the type of connection pool to use for JDBC data sources. If you select the 'Application Server' connection pool, the data source names in the data source registry file must match a corresponding JNDI lookup name in your application server. Supported application servers are Tomcat, WebSphere and WebLogic. If you select a 'User Defined' connection pool, you must enter the fully qualified class name of the ConnectionPool implementation in the provided text field, and it must be accessible from the web application's classpath.

Note that the 'Application Server' connection pool option will not apply to the Scheduler, as it runs in an independent JVM and cannot access the application server connection pool.
You can use a database for persistent storage of the following items:

• Data space (report templates, datasource.xml, query.xml, etc.)
• Asset repository
• Audit Records

The following data­bases are supported: Oracle, DB2, SQL Server, and Derby.

To configure a database for persistent storage, open the 'Configuration' > 'Database' page, and specify the database type, connection information, and the transaction isolation level.

The storage of these elements can be configured on the 'Data Space' and 'Audit' pages under the 'Repository' node.

Note: The cache and temporary files cannot be stored in a database.

The 'Default DB' field indicates the name of the database schema to be used. If left unspecified, the default database schema for the particular user profile will be used. Once the required information for the database is specified, the connection can be tested by clicking on the 'Test Connection' button.

InetSoft Viewpoint

“The intelligence of the data services platform in combining multiple external and internal data sources and presenting them at the right moment is very valuable in actually offloading back-office work from the agent to self service portals, but also in making the agent very productive. So this is a very typical use case, and we have implemented multiple systems where data virtualization is used in the support of call centers, customer self-service portals, agent portals, single customer views, etc.” - Mark Flaherty, Chief Marketing Officer

 

Evaluate InetSoft's Business Intelligence Software for your reporting software needs.

 

Previous: Managing Report Server Clusters

Next: Configuring Report Server Emails

More Resources:

		Download a Free Trial
		Binding Data to a Map Embedded in a Report
		Binding Data to a Report Section Element
		Cascaded Parameter Sheets in a Report