Preface
Informatica Resources
Informatica Network
Informatica Knowledge Base
Informatica Documentation
Informatica Product Availability Matrices
Informatica Velocity
Informatica Marketplace
Informatica Global Customer Support
Analyst Service
Analyst Service Overview
Analyst Service Architecture
Configuration Prerequisites
Services Associated with the Analyst Service
Flat File Cache Directory
Export File Directory
Attachments Directory
Keystore File
Exception Management Audit Database
Recycle and Disable the Analyst Service
Properties for the Analyst Service
General Properties for the Analyst Service
Model Repository Service Properties
Logging Options
Human Task Properties
Run-time Properties
Metadata Manager Service Properties
Business Glossary Properties
Custom Properties for the Analyst Service
Custom Images in the Analyst Tool
Process Properties for the Analyst Service
Node Properties for the Analyst Service Process
Analyst Security Options for the Analyst Service Process
Advanced Properties for the Analyst Service Process
Custom Properties for the Analyst Service Process
Environment Variables for the Analyst Service Process
Creating and Configuring the Analyst Service
Creating an Analyst Service
Catalog Service
Overview
Associated Services
Catalog Service Privileges
Creating a Catalog Service
Configuring the Catalog Service for Azure HDInsight
Content Management Service
Content Management Service Overview
Master Content Management Service
Content Management Service Architecture
Content Management Service and High Availability
Updating the Content Management Service Master Status
Probabilistic Models and Classifier Models
Reference Data Warehouse
Orphaned Reference Data
Deleting Orphaned Tables
Recycling and Disabling the Content Management Service
Content Management Service Properties
General Properties
Multi-Service Options
Associated Services and Reference Data Location Properties
File Transfer Options
Logging Options
Custom Properties for the Content Management Service
Content Management Service Process Properties
Content Management Service Security Options
Address Validation Properties
Address Verifier Properties (Experimental)
Identity Properties
Advanced Properties
NLP Options
Custom Properties for the Content Management Service Process
Creating a Content Management Service
Data Integration Service
Data Integration Service Overview
Before You Create the Data Integration Service
Create Required Databases
Create Connections to the Databases
Create the Service Principal Name and Keytab File
Create Associated Services
Creating a Data Integration Service
Data Integration Service Properties
General Properties
Model Repository Properties
Execution Options
Logical Data Object/Virtual Table Cache Properties
Logging Properties
Deployment Options
Pass-through Security Properties
Modules
HTTP Proxy Server Properties
HTTP Configuration Properties
Result Set Cache Properties
Mapping Service Properties
Profiling Warehouse Database Properties
Advanced Profiling Properties
SQL Properties
Workflow Orchestration Service Properties
Web Service Properties
Custom Properties for the Data Integration Service
Data Integration Service Process Properties
REST API Documentation Properties
Data Integration Service Security Properties
HTTP Configuration Properties
Result Set Cache Properties
Advanced Properties
Logging Options
SQL Properties
Custom Properties for the Data Integration Service Process
Environment Variables
Data Integration Service Compute Properties
Execution Options
Environment Variables
Operating System Profiles for the Data Integration Service
Operating System Profile Components
Configuring the Data Integration Service to Use Operating System Profiles
Troubleshooting Operating System Profiles
High Availability for the Data Integration Service
Data Integration Service Restart and Failover
Data Integration Service Workflow Recovery
Data Engineering Recovery
Data Integration Service Architecture
Data Integration Service Architecture Overview
Data Integration Service Connectivity
Data Integration Service Components
Service Components
Data Preview Service Module
Mapping Service Module
Profiling Service Module
SQL Service Module
Web Service Module
Workflow Orchestration Service Module
Data Object Cache Manager
Result Set Cache Manager
Deployment Manager
Logical Data Transformation Manager
Compute Component
Execution Data Transformation Manager
DTM Resource Allocation Policy
Processing Threads
Data Integration Service Queueing
Output Files
Process Where DTM Instances Run
In the Data Integration Service Process
In Separate DTM Processes on the Local Node
In Separate DTM Processes on Remote Nodes
Single Node
Grid
Logs
Data Integration Service Management
Data Integration Service Management Overview
Enable and Disable Data Integration Services and Processes
Enable, Disable, or Recycle the Data Integration Service
Enable or Disable a Data Integration Service Process
Directories for Data Integration Service Files
Source and Output File Directories
Control File Directories
Log Directory
Output and Log File Permissions
Run Jobs in Separate Processes
DTM Process Pool Management
Rules and Guidelines when Jobs Run in Separate Processes
Maintain Connection Pools
Connection Pool Management
Pooling Properties in Connection Objects
Example of a Connection Pool
Optimize Connection Performance
PowerExchange Connection Pools
PowerExchange Connection Pool Management
Connection Pooling for PowerExchange Netport Jobs
PowerExchange Connection Pooling Configuration
Maximize Parallelism for Mappings and Profiles
One Thread for Each Pipeline Stage
Multiple Threads for Each Pipeline Stage
Maximum Parallelism Guidelines
Enabling Partitioning for Mappings and Profiles
Optimize Cache and Target Directories for Partitioning
Result Set Caching
Data Object Caching
Cache Tables
Data Object Caching Configuration
Data Object Cache Management
Configure User-Managed Cache Tables
Persisting Virtual Data in Temporary Tables
Temporary Table Implementation
Temporary Table Operations
Rules and Guidelines for Temporary Tables
Content Management for the Profiling Warehouse
Creating and Deleting Profiling Warehouse Content
Database Management
Purge
Tablespace Recovery
Database Statistics
Web Service Security Management
HTTP Client Filter
Pass-through Security
Pass-Through Security with Data Object Caching
Adding Pass-Through Security
Data Integration Service Grid
Data Integration Service Grid Overview
Grid Configuration by Job Type
Before You Configure a Data Integration Service Grid
Grid for Jobs that Run in the Service Process
Example Grid that Runs Jobs in the Service Process
Rules and Guidelines for Grids that Run Jobs in the Service Process
Configuring a Grid that Runs Jobs in the Service Process
Grid for Jobs that Run in Local Mode
Example Grid that Runs Jobs in Local Mode
Rules and Guidelines for Grids that Run Jobs in Local Mode
Configuring a Grid that Runs Jobs in Local Mode
Grid for Jobs that Run in Remote Mode
Supported Node Roles
Job Types
Example Grid that Runs Jobs in Remote Mode
Rules and Guidelines for Grids that Run Jobs in Remote Mode
Recycle the Service When Jobs Run in Remote Mode
Configuring a Grid that Runs Jobs in Remote Mode
Logs for Jobs that Run in Remote Mode
Override Compute Node Attributes to Increase Concurrent Jobs
Grid and Content Management Service
Maximum Number of Concurrent Jobs on a Grid
Editing a Grid
Deleting a Grid
Troubleshooting a Grid
Data Integration Service REST API
Data Integration Service REST API Overview
Accessing the REST API Documentation
Using the REST API
Queries
Query Structure
Query Parameters
Comparison Operators
Logical Operators
Where Clause
Rules and Guidelines
Data Integration Service Applications
Data Integration Service Applications Overview
Applications View
Applications
Application State
Application Properties
Deploying an Application
Enabling an Application
Renaming an Application
Starting an Application
Backing Up an Application
Restoring an Application
Refreshing the Applications View
Logical Data Objects
Physical Data Objects
Mappings
SQL Data Services
SQL Data Service Properties
Enabling an SQL Data Service
Renaming an SQL Data Service
Web Services
Web Service Properties
Enabling a Web Service
Renaming a Web Service
Workflows
Workflow Properties
Enabling a Workflow
Starting a Workflow
Data Privacy Management Service
Data Privacy Management Service Overview
Data Privacy Management Service Properties
General Properties
Data Privacy Management Repository
Associated Services
User Activity Configuration
Advanced Service Properties
Email Server Configuration
Custom Properties
Create the Data Privacy Management Service
Enterprise Data Preparation Service
Enterprise Data Preparation Service Overview
Before You Create the Enterprise Data Preparation Service
Creating and Managing the Enterprise Data Preparation Service
Create the Enterprise Data Preparation Service
Enabling, Disabling and Recycling the Enterprise Data Preparation Service
Editing the Enterprise Data Preparation Service
Deleting the Enterprise Data Preparation Service
Enterprise Data Preparation Service Properties
General Properties
Model Repository Service Options
Interactive Data Preparation Service Options
Data Integration Service Options
Catalog Service Options
Execution Options
Event Logging Options
Logging Options
Custom Options
Enterprise Data Preparation Service Process Properties
HTTP Configuration Options
Advanced Options
Custom Options
Environment Variables
Apache Zeppelin Options
Interactive Data Preparation Service
Interactive Data Preparation Service Overview
Before You Create the Interactive Data Preparation Service
Creating and Managing the Interactive Data Preparation Service
Create the Interactive Data Preparation Service
Enabling, Disabling, and Recycling the Interactive Data Preparation Service
Editing the Interactive Data Preparation Service
Deleting the Interactive Data Preparation Service
Interactive Data Preparation Service Properties
General Properties
Data Preparation Repository Options
Data Preparation Storage Options
Logging Options
Advanced Service Options
Custom Properties
Interactive Data Preparation Service Process Properties
HTTP Configuration Options
Advanced Options
Configuring Interactive Data Preparation Service on Grid for Scalability
Adding a New Node when the Interactive Data Preparation Service is Running
Removing Interactive Data Preparation Service Nodes from the Grid
Monitoring Interactive Data Preparation Service Node Status
Informatica Cluster Service
Overview
Informatica Cluster Service Workflow
Creating an Informatica Cluster Service
Mass Ingestion Service
Mass Ingestion Service Overview
Creating a Mass Ingestion Service
Enable, Disable, or Recycle the Mass Ingestion Service
Enabling the Mass Ingestion Service
Disabling or Recycling the Mass Ingestion Service
Mass Ingestion Service Properties
General Properties
Model Repository Properties
Logging Properties
Custom Properties for the Mass Ingestion Service
Mass Ingestion Service Process Properties
HTTP Configuration Properties
Advanced Properties
SAML Configuration
Environment Variables
Custom Properties for the Mass Ingestion Service Process
Metadata Access Service
Metadata Access Service Overview
Metadata Access Service Architecture
Metadata Access Service Properties
General Properties
Execution Options
HTTP Configuration Properties
Logging Options
Custom Properties
Metadata Access Service Process Properties
Metadata Access Service Security Properties
HTTP Configuration Properties
Advanced Properties
Custom Properties
Environment Variables
High Availability for the Metadata Access Service
Metadata Access Service Restart and Failover
Operating System Profiles for the Metadata Access Service
Operating System Profile Components
Configuring the Metadata Access Service to Use Operating System Profiles
Enable and Disable Metadata Access Services and Processes
Enable Disable or Recycle the Metadata Access Service
Enable or Disable a Metadata Access Service Process
Creating a Metadata Access Service
Logs
Metadata Manager Service
Metadata Manager Service Overview
Configuring a Metadata Manager Service
Creating a Metadata Manager Service
Metadata Manager Service Properties
Database Connect Strings
Overriding the Repository Database Code Page
Creating and Deleting Repository Content
Creating the Metadata Manager Repository
Restoring the PowerCenter Repository
Deleting the Metadata Manager Repository
Enabling and Disabling the Metadata Manager Service
Metadata Manager Service Properties
General Properties
Metadata Manager Service Properties
Database Properties
Configuration Properties
Connection Pool Properties
Advanced Properties
SAML Configuration
Custom Properties for the Metadata Manager Service
Configuring the Associated PowerCenter Integration Service
Privileges for the Associated PowerCenter Integration Service User
Model Repository Service
Model Repository Service Overview
Monitoring Model Repository
Model Repository Architecture
Client Applications
Model Repository Objects
Model Repository Database Requirements
IBM DB2 Database Requirements
IBM DB2 Version 9.1
Microsoft SQL Server Database Requirements
Oracle Database Requirements
Enable and Disable Model Repository Services and Processes
Enable, Disable, or Recycle the Model Repository Service
Enable or Disable a Model Repository Service Process
Properties for the Model Repository Service
General Properties for the Model Repository Service
Repository Database Properties for the Model Repository Service
Search Properties for the Model Repository Service
Advanced Properties for the Model Repository Service
Cache Properties for the Model Repository Service
Versioning Properties for the Model Repository Service
Custom Properties for the Model Repository Service
Properties for the Model Repository Service Process
Node Properties for the Model Repository Service Process
High Availability for the Model Repository Service
Model Repository Service Restart and Failover
Model Repository Service Management
Content Management for the Model Repository Service
Model Repository Backup and Restoration
Security Management for the Model Repository Service
Search Management for the Model Repository Service
Repository Log Management for the Model Repository Service
Audit Log Management for the Model Repository Service
Cache Management for the Model Repository Service
Version Control for the Model Repository Service
Configure and Synchronize a Model Repository After Changing Versioning Properties
Synchronizing the Model Repository with a Version Control System
Versioned Object Administration
Troubleshooting Team-based Development
Repository Object Administration
Objects View
Locked Object Administration
Creating a Model Repository Service
Configuring Monitoring Model Repository Service
PowerCenter Integration Service
PowerCenter Integration Service Overview
Creating a PowerCenter Integration Service
Enabling and Disabling PowerCenter Integration Services and Processes
Enabling or Disabling a PowerCenter Integration Service Process
Enabling or Disabling the PowerCenter Integration Service
Operating Mode
Normal Mode
Safe Mode
Running the PowerCenter Integration Service in Safe Mode
Configuring the PowerCenter Integration Service Operating Mode
PowerCenter Integration Service Properties
General Properties
PowerCenter Integration Service Properties
Advanced Properties
Operating Mode Configuration
Compatibility and Database Properties
Configuration Properties
HTTP Proxy Properties
Custom Properties for the PowerCenter Integration Service
Operating System Profiles for the PowerCenter Integration Service
Operating System Profile Components
Configuring Operating System Profiles
Troubleshooting Operating System Profiles
Associated Repository for the PowerCenter Integration Service
PowerCenter Integration Service Processes
Code Pages
Directories for PowerCenter Integration Service Files
Directories for Java Components
General Properties
Custom Properties for the PowerCenter Integration Service Process
Environment Variables
Configuration for the PowerCenter Integration Service Grid
Creating a Grid
Configuring the PowerCenter Integration Service to Run on a Grid
Configuring the PowerCenter Integration Service Processes
Resources
Editing and Deleting a Grid
Troubleshooting a Grid
Load Balancer for the PowerCenter Integration Service
Configuring the Dispatch Mode
Service Levels
Configuring Resources
Calculating the CPU Profile
Defining Resource Provision Thresholds
PowerCenter Integration Service Architecture
PowerCenter Integration Service Architecture Overview
PowerCenter Integration Service Connectivity
PowerCenter Integration Service Process
Load Balancer
Dispatch Process
Resources
Resource Provision Thresholds
Dispatch Mode
Service Levels
Data Transformation Manager (DTM) Process
Processing Threads
Thread Types
Pipeline Partitioning
DTM Processing
Reading Source Data
Blocking Data
Block Processing
Grids
Workflow on a Grid
Session on a Grid
System Resources
CPU Usage
DTM Buffer Memory
Cache Memory
Code Pages and Data Movement Modes
ASCII Data Movement Mode
Unicode Data Movement Mode
Output Files and Caches
Workflow Log
Session Log
Session Details
Performance Detail File
Reject Files
Row Error Logs
Recovery Tables Files
Control File
Email
Indicator File
Output File
Cache Files
High Availability for the PowerCenter Integration Service
High Availability for the PowerCenter Integration Service Overview
Resilience
PowerCenter Integration Service Client Resilience
External Component Resilience
Restart and Failover
Running on a Single Node
Running on a Primary Node
Running on a Grid
Recovery
Stopped, Aborted, or Terminated Workflows
Running Workflows
Suspended Workflows
PowerCenter Integration Service Failover and Recovery Configuration
PowerCenter Repository Service
PowerCenter Repository Service Overview
Creating a Database for the PowerCenter Repository
Creating the PowerCenter Repository Service
Before You Begin
Creating a PowerCenter Repository Service
Database Connect Strings
PowerCenter Repository Service Properties
Node Assignments
General Properties
Repository Properties
Database Properties
Advanced Properties
Metadata Manager Service Properties
Custom Properties for the PowerCenter Repository Service
PowerCenter Repository Service Process Properties
Custom Properties for the PowerCenter Repository Service Process
Environment Variables
High Availability for the PowerCenter Repository Service
Resilience
Restart and Failover
Recovery
PowerCenter Repository Management
PowerCenter Repository Management Overview
PowerCenter Repository Service and Service Processes
Enabling and Disabling a PowerCenter Repository Service
Enabling and Disabling PowerCenter Repository Service Processes
Operating Mode
Running a PowerCenter Repository Service in Exclusive Mode
Running a PowerCenter Repository Service in Normal Mode
PowerCenter Repository Content
Creating PowerCenter Repository Content
Deleting PowerCenter Repository Content
Upgrading PowerCenter Repository Content
Enabling Version Control
Managing a Repository Domain
Prerequisites for a PowerCenter Repository Domain
Building a PowerCenter Repository Domain
Promoting a Local Repository to a Global Repository
Registering a Local Repository
Viewing Registered Local and Global Repositories
Moving Local and Global Repositories
Managing User Connections and Locks
Viewing Locks
Viewing User Connections
Closing User Connections and Releasing Locks
Sending Repository Notifications
Backing Up and Restoring the PowerCenter Repository
Backing Up a PowerCenter Repository
Viewing a List of Backup Files
Restoring a PowerCenter Repository
Copying Content from Another Repository
Repository Plug-in Registration
Registering a Repository Plug-in
Unregistering a Repository Plug-in
Audit Trails
Repository Performance Tuning
Repository Statistics
Repository Copy, Back Up, and Restore Processes
PowerExchange Listener Service
PowerExchange Listener Service Overview
DBMOVER Statements for the Listener Service
Creating a Listener Service
Listener Service Properties
PowerExchange Listener Service General Properties
PowerExchange Listener Service Configuration Properties
Environment Variables for the Listener Service Process
Editing Listener Service Properties
Editing Listener Service General Properties
Editing Listener Service Configuration Properties
Enabling, Disabling, and Restarting the Listener Service
Enabling the Listener Service
Disabling the Listener Service
Restarting the Listener Service
Listener Service Logs
Listener Service Restart and Failover
PowerExchange Logger Service
PowerExchange Logger Service Overview
Configuration Statements for the Logger Service
Creating a Logger Service
Properties of the PowerExchange Logger Service
PowerExchange Logger Service General Properties
PowerExchange Logger Service Configuration Properties
Logger Service Management
Configuring Logger Service General Properties
Configuring Logger Service Configuration Properties
Configuring the Logger Service Process Properties
Enabling, Disabling, and Restarting the Logger Service
Enabling the Logger Service
Disabling the Logger Service
Restarting the Logger Service
Logger Service Logs
Logger Service Restart and Failover
SAP BW Service
SAP BW Service Overview
Creating the SAP BW Service
Enabling and Disabling the SAP BW Service
Enabling the SAP BW Service
Disabling the SAP BW Service
Configuring the SAP BW Service Properties
General Properties
SAP BW Service Properties
Configuring the Associated Integration Service
Configuring the SAP BW Service Processes
Load Balancing for the SAP BW System and the SAP BW Service
Viewing Log Events
Search Service
Search Service Overview
Search Service Architecture
Search Index
Extraction Interval
Search Request Process
Search Service Properties
General Properties for the Search Service
Logging Options for the Search Service
Search Options for the Search Service
Custom Properties for the Search Service
Search Service Process Properties
Advanced Properties of the Search Service Process
Environment Variables for the Search Service Process
Custom Properties for the Search Service Process
Creating a Search Service
Enabling the Search Service
Recycling and Disabling the Search Service
System Services
System Services Overview
Email Service
Before You Enable the Email Service
Email Service Properties
Email Service Process Properties
Enabling, Disabling, and Recycling the Email Service
Accessing Email Service Logs
Resource Manager Service
Resource Manager Service Architecture
Before You Enable the Resource Manager Service
Resource Manager Service Properties
Resource Manager Service Process Properties
Enabling, Disabling, and Recycling the Resource Manager Service
REST Operations Hub Service
REST Operations Hub Service Properties
REST Operations Hub Service Process Properties
Enabling and Disabling the REST Operations Hub Service
Scheduler Service
Before You Enable the Scheduler Service
Scheduler Service Properties
Scheduler Service Process Properties
Enabling, Disabling, and Recycling the Scheduler Service
Test Data Manager Service
Test Data Manager Service Overview
Test Data Manager Service Dependencies
Test Data Manager Service Properties
General Properties
Service Properties
TDM Repository Configuration Properties
TDM Server Configuration Properties
Advanced Properties
Database Connection Strings
Configuring the Test Data Manager Service
Creating the Test Data Manager Service
Enabling and Disabling the Test Data Manager Service
Editing the Test Data Manager Service
Create or Upgrade TDM Repository Content
Assigning the Test Data Manager Service to a Different Node
Assigning a New License to the Test Data Manager Service
Deleting the Test Data Manager Service
Test Data Warehouse Service
Test Data Warehouse Service Overview
Test Data Warehouse Services Dependencies
Test Data Warehouse Service Properties
General Properties
Test Data Warehouse Repository Configuration Properties
Test Data Warehouse Properties
Test Data Warehouse Server Configuration Properties
Creating the Test Data Warehouse Service
Process Properties for the Test Data Warehouse Service
Web Services Hub
Web Services Hub Overview
Creating a Web Services Hub
Enabling and Disabling the Web Services Hub
Web Services Hub Properties
General Properties
Service Properties
Advanced Properties
Custom Properties for the Web Services Hub
Configuring the Associated Repository
Adding an Associated Repository
Editing an Associated Repository
Application Service Upgrade
Application Service Upgrade Overview
Privileges to Upgrade Services
Service Upgrade from Previous Versions
Run the Upgrade Wizard
Verify the Model Repository Service Upgrade
Object Dependency Graph
Application Service Databases
Application Service Databases Overview
Set Up Database User
Data Object Cache Database Requirements
IBM DB2 Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
Exception Management Audit Database Requirements
IBM DB2 Database Requirements
Microsoft Azure SQL Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
PostgreSQL Requirements
Metadata Manager Repository Database Requirements
IBM DB2 Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
Model Repository Database Requirements
IBM DB2 Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
PostgreSQL Database Requirements
PowerCenter Repository Database Requirements
IBM DB2 Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
Sybase ASE Database Requirements
PostgreSQL Database Requirements
Profiling Warehouse Requirements
IBM DB2 Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
Reference Data Warehouse Requirements
IBM DB2 Database Requirements
Microsoft Azure SQL Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
PostgreSQL Database Requirements
Workflow Database Requirements
IBM DB2 Database Requirements
Microsoft Azure SQL Database Requirements
Microsoft SQL Server Database Requirements
Oracle Database Requirements
PostgreSQL Database Requirements
Configure Native Connectivity on Service Machines
Configure Database Client Environment Variables
Connecting to Databases from Windows
Connecting to an IBM DB2 Universal Database from Windows
Configuring Native Connectivity
Connecting to an Informix Database from Windows
Configuring ODBC Connectivity
Connecting to Microsoft Access and Microsoft Excel from Windows
Configuring ODBC Connectivity
Connecting to a Microsoft SQL Server Database from Windows
Configuring Native Connectivity
Configuring Custom Properties for Microsoft SQL Server
Connecting to a Netezza Database from Windows
Configuring ODBC Connectivity
Connecting to an Oracle Database from Windows
Configuring Native Connectivity
Connecting to a PostgreSQL Database
Configuring Native Connectivity
Connecting to a Sybase ASE Database from Windows
Configuring Native Connectivity
Connecting to a Teradata Database from Windows
Configuring ODBC Connectivity
Connecting to Databases from UNIX or Linux
Connecting to an IBM DB2 Universal Database
Configuring Native Connectivity
Connecting to a Microsoft SQL Server Database
Connecting to an Oracle Database
Configuring Native Connectivity
Connecting to a PostgreSQL Database
Configuring Native Connectivity
Connecting to a Teradata Database
Configuring ODBC Connectivity
Connecting to a JDBC Data Source
Connecting to an ODBC Data Source
Sample odbc.ini File
Updating the DynamicSections Parameter of a DB2 Database
DynamicSections Parameter Overview
Setting the DynamicSections Parameter
Downloading and Installng the DDconnect JDBC Utility
Running the Test for JDBC Tool
Preface
Setting the DynamicSections Parameter
AnalystTool_recycle_disable
AnalystTool_DomainViewActions
edit_analystservice_general_properties
edit_analystservice_prs_service_options
edit_analystservice_logging_options
edit_analystservice_dis_service_options
analystservice_properties
edit_analystservice_MMService_options
edit_analystservice_BG_options
edit_analystservice_custom_properties
edit_analystservice_custom_properties_new
analystservice_processes
edit_analystservice_advanced_properties
analystservice_process_customproperties
analystservice_process_customproperties_new
analystservice_process_environmentvariables
analystservice_process_environmentvariables_new
analystservice_creation
ldm_catalogservice_create
ContentManagementService_recycle_disable
cms_edit_content_management_service_properties_options
cms_edit_data_service_options
cms_edit_logging_options
cms_edit_custom_properties_options
cms_edit_content_management_service_security_process_options
cms_editaddressvalidationoptions
cms_edit_address_validation_manager_process_options
cms_edit_custom_properties_process_options
cms_create_dialog
dis_create_dialog
dis_data_service_properties
dis_edit_data_service_properties
dis_edit_prs_service
dis_edit_exec_options_properties
dis_data_object_cache_properties
dis_edit_logging_options
dis_edit_deployment_options
dis_edit_pass-through_properties
dis_edit_modules
dis_edit_http_proxy_server_properties
dis_edit_http_configuration_properties
dis_edit_result_set_cache_properties
dis_edit_mapping_serv_prop
dis_edit_profiling_warehouse_properties
dis_adv_profiling_prop
dis_edit_advanced_profiling_properties
dis_edit_wos_properties
dis_edit_web_service_properties
dis_edit_custom_properties
dis_edit_custom_properties_new
dis_data_service_processes
disprocess_edit_data_service_security
disprocess_edit_http_configuration_properties
disprocess_edit_result_set_properties
disprocess_edit_advanced_properties
disprocess_editloggingoptions
disprocess_editsqlproperties
disprocess_editcustomproperties
dis_editcustompropertiessvcprocess_new
disprocess_editenvironvariables
dis_editenvironvariables_new
discompute
discompute_editexecutionoptions
discompute_editenvironvars
discompute_newenvironvar
dis_edit_sql_properties
DataIntegrationService_recycle_disable
DIS_enablerecycle
dbconn_pool
dbconn_poolprops
dis_deploy_applications
dis_applications_tab
dis_edit_general_properties
dis_appgenprops
app_startup_type
app_rename
dis_restore_application
dis_logicalobjectprops
dis_physicalobjectprops
dis_mapprops
dis_edit_sql_ds_prop
dis_edit_virt_table
dis_edit_virt_column
dis_edit_virt_stored_procedure
SQLDS_rename
dis_web_services_properties
dis_operation_properties
webservices_rename
start_workflow_mon
edit_dpmservice_general_properties
edit_dpmservice_repository_properties
edit_dpmservice_service_properties
edit_dpmservice_useractivity_properties
edit_dpmservice_advanced_properties
edit_dpmservice_emailserver_properties
edit_dpmservice_custom_properties
IDLService_create
IDLService_properties
IDLService_generalproperties
IDLService_repoptions
IDLService_dpsoptions
IDLService_disoptions
IDLService_ctgoptions
IDLService_execution
IDLService_auditoptions
IDLService_logoptions
IDLService_process
IDLService_httpconfig
IDLService_advoptions
IDLService_newcustprop
IDLService_editcustprop
IDLService_newenvvar
IDLService_editenvvar
DataPrepService_create
DataPrepService_properties
DataPrepService_generalproperties
DataPrepService_sqlconfig
DataPrepService_expoptions
DataPrepService_logoptions
DataPrepService_advconfig
DataPrepService_newcustprop
DataPrepService_editcustprop
DataPrepService_process
DataPrepService_httpconfig
DataPrepService_revadvoptions
mis_new_mi_service
MassIngestion_recycle_disable
MassIngestion_enable
MassIngestion_properties
edit_MassIngestion_generalproperties
RevService_mrsoptions
edit_MassIngestion_loggingoptions
mis_service_custom_properties
MassIngestion_processes
edit_MassIngestionprocess_advancedproperties
edit_MassIngestionprocess_environmentvariables
edit_MassIngestionprocess_customproperties
mas_data_service_properties
mas_edit_data_service_properties
mas_edit_exec_options_properties
masprocess_http_configuration_properties
mas_edit_logging_options
mas_edit_custom_properties
mas_data_service_processes
masprocess_edit_data_service_security
masprocess_edit_http_configuration_properties
masprocess_edit_advanced_properties
mas_editcustompropertiessvcprocess
mas_editenvironvariables
MetadataAccessService_recycle_disable
mas_enablerecycle
mas_create_dialog
mmservice_create_dialog
mmservice_create_contents_dialog
mmservice_restore_contents_dialog
MetadataManagerService_recycle_disable
mmservice_properties
mmservice_GenProps
mmservice_MMSvcProps
mmservice_DBProps
mmservice_ConfigProps
mmservice_ConnPoolProps
mmservice_AdvProps
mm_edit_custom_properties
mmservice_associated_is
PRSService_recycle_disable
MRS_DomainViewActions
modelrepservice_editgenproperties
modelrepservice_editdbproperties
modelrepservice_editsearchproperties
modelrepservice_advancedproperties
modelrepservice_editcacheproperties
modelrepservice_editversioningproperties
modelrepservice_edit_vcs_cnx_dialog
modelrepservice_editcustomproperties
modelrepservice_editcustomproperties_new
modelrepserviceprocess_viewproperties
modelrepserviceprocess_searchproperties
modelrepserviceprocess_repositoryDBproperties
modelrepserviceprocess_auditproperties
modelrepserviceprocess_repositoryproperties
modelrepserviceprocess_customproperties
modelrepserviceprocess_customproperties_new
modelrepserviceprocess_envirvarproperties
modelrepserviceprocess_envirvarproperties_new
modelrepservice_viewproperties
modelrepservice_delete
modelrepservice_backup
modelrepservice_restore
modelrepservice_viewbackups
mrs_deleteindex
tbd_checkin_objects_dialog
tbd_undo_checkout_dialog
tbd_reassign_objects_dialog
modelrepservice_objectstab_actionsmenu_help
modelrepservice_create
create_new_intservice_dialog
PowerCenterIntegrationService_recycle_disable
disable_intservice_process_dialog
intservice_properties
PCIntService_GenProps
PCIntService_SvcProps
PCIntService_AdvProps
PCIntService_OpModeConfig
PCIntService_CompDBProps
PCIntService_ConfigProps
PCIntService_ProxyProps
PCIntService_CustomProps
PCIntService_CustomProps_new
intservice_associatedrepository
intservice_processes
PCIntSvcProcess_GenProps
PCIntSvcProcess_CustomProps
PCIntSvcProcess_CustomProps_new
PCIntSvcProcess_EnvVars
PCIntSvcProcess_EnvVars_new
grid_properties
node_resources
domain_resources
node_new_resource
create_new_repservice_dialog
repservice_properties
PCRepService_GenProps
PCRepService_RepoProps
PCRepService_DBProps
PCRepService_AdvProps
repservice_lineage
PCRepService_lineage
PCRepService_CustomProps
PCRepService_CustomProps_new
repservice_processes
repservice_custom_prop
repservice_custom_prop_new
repserviceprocess_env_var_new
repservice_processes_env_var_new
repservice_env_var
repserviceprocess_env_var
repservice_activity_logs
PowerCenterRepositoryService_recycle_disable
restart_repository_service_dialog
repservice_create_contents
repservice_delete_contents
repservice_register_ldr
repservice_unregister_ldr
manage_list_dialog
repservice_view_registered
repservice_connections
repservice_locks
repservice_closeconnections
repservice_notify_users
repservice_back_up_contents
repservice_view_backup_files
repservice_restore_contents
repservice_copy_contents_from
repservice_plugins
create_pwx_listener_service_dialog
pwx_listener_properties
pwx_listener_edit_general_properties
pwx_listener_edit_config_properties
PWXListenerProcess_environvars
pwx_editlistenerenvironvars
PWXListenerProcess
PwxListenerService_recycle_disable
create_pwx_logger_service_dialog
pwx_logger_properties
pwx_logger_edit_general_properties
pwx_logger_edit_config_properties
PWXLoggerProcess
PWXLoggerProcess_environvars
pwx_editloggerenvironvars
PWXlogger_recycle_disable
create_new_sapservice_dialog
HIDD_PMBW_CONFIG_DIALOG
PCBWService_recycle_disable
sapservice_properties
sapservice_GenProps
sapservice_SAPBWSvcProps
sapservice_associated_intservice
sapservice_processes
SAPSvcProcess_GenProps
searchservice_properties
edit_searchservice_generalproperties
edit_searchservice_loggingoptions
edit_searchservice_searchoptions
edit_searchservice_customproperties
edit_searchservice_customproperties_new
SearchService_processes
edit_searchserviceprocess_advancedproperties
edit_searchserviceprocess_environmentvariables
edit_searchservice_process_environmentvariables_new
edit_searchserviceprocess_customproperties
edit_searchserviceprocess_customproperties_new
create_search_service
SearchService_enable
SearchService_recycle_disable
searchservice_recycle
builtinsvcs_folder
es_properties
edit_emailservice_smtpoptions
EmailService_processes
EmailService_recycle_disable
es_disable_recycle
resourcemgr_properties
resourcemgr_editgenproperties
resourcemgr_editlogproperties
resourcemanager_processes
resourcemgr_editenvironvars
resourcemgr_newenvironvar
RMS_DomainViewActions
resourcemanager_recycle_disable
roh_edit_logging_options
roh_edit_custom_properties
roh_edit_custom_properties_new
rps_edit_custom_properties
rps_edit_custom_properties_new
edit_schedulerservice_loggingoptions
edit_schedulerservice_persistenceoptions
edit_schedulerservice_storageoptions
sch_properties
SchedulerService_processes
schedulerprocess_edit_data_service_security
schedulerprocess_edit_http_configuration_properties
edit_schedulerserviceprocess_advancedproperties
sch_editenvironvars
sch_newenvironva
SS_DomainViewActions
SchedulerService_recycle_disable
tdmservice_GeneralProperties
tdmservice_ServiceProperties
tdmservice_RepoProperties
tdmservice_TdmServerConfiguration
tdmservice_AdvancedConfiguration
tdmservice_create
tdmservice_EnvironmentOptions
tdmservice_processes
TDM_recycle_disable
tdwservice_properties
tdwservice_GeneralProperties
tdwservice_RepoProperties
tdwservice_MartProperties
tdwservice_ServerConfigurationProperties
tdwservice_AdvancedProperties
tdwservice_create
CREATE_NEW_WSH
DISABLE_WSH
WSHubService_recycle_disable
WSH_PROPERTIES
WSH_GenProps
WSH_WebSvcHubProps
WSH_AdvProps
WSH_CustomProps
wsh_CustomProps
WSH_ASSOCIATEDREPOSITORY
upgrade_service_content
upgrade_service_dependency
upgrade_service_login
upgrade_service_ldap
upgrade_service_processing
upgrade_service_summary
upgrade_users_repologin