JTDataSource for Agent Server Instance

JTDataSource for Agent Server Instance

The following information is configured for the Agent JTDataSource.

SQL Files

The following SQL files are used to install the Agent. The service_agent_all.sql script performs the entire installation:

Module	SQL File
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ service_agent_all.sql` The following SQL scripts are merged into this single installation file.
`BIZUI`	`<ATG9dir>/BIZUI/sql/install/``vendor``/bizui_all_ddl.sql`
`DAF.Search.Index`	`<ATG9dir>/DAF/Search/Index/sql/db_components/``vendor``/ search_ddl.sql`
`Ticketing`	`<ATG9dir>/Ticketing/sql/db_components/``vendor``/ push_agent_ddl.sql`
`Agent`	`<ATG9dir>/Agent/sql/db_components/``vendor``/ agent_audit_ddl.sql`
`CAF`	`<ATG9dir>/CAF9.3/CAF/sql/install/``vendor``/caf_all.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ versioned_option_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ versioned_svc_segment_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ versioned_svc_solution_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ versioned_offer_mgmt_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ versioned_svc_framework_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ useroptoin_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ svc_internal_user_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ versioned_svc_process_data_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ svc_publishing_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ svc_reporting_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/ svc_migration_ddl.sql`

Data Imports

The following files are imported for the Agent Server instance:

Start Up Module	Repository	Imported File	Ver
`DSS. InternalUsers`	`/atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/Publishing/base/ install/epub-role-data.xml`	`False`
`DSS. InternalUsers`	`/atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/Service9.3/ Service/common-pub/data/ initial/svc_roles.xml`	`False`
`Service.Agent`	`/atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/Publishing/base/ install/epub-role-data.xml`	`False`
`Service.Agent`	`/atg/epub/ PublishingRepository`	`<ATG9dir>/Publishing/base/ install/epub-repository- data.xml`	`False`
`Service.Agent`	`/atg/epub/file/ PublishingFileRepository`	`<ATG9dir>/Publishing/base/ install/epub-file-repository-data.xml`	`False`
`Service.Agent`	`/atg/portal/framework/ PortalRepository`	`<ATG9dir>/BIZUI/install/ data/portal.xml`	`True`
`Service.Agent`	`atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/BIZUI/install/ data/profile.xml`	`False`
`Service.Agent`	`atg/bizui/viewmapping/ ViewMappingRepository`	`<ATG9dir>/BIZUI/install/ data/viewmapping.xml`	`False`
`Service.Agent`	`atg/bizui/viewmapping/ ViewMappingRepository`	`<ATG9dir>/AssetUI/install/ data/viewmapping.xml`	`False`
`Service.Agent`	`atg/bizui/viewmapping/ ViewMappingRepository`	`<ATG9dir>/AssetUI/install/ data/assetManagerViews.xml`	`False`
`Service.Agent`	`atg/bizui/viewmapping/ ViewMappingRepository`	`<ATG9dir>/DPS-UI/install/ data/viewmapping.xml`	`False`
`Service.Agent`	`/atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/DPS-UI/ ARF/BIZUI/data/arf-profile.xml`	`False`
`Service.Agent`	`/atg/searchadmin/ TopicRepository`	`<ATG9dir>/DAF/Search/ Topics/data/initial/ topics-data.xml`	`False`
`Service.Agent`	`/atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/Service9.3/ Service/commonpub/data/ initial/svc_profile.xml`	`False`
`Service.Agent`	`/atg/userprofiling/ InternalProfileRepository`	`<ATG9dir>/Service9.3/ Service/commonpub/data/ initial/svc_profile_arf.xml`	`False`
`Service.Agent`	`/atg/svc/userprofiling/ ServiceSegmentRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_segment_data.xml`	`True`
`Service.Agent`	`/atg/svc/option/ OptionRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_option_data.xml`	`True`
`Service.Agent`	`/atg/svc/ServiceRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_solution_data.xml`	`True`
`Service.Agent`	`/atg/svc/OfferRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_initial_offermgmt.xml`	`True`
`Service.Agent`	`/atg/svc/ui/framework/ ServiceFrameworkRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_framework.xml`	`True`
`Service.Agent`	`/atg/epub/process/ ProcessDataRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_initial_pub_data.xml`	`True`
`Service.Agent`	`/atg/bizui/viewmapping/ ViewMappingRepository`	`<ATG9dir>/Service9.3/ Service/commonpub/data/ initial/svc_viewmapping.xml`	`False`
`Service.Agent`	`/atg/bizui/viewmapping/ ViewMappingRepository`	`<ATG9dir>/Service9.3/ Service/commonpub/data/ initial/offer_mgmt_ viewmapping.xml`	`False`
`Service.Agent`	`/atg/svc/shared/ ServiceSharedRepository`	`<ATG9dir>/Service9.3/ Service/common/data/initial/ svc_initial_data_shared.xml`	`False`
`Service.Agent`	`/atg/svc/shared/ ServiceSharedRepository`	`<ATG9dir>/Service9.3/ Service/Agent/data/initial/ svc_initial_data_shared.xml`	`False`

Contents
Search

loading table of contents...

Introduction
- Audience
- Documentation Conventions
- Default Ports
- Related Documents
- Browser and Environment Requirements
Illustrating the Service Architecture
- ATG Service Components
  - Required ATG Service Dependencies
  - Optional ATG Service Dependencies
- ATG Knowledge Architecture
  - Repositories
  - Data Sources
- ATG Self Service Architecture
Requirements for Installation
- Prerequisites for Installing ATG Service Software
Installing ATG Service
- Installing ATG Service Applications
- Configuring ATG Service with CIM
Configuring Databases for ATG Service
- Prerequisites
- Required Databases and Users
- Creating Database Schemas
  - Databases and Switch Deployment
  - Schema Creation Scripts
- Configuring FakeXADataSource Files
- Configuring Data Sources for JBoss
- Enabling XA Data Sources on MS SQL
- Importing Initial Configuration Data
  - Editing WAS_HOME and WL_HOME Variables
Creating the ATG Service Servers
- Creating the Servers
- Configuring the Servers
- Configuring the LockManager and SQL Repository
- Using Window Scoped Failover
  - Adding Additional Components
Configuring ATG Reporting
- Before You Begin
- Installing ATG Service Reports
  - Installing the Reports
  - Accessing Report Metadata
- Creating the Data Warehouse
  - Creating Data Warehouse Tables
  - Creating the Data Loader Local Tables
- Configuring the Production Server
- Configuring the Management Server
- Configuring the Agent-Facing Server
- Configuring the Data Warehouse Loader Server
Assembling ATG Service
- Prerequisites
- Using the runassembler Command
- Assembling ATG Knowledge
- Assembling ATG Self Service
- Assembling ATG Reporting
- Assembling ATG Search
- Starting the Servers
- Ensuring HTTPS Connectivity
- Accessing the ATG Service Interfaces
Using ATG Search with ATG Service
- Configuring the ATG Search Server
  - Configuring the Search Engine and Deploy Share
- Configuring Search Environment
- Configuring Remote Host information
- Categorizing Topics
  - Configuring Default Topic Settings
- Configuring Profile Search
- Performance Tips for Searching
  - Modifying Number of Results Returned
  - Modifying Number of Solutions Displayed
Implementing Solution Deployment
- Before You Begin
- Deployment Concepts
- Setting Up Solution Deployment
- Deploying Solutions
Using ATG Service Workflows
- Workflows and Publishing Overview
- Installed Workflows
- Completing Workflow Definitions
- Assigning Owning Groups
- Managing Orphaned Projects
- Workflow Action Elements
- Workflow Security
  - Viewing and Working on Solutions
  - Viewing Tasks
- Service Administration Workflows
  - SvcAdmin Workflow
- Workflows and Solution Status
  - Modifying Solution Statuses
  - Creating a New Solution Status
- Modifying ATG Knowledge Workflows
- Workflow Best Practices
  - Cloning Project Instead of Editing
  - Define Workflows and Solution Classes First
Defining ATG Service Security
- Security Elements
  - Types of Security
  - Security Settings
- Security Example
  - Solution Security Example
- Organizations and Organizational Roles
- Global Roles
  - Creating Global Roles
  - Default ATG Knowledge Global Roles
- Users and User Roles
  - Creating New Internal Users
  - Adding Roles to Organizations or Users
- Creating Administration Users
  - Predefined Service Administration Roles
- Changing BCC Access Control
- Security on Service Administration Features
- Assigning Direct Access Rights to Roles
- ATG Knowledge and ATG Self Service Security
Defining ATG Service User Segments
- External User Segments
  - Sharing External File Assets
- Internal User Segments
  - Internal User Segments and Deployment
- Selecting User Segments in a Project
  - Adding a User Segment
Configuring Global Service Center Settings
- Configuring General Site Settings
- Configuring Helpful Panels Settings
  - Configuring Hot Solutions
- Configuring User Preferences Default Settings
- Setting Organization Lists
- Managing Slots and Renderers
- Customizing Personalization Panels
  - Viewing Panel Security
  - Editing Panel Content
- Configuring Messaging
  - Rendering Messages in the Message Bar
  - Implementing Client-Side Validation
ATG Ticketing Configuration and Administration
- ATG Ticketing Overview
  - Ticket Dispositions and Warnings
- Requirements
- Ticket Queues
  - Adding Ticket Queues
  - Global Ticket Queue Timing Properties
- Setting Ticket Polling
- Discarding Tickets
Customizing Ticketing
- Defining Global Context Area Defaults
- Configuring Ticket Reason Codes and Contexts
  - Modifying a Reason Code
  - Adding a New Reason Code
- Indicating Ticket Status/Sub-status
  - Modifying Ticket Sub-statuses
- Modifying Ticket Escalation
- Setting Default Ticket Priority
- Generating Ticket ID Spaces
  - das_id_generator
- Defining New Ticket Activity Types
  - Displaying Ticket Activities in Service Center
- Configuring Scheduled Services
Working with an External CRM Application
- Before You Begin
- CRM Integration Servlet
- Creating/Linking a New ATG Ticket
- Changing an External Ticket ID and Name
  - Sample Web Service Call Code
- Searching from an External CRM Application
  - Additional Search Parameters
ATG Service Access Rights
- Service Administration Page Access Rights
- Service UI Elements
  - Self Service Administration UI Options
  - Knowledge UI Direct Access Rights
- BCC Global Role Rights
- ATG Service Rights and Global Roles
  - User Access Rights and Global Roles
  - System Administrator Access Rights and Roles
- Global Service Roles and Direct Access Rights
ATG Service Framework Repository Architecture
- Service Framework Object Overview
- FrameworkObject Inherited Attributes
- FrameworkDefinition
- SkinDefinition
- TabDefinition
- CellDefinition
- PanelStackDefinition
- PanelDefinition
- Framework Supporting Object Definitions
- Framework Configuration Objects
- Framework Instance Objects
- Adding a Custom Tab in Service Center
  - Troubleshooting Tab Creation
- Environment Monitoring
  - Current Ticket Disposition
  - Environment Monitoring Components and Classes
ATG Service Repository Tables
- OptionRepository
- UserOptionRepository
  - UserOption
- ServiceSegmentRepository
  - Segment
- ServiceSharedRepository
- ServiceRepository
ATG Service Context Roots
- ATG Knowledge Mappings
- ATG Knowledge with ATG Commerce Mappings
- ATG Self Service Mappings
Service CIM Details
- Product Compatibility
- Available Add-ons
- Server Instances
  - Add On Modifications
- Data Source Configuration
- CIM File Configurations