Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Log & Event Manager (LEM) > Change the database connection

Change the database connection

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 167 Votes: 0 Revisions: 7

 

1. Open Crystal Reports and create a new Report.
2. Click Database > Log On or Off Server.
3. Expand Create New Connection in the Data Explorer window and double-click JDBC (JNDI).
4. In the JDBC (JNDI) window, enter the information for the Connection URLDatabase Class Name and Connection Name fields. Click Next.

changing the database connection - 1.png


5.  On the JDBC (JNDI) Connection Information screen, enter the following credentials:

User ID field - contego
password field - reports 

The following are credentials that are needed for the Database connection:

a. LEM 6.0.0 and earlier:
User ID field - contego 
password field - reports 

b. LEM 6.0.1 and later:
Specify credentials of LEM Web/Air Console user with Reports, Administrator or Auditor role. 

changing the database connection - 2.png


6. Click Finish, and then click Close

7. Use Database > Database Expert to add tables to the report when the database connection is complete.

changing the database connection - 3.png.jpg

8. The reports are ready after the relevant tables are selected in the Database Expert and their references within the report are moved from AlertDBDSN to HSQLDB.

Last modified
19:55, 22 Jun 2016

Tags

Classifications

Public