4.1.1 Creating a New JDBC Data Source

A data source defines the connection and login information for a database. To create a new data source, follow the steps below.

1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.

2. In the left panel of the 'New Asset' dialog box, click the 'Data Source' node on the tree.

3. In the right panel, select 'JDBC', and click 'OK'.

 

This opens the 'JDBC Data Source Wizard'.

 

4. On the General tab, enter a name for the new data source. Click 'Next' to proceed.

Database vendors provide their own JDBC drivers. Make sure that the appropriate JAR files are on the CLASSPATH. See Configuring Data Source and Query Registries in Report Design for more information. Style Studio will save the settings that you enter regardless of whether it locates the JDBC driver.

5. On the Driver tab, select the appropriate database name from the 'JDBC Type' menu. This automatically populates the 'JDBC Driver' field. Click 'OK' to proceed.

 

6. On the URL tab, enter the required connection information:

a. The 'JDBC URL', 'User', and 'Password' information should be provided by your database administrator, if needed.

b. (Optional) Select 'Requires Login' to specify that a user ID and password are required to connect to the database. For most databases, this option should be enabled.

c. (Optional) Select 'ANSI Join Syntax' to specify that queries should use the ANSI standard.

d. (Optional) In the 'Default DB' field, enter the default schema name with which the login and password are associated.

 

7. Click 'Test' to verify that Style Studio can successfully connect to the database.

8. If the test was successful, click 'Finish'. This displays the datasource definition page.

 

9. The 'Transaction Isolation' option sets the database transaction isolation level. For information about the 'Additional Connections' panel, see Adding Additional Connections.

10. The 'Table Name' option allows you to select how table names are represented in the SQL that is sent to the database.

For example, if you select the 'Schema.Table' option, the SQL string will refer to tables by both the schema name and the table name. For a schema called “ORDERS”, table names would there­fore appear in SQL as ORDERS.CATEGORIES, ORDERS.PRODUCTS, and so on. If you instead select the 'Table' option, the SQL string will refer to tables by just the table name, e.g., CATEGORIES, PRODUCTS, and so on.

11. Click the 'Save' button in the Style Studio toolbar to save the new data source to the datasource.xml file.

The new data source is now listed under the 'Data Source' node of the Asset panel.

<< 4.1 Data Source Configuration © 1996-2013 InetSoft Technology Corporation (v11.4) 4.1.2 Parameterizing the Data Source >>