DDM Database Name
Name for the database in the Management Console tree.
Driver Class Name
Fully qualified class name of the target database driver.
For example, you might enter the following text:
org.netezza.Driver
Connect String (URL)
JDBC connection string used to connect to the database.
For example, you might enter the following text:
jdbc:netezza://hostname:port/database_name
Optional Parameters
Optional parameters for the Informatica driver for the database.
DSN Name
Logical data source name used to connect to the database.
DBA Username
Username for the database user account to log in to the database. The database user must be a privileged user that has SELECT access to all the tables that the client user has SELECT access to.
DBA Password
Password for the database user.
Unary Table
Name of the unary table for the database.
Bind Argument Representation
Representation of the bind argument for a PL/SQL stored function.
Supports ANSI Join
Select if the database supports ANSI join syntax.
Are Function Calls Allowed in Select
Select if the database allows a function call to be included in a SELECT statement.
Are Parentheses Allowed for Function Call with No Arguments
Select if the database allows parentheses in a function call that does not have any arguments.
Command to Get Data for Impersonation
The SQL command that Dynamic Data Masking uses to retrieve the data required for impersonation.
For example, you might enter the following command to retrieve the search_path for a Greenplum database:
SELECT COALESCE(substring( useconfig[1] from '%=#"%#"' for '#' ), substring( datconfig[1] from '%=#"%#"' for '#'), 'PUBLIC') as AUTH_CURRENT_SCHEMA from pg_user pguser, pg_database pgdatabase where pguser.usename= '\(AUTH_USERNAME)' and pgdatabase.datname= '\(AUTH_CATALOG)'
Execute Command to get Impersonation Data for Every Request
Select to indicate that Dynamic Data Masking must retrieve the data for impersonation for each request. If the checkbox is unchecked, Dynamic Data Masking retrieves the data once per session.
Impersonation Commands
Impersonation commands for the database, separated by a semicolon (;) and a line break. Words that are preceded by a backslash and left parenthesis and followed by a right parenthesis are Dynamic Data Masking symbols that Dynamic Data Masking replaces with symbol values. For example, \(SYMBOL).
For a Greenplum database, you must set the AUTH_CURRENT_SCHEMA symbol. You can use the following command to set the symbol:
SET SEARCH_PATH = \(AUTH_CURRENT_SCHEMA)
Cleanup Commands
Cleanup commands for the database, separated by a semicolon (;) and a line break.
Sanity Check Script
Sanity check script to verify that the Dynamic Data Masking connection to the database is valid.