Skip to main content

Teradata - Masking Connection

Following are the options specific to Teradata:

  • Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.

  • Hostname: Enter the Hostname of the Teradata server or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS/Tasks.

  • IP Address: Enter the IP Address for the connection.

  • Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required.

  • Database Name: Enter the name of the database.

  • Username: Enter the database username.

  • Password: Enter the database password.

  • Use Connection String: A Connection String specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to secure the connection using connection string.

  • Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags to the created connection.

  • Query Band Details: A Query Band is a set of name:value pairs that can be set on a session. Each name:value pair is separated by a semicolon and the expression ends with a semicolon.

    For example, Org=PK Protect; username=ABC; host=xxx; etc. The user can keep a track of the tasks executed against a Teradata connection. Once the connection is created, the Query Band will be executed and the DDL details will be logged on Teradata database i.e., dbc.qrylogV for the current session.

    *Note: The maximum length of the entire query band string is limited to 2048 characters.

    Enter the Query Band in the Query Band textbox. Click Add.

    The Query Band entered will be displayed in the box just below the Query Band textbox. You can edit and delete the Query Band.

  • Target Databases Details: It allows you to add a database as the target database, to store the masked data. To add a database as Target Database, enter name of the database in the Target Database textbox. Click the Add button. The database will be added in the Target Database panel. Click pen icon to edit the name of the database. Click trash icon to delete the database.

*Note: More than one database can be added as the target database.

To proceed further for remaining steps, refer Step 3 in RDBMS Masking Connection.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.