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:
|
User |
root |
Password |
password |
Port |
3306 |
| characterEncoding | UTF-8 |
| autoReconnect | true |
| tinyInt1isBit | false |
| autoReconnectForPools | true |
Hibernate Dialect |
MySQLInnoDBDialect |
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 | root | root | jasperuser | jasperuser | foodmart | sugarcrm |
| Test Table Name | JIReportJob | JIAuditEvent | JIReportJob | JIAuditEvent | account | accounts |
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:
|
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:
|
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 | JasperServer System DataBase | Audit Analytics DataBase | FoodmartDataBase | SugarcrmDataBase |
| User | sa | sa | jasperuser | jasperuser | foodmart | sugarcrm |
| Test Table Name | jireportjob | jireportjob | jireportjob | jireportjob | account | accounts |