Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Access Control
  9. Logs
  10. High Availability
  11. Server Control
  12. Performance Tuning
  13. Troubleshooting

Administrator Guide

Administrator Guide

Netezza Connection Management

Netezza Connection Management

You can use a Microsoft SQL Server connection to access a Netezza database. However, when you create a new database node for Netezza, Informatica recommends that you use the Generic Database node.
To use a Microsoft SQL Server connection to access Netezza, you must configure a server link between a Microsoft SQL Server database and the Netezza database. The client tool or application that you use to access the database must support Microsoft SQL Server.
When you send a request to the Microsoft SQL Server database, the request passes through the Dynamic Data Masking Server, which alters the request. The Dynamic Data Masking Server applies masking and auditing rules and uses OpenQuery to direct the request through the Microsoft SQL Server database to the Netezza database. The Netezza database returns masked data through the Microsoft SQL Server database to the Dynamic Data Masking Server.
To connect to a Netezza database, create a Microsoft SQL Server connection node in the Management Console.

0 COMMENTS

We’d like to hear from you!