This Administrator tool is a web-based client that consolidates administrative tasks, including security. Discover how to configure and manage security on SQL data services as well as Web Services, which have been created and deployed in the Developer tool. Demonstrate the ability to set permissions, privileges and restrict retrieval of virtual data within the SQL data services.
Preview
By the end of this training you will be able to:
Obtain a high-level overview of the Administrator tool
Acquire an understanding of data services as well as virtual and logical data
Review basic security setup of users and groups in Informatica domain
Configure user and group permissions on the data service
Construct a level of security that restricts rows of data from users or user groups when they query a virtual table
Return a default value to the user instead of the actual data values
Create nested predicates
Acquire the ability to deny access to individual columns in a virtual table
Procure the knowledge to connect to an SQL data service with the client user credentials instead of the credentials from a connection object
Employ native and JDBC drivers to test the security setup utilizing third-party tools such as excel and SQuirrel database editor
Course Contents
Day 1
Intro to Data Services Security
Get familiarized with Data Services Security terms and features.
Become acquainted with the Administrator tool.
Take a tour of Informatica's basic domain security setup.
The student will acquire an understanding of data services as well as virtual and logical data.
Configure Security
Configure user and group permissions on the data service.
Construct a level of security that restricts rows of data from users or user groups when they query a virtual table.
Day 2
Nested Predicates
Use nested predicates to further refine the 'where' clause on a virtual table.
Granular access to virtual data is constructed using nested predicates.
Sharpen security by adding predicates to user permissions in addition to group permissions.
Column Level Security
Acquire the ability to deny access to individual columns in a virtual table.
Return a default value to the user instead of the actual data values.
Day 3
Web Services Security
Describe Web Services Security Management.
Illustrate Web Service Architecture.
Define Message Layer Security.
Depict Transport Layer Security.
Describe Pass-Through Security.
Portray HTTP Client Filter Configuration.
Configure Transport Layer Security on the Data Integration Service and Web Service.
Day 4
Pass-Through Security
Configure the ability to connect to an external source with the client user credentials instead of the credentials from a connection object.
When the Data Integration Service retrieves virtual table data from a source, it connects to the source with the client user credentials.
Therefore, users with different credentials have different levels of access to the data in a virtual table.
This Administrator tool is a web-based client that consolidates administrative tasks, including security. Discover how to configure and manage security on SQL data services as well as Web Services, which have been created and deployed in the Developer tool. Demonstrate the ability to set permissions, privileges and restrict retrieval of virtual data within the SQL data services.
Apps2Fusion Articles 