Connect from PowerCenter to SQL Server with Kerberos Authentication

Kerberos is a network authentication protocol which uses tickets to authenticate access to services and nodes on a network. Kerberos can be used to proporcionar autenticación mutua entre la máquina que ejecuta el servicio de integración de PowerCenter y la databaseA database is an organized set of information that allows you to store, Manage and retrieve data efficiently. Used in various applications, from enterprise systems to online platforms, Databases can be relational or non-relational. Proper design is critical to optimizing performance and ensuring information integrity, thus facilitating informed decision-making in different contexts.... con el servidor SQL.

Photo credits: jntvisual

You can use Kerberos authentication when connecting to relational databases, with a Servidor SQL like Microsoft SQL Server. And you can configure Kerberos authentication for a connection to Microsoft SQL Server on the machine where you install the PowerCenter Integration Service. Compared to a username and password authentication, Kerberos authentication is more secure because passwords are not stored locally or sent over the network..

What to Pay Attention Before Configuring Kerberos Authentication

Before you proceed to configure the computer running the PowerCenter Integration Service to Kerberos authentication in the Microsoft SQL Server database, it is necessary to perform a series of actions.

Among the tasks to be completed are the following five:

1. Network verification. It is essential to ensure that the computer running the PowerCenter Integration Service and the database on the Servidor SQL Microsoft is on the same Kerberos network.
2. Verification of operation. Make sure the database of the Servidor SQL works with Kerberos authentication. For this it is feasible to resort to the database administrator.
3. User validity. For this case, the system administrator can help verify that the Microsoft SQL Server database user is valid in the Microsoft Active Directory domain.
4. Server installation. Native SQL Server can be installed on the computer running the PowerCenter Integration Service.
5. Installing the client libraries. Finally, you can switch to installing the Kerberos client libraries on the same machine where the PowerCenter Integration Service is running.

How to configure Kerberos authentication to connect to an SQL server step-by-step

To configure Kerberos authentication for a connection to a SQL server such as Microsoft SQL Server, the following tasks must be performed:

1. Update the system configuration files. To do this, the first step is to work with your system administrator to get the krb5.conf file, what is the Kerberos configuration file.
2. Verify and test the connection to the Microsoft SQL server from the computer where the PowerCenter integration is located.. The service runs in the Microsoft SQL Server database.
3. Restart the Informatica services with the Kerberos user. In this point, you must verify that this action is carried out with the same Kerberos user, What is it a valid user in the Microsoft SQL server Kerberos database.
4. Create Microsoft SQL Server connection in PowerCenter with Kerberos authentication and run mapping. No olvide que puede configurar la Data SourceA "Data Source" refers to any place or medium where information can be obtained. These sources can be both primary and, such as surveys and experiments, as secondary, as databases, academic articles or statistical reports. The right choice of a data source is crucial to ensure the validity and reliability of information in research and analysis.... de Microsoft SQL Server de diferentes formas dependiendo de si el servicio de integración de PowerCenter se ejecuta en Windows o UNIX.