Configuring Other Database Connections

Configuring Databases Drivers

Use these settings to connect to a database other than PostgreSQL using the database vendor's driver.

Configuring a MySQL Connection

Database Setting	Value
Host	localhost
Name or SID	For JasperServerDataBase: jasperserver For AuditDataBase: • For Compact installation: jasperserver • For Split installation: jsaudit
User	root
Password	password
Port	3306
characterEncoding	UTF-8
autoReconnect	true
tinyInt1isBit	false
autoReconnectForPools	true
Hibernate Dialect	MySQLInnoDBDialect
Quartz Driver Delegate	StdJDBCDelegate

Configuring an Oracle Connection

To use the Oracle driver, enter the following properties:

Database Setting	Value
Host	localhost
Name or SID	Orcl
User	For JasperServerDataBase: jasperserver For AuditDataBase: • For Compact installation: jasperserver • For Split installation: jsaudit
Password	password
Port	1521
Hibernate Dialect	OracleJICustomDialect
Quartz Driver Delegate	StdJDBCDelegate

Enter the following for Test Table Name in Step 19:

Parameter Name	JasperReports Server	JasperReports Server Audit	JasperServerSystemDataBase	AuditAnalyticsDataBase	Foodmart	Sugar CRM
Name	JasperServerDataBase	AuditDataBase	Jasper Server System DataBase	Audit Analytics DataBase	FoodmartDataBase	SugarcrmDataBase
User	jasperserver	For Compact installation: jasperserver For Split installation: jsaudit	jasperuser	jasperuser	foodmart	sugarcrm
Test Table Name	DUAL	DUAL	DUAL	DUAL	DUAL	DUAL

Configuring a DB2 Connection

To use the DB2 driver, enter the properties below.

Database Setting	JasperReports Server	JasperReports Server Audit	Foodmart	Sugar CRM
Host	localhost
Name or SID	JSPRSRVR	For Compact installation: JSPRSRVR For Split installation: JSAUDIT	foodmart	sugarcrm
currentSchema	JSPRSRVR	For Compact installation: JSPRSRVR For Split installation: JSAUDIT	FOODMART	SUGARCRM
User	db2inst1
Password	password
Port	50000
Hibernate Dialect	DB2JICustomDialect
Quartz Driver Delegate	DB2v8Delegate

Enter the following for Test Table Name in Step 19:

Parameter Name	JasperReports Server	JasperReports Server Audit	Foodmart	Sugar CRM
Name	JasperServerDataBase	AuditDataBase	FoodmartDataBase	SugarcrmDataBase
User	db2inst1	db2inst1	foodmart	sugarcrm
Test Table Name	JIREPORTJOB	JIREPORTJOB	ACCOUNT	ACCOUNTS

Configuring a SQL Server Connection

To use the SQL Server driver, enter the following properties:

Database Setting	SQL Server
Host	localhost
Name or SID	For JasperServerDataBase: jasperserver For AuditDataBase: • For Compact installation: jasperserver • For Split installation: jsaudit
User	sa
Password	sa
Port	1433
Hibernate Dialect	SQLServerJICustomDialect
Quartz Driver Delegate	StdJDBCDelegate

Enter the following for Test Table Name in Step 19:

Parameter Name	JasperReports Server	JasperReports Server Audit	JasperServerSystemDataBase	AuditAnalyticsDataBase	Foodmart	Sugar CRM
Name	JasperServerDataBase	AuditDataBase	Jasper Server System DataBase	Audit Analytics DataBase	FoodmartDataBase	SugarcrmDataBase
User	sa	sa	jasperuser	jasperuser	foodmart	sugarcrm
Test Table Name	jireportjob	jireportjob	jireportjob	jireportjob	account	accounts