Network
Data Engineering
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Preparation
Cloud Integration
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
DiscoveryIQ
Cloud Data Wizard
Informatica for AWS
Informatica for Microsoft
Cloud Integration Hub
Complex Event Processing
Proactive Healthcare Decision Management
Proactive Monitoring
Real-Time Alert Manager
Rule Point
Data Integration
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Replication
Data Services
Data Validation Option
Fast Clone
Informatica Platform
Metadata Manager
PowerCenter
PowerCenter Express
PowerExchange
PowerExchange Adapters
Data Quality
Axon Data Governance
Data as a Service
Data Explorer
Data Quality
Data Security Group (Formerly ILM)
Data Archive
Data Centric Security
Secure@Source
Secure Testing
Master Data Management
Identity Resolution
MDM - Relate 360
Multidomain MDM
MDM Registry Edition
Process Automation
ActiveVOS
Process Automation
Product Information Management
Informatica Procurement
MDM - Product 360
Ultra Messaging
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
Knowledge Base
Resources
PAM (Product Availability Matrices)
Support TV
Velocity (Best Practices)
Mapping Templates
Debugging Tools
User Groups
Documentation
English
English
English
Español
Spanish
Deutsch
German
Français
French
日本語
Japanese
한국어
Korean
Português
Portuguese
中文
Chinese
Log Out
Test Data Management
10.4.1
10.5.2
10.5.1
10.5
10.4.1
10.4.0
10.2.2
10.2.1
10.2.0 HotFix 2
10.2.0 HotFix 1
10.2.0
10.2 R1
H2L
Administrator Guide
Test Data Management 10.4.1
Test Data Management 10.4.1
All Products
Rename Saved Search
Name
* This field is required
Overwrite saved search
Confirm Deletion
Are you sure you want to delete the saved search?
Table of Contents
Search
No Results
Preface
Introduction to TDM Administration
TDM Administration Overview
TDM Architecture
TDM Tools
TDM Server
TDM Services
TDM Databases
TDM Connections
Test Data Warehouse Architecture
Test Data Manager
Logging In to Test Data Manager
Changing Passwords
User and Role Administration
User and Role Administration Overview
User and User Group Management
Privileges
Data Integration Service Privilege
Model Repository Service Privileges
Informatica Privileges
Test Data Manager Service Privileges
Administration Privilege Group
Data Domains Privilege Group
Data Masking Privilege Group
Data Subset Privilege Group
Policies Privilege Group
Projects Privilege Group
Rules Privilege Group
Data Generation Privilege Group
Test Data Warehouse Service Privileges
Self-Service Portal Privileges
Optional Privileges
Test Data Manager Custom Roles
PowerCenter Permissions
Folder Permissions
Connection Object Permissions
Project Permission
Data Set Permission
Security Administration
Security Administration Overview
Kerberos Authentication for Test Data Manager
TDM Server Security
Creating a Keystore File for SSL
Configuring TLS and SSL
Configuring SSL for the Command Line Interface
Password Encryption
Creating an Encrypted Password
Encrypting the Password for the Command Line Interface
Session Timeout
Configuring Session Timeout
System Preferences
System Preferences Overview
General Properties
Data Domain Sensitivity
Project Configuration
Workflow Generation
Storage Tables for Repeatable Masking
Creating the Storage Tables
Naming Convention for Workflows, Mappings and Sessions
Creating a Naming Format For Workflows, Mappings and Sessions
Default Settings
Log Severity Level Settings
Data Discovery
Test Tool Integration
Hive Properties
Persist Mapping
TDM Server Administration
Starting and Stopping the TDM Server
Logs
Log Configuration
Log Levels
Log Location and Archives
Application Logs
License Management
Connections
Connections Overview
Connection Permissions
Connection Management
Creating a Connection
Copying a Connection
Importing a Connection
Editing a Connection
Editing Connection Permission
Deleting a Connection
AzureDWv3 Connections
DB2 for Linux, UNIX and Windows Connections
Hadoop HDFS Connection
Configuring PowerCenter for Kerberos-Enabled Hadoop HDFS Cluster
Hadoop Connections
HDFS Connections
Hive Connections
Informix Connections
JDBC Connections in a Non-Hadoop Plan
JDBC Connections in a Hadoop Plan
Microsoft SQL Server Connections
Netezza Connections
ODBC Connections
Oracle Connections
PowerExchange DB2 for i5/OS Connections
PowerExchange DB2 for Linux, UNIX and Windows Connections
PowerExchange DB2 for z/OS Connections
PowerExchange Microsoft SQL Server Connections
PowerExchange NRDB Batch Connections
PowerExchange Oracle Connections
PowerExchange Sybase Connections
Sybase Connections
Teradata Connections
Teradata FastExport Connections
Teradata FastLoad Connections
Teradata MultiLoad Connections
Teradata Parallel Transporter Connections
Pass Phrases
Pass Phrase Overview
Pass Phrase Permissions
Pass Phrase Management
Creating a Pass Phrase
Editing a Pass Phrase
Edit Pass Phrase Permissions
Deleting a Pass Phrase
Global Parameters
Global Parameters Overview
Global Parameter Management
Creating a Global Parameter
Editing a Global Parameter
Deleting a Global Parameter
Exporting Global Parameters
Importing a Global Parameter File
Dictionaries
Dictionaries Overview
Relational Dictionaries
Adding a Relational Dictionary
Flat File Dictionaries
Flat File Dictionary Properties
Adding a Flat File Dictionary
Dictionary Management
User-Defined Datatypes
User-Defined Datatypes Overview
Properties File
Datatype Conversion Parameters
Setting Up the Properties File for User-Defined Datatypes
Creating Functions for User-Defined Datatypes in Oracle Applications
Administrator Guide
Administrator Guide
10.4.1
10.5.2
10.5.1
10.5
10.4.0
10.2.2
10.2.1
10.2.0 HotFix 2
10.2.0 HotFix 1
10.2.0
10.2 R1
Back
Next
Creating a Global Parameter
Creating a Global Parameter
Create global parameters to create parameters that you can use across projects in Test Data Manager.
Click
Parameters
to open the
Parameters
view.
Click the
Create Global Parameter
button to open the
New Parameter
window.
Enter a name and optional description.
Select the parameter type from the list.
You can create criteria, connection, and owner parameters.
The parameter name is generated in the required convention based on the name you enter.
The naming convention depends on the parameter type.
Criteria parameters begin with '$$'.
Connection parameters begin with '$DBConnection'.
Owner parameters begin with '$Param'.
Select the data type.
You can create a parameter with String, Numeric, or Date data types.
If you choose the Date data type, enter an expression to define how a function uses the parameter.
For example,
TO_DATE($$CRIT1,'MM-DD-YYYY')
where $$CRIT1 is the parameter name.
Enter a default value. Required if you do not choose to allow override.
Choose to allow override of the default value.
You cannot change the parameter value when you run the workflow if you do not allow override.
Click
Finish
to create the parameter.
Global Parameter Management
Updated June 26, 2020
Download Guide
Send Feedback
Resources
Communities
Knowledge Base
Success Portal
Back to Top
Back
Next