ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Getting Error while masking Teradata tables through FDM
Article ID: 186505
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction
We are trying to mask few Teradata Tables using FastDataMasker but its throwing error:
([Teradata Database] [TeraJDBC xx.xx.xx.xx] [Error 3510] [SQLState 25000] Too many END TRANSACTION statements. ) .
Can you please look at the issue ?
Environment
Release : 4.8
Component : CA Test Data Manager
Resolution
According to the TDM Documentation, under the Installation - Supported Data Sources, there is a matrix showing what functionality is and isn't supported for the supported data sources. Looking at the Teradata matrix we see Data Masking through FDM is not supported for Teradata databases.
| Databases | Dynamic Test Data Reservation | Data Generation | Data Masking | Data Subsettig | Test Match | Virtual Test Data Management | Data Modeling and PII Audit | Distributed with Driver | Notes | |||
| TDM Portal | TDM Portal | Datamaker | TDM Portal | Fast Data Masker | Datamaker | GT SubSet | ||||||
| Teradata 15.10 | Not Supported | Certified | Certified | Not Supported | Not Supported | Certified See Notes |
Certified | Not Supported | Not Supported | Not Supported | No | If you create a Teradata connection profile in CA TDM Portal, and you publish from Datamaker using this connection profile (the Enterprise or Remote Enterprise publish option), then only the Teradata ODBC driver is supported. Download the files terajdbc4.jar and tdgssconfig.jar from the vendor and place it in the following folder: C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\ When using the JDBC driver to create a connection profile in the CA TDM Portal, grant the Teradata user the following additional permissions: GRANT Select ON "UDTInfo" TO "<username>"; |
| Teradata 16.10 | Not Supported | Supported | Certified | Not Supported | Not Supported | Certified See Notes |
Certified | Not Supported | Not Supported | Not Supported | No | |
| Teradata 16.20 | Not Supported | Supported | Supported | Not Supported | Not Supported | Certified See Notes |
Supported | Not Supported | Not Supported | Not Supported | No | |
Additional Information
Feedback
Yes
No
Powered by
