JTDataSource for Production Server Instance

JTDataSource for Production Server Instance

The following information is configured for the Production JTDataSource, which is the JTDataSource_production data source in the Agent instance. The service_production_all.sql script installs all of the components required for the Production Server instance:

Module	SQL File
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/service_production_all.sql` The following SQL scripts are merged into this single installation file.
`DAS`	`<ATG9dir>/DAS/sql/install/``vendor``/das_ddl.sql`
`DPS`	`<ATG9dir>/DPS/sql/install/``vendor``/dps_ddl.sql`
`DSS`	`<ATG9dir>/DPS/sql/install/``vendor``/dss_ddl.sql`
`DPS. LogicalOrganizations`	`<ATG9dir>/DPS/LogicalOrganizations/sql/install/``vendor``/dps_logical_orgs_ddl.sql`
`Ticketing`	`<ATG9dir>/Ticketing/sql/db_components/sql/ install/``vendor``/owning_group_ddl.sql`
`Ticketing`	`<ATG9dir>/Ticketing/sql/db_components/sql/ install/``vendor``/ticket_ddl.sql`
`DAF.Search.common`	`<ATG9dir>/DAF/Search/common/sql/db_components/``vendor``/refinement_ddl.sql`
`DAF.Search.common`	`<ATG9dir>/DAF/Search/common/sql/db_components/``vendor``/searchtesting_ddl`
`DAF.Search.Index`	`<ATG9dir>/DAF/Search/Index/sql/db_components/``vendor``/search_ddl.sql`
`DAF.Search.Routing`	`<ATG9dir>/DAF/Search/Routing/sql/db_components/``vendor``/routing_ddl.sql`
`DAF.Search.Topics`	`<ATG9dir>/DAF/Search/Topics/sql/db_components/``vendor``/search_topics_ddl.sql`
`Agent`	`<ATG9dir>/Agent/sql/db_components/``vendor``/agent_profile_ddl.sql`
`ARF.base`	`<ATG9dir>/ARF/base/sql/db_components/``vendor``/arf_base_ddl.sql`
`CAF`	`<ATG9dir>/CAF9.3/CAF/sql/install/``vendor``/ caf_all.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/unversioned_option_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/unversioned_svc_segment_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/unversioned_svc_solution_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/unversioned_offer_mgmt_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/unversioned_svc_framework_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/useroption_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/selfsvc_logging_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/selfsvc_rating_views_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/svc_user_profile_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/svc_shared_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/svc_ticket_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/solution_logical_organization_ddl.sql`
`Service`	`<ATG9dir>/Service9.3/Service/sql/db_components/``vendor``/svc_response_ddl.sql`

Data Imports

The following Production Server instance files are imported from the Service.common start up module:

Repository	Import File	Versioned
`/atg/svc/userprofiling/ ServiceSegmentRepository`	`<ATG9dir>/Service9.3/Service/common/ data/initial/svc_segment_data.xml`	False
`/atg/svc/option/ OptionRepository`	`<ATG9dir>/Service9.3/Service/common/ data/initial/svc_option_data.xml`	False
`/atg/svc/ServiceRepository`	`<ATG9dir>/Service9.3/Service/common/ data/initial/svc_solution_data.xml`	False
`/atg/svc/ui/framework/ ServiceFrameworkRepository`	`<ATG9dir>/Service9.3/Service/common/ data/initial/svc_framework.xml`	False
`/atg/svc/OfferRepository`	`<ATG9dir>/Service9.3/Service/common/ data/initial/svc_initial_offermgmt.xml`	False
`/atg/userprofiling/ ProfileAdapterRepository`	`<ATG9dir>/Service9.3/Service/common/ data/initial/svc_profile.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