Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing Identity Resolution
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading Identity Resolution
  7. Uninstalling Identity Resolution

Installation and Configuration Guide

Installation and Configuration Guide

Step 4. Create Microsoft SQL Server API Components

Step 4. Create Microsoft SQL Server API Components

Optionally, you can create Microsoft SQL Server API components on each target database. For more information about Microsoft SQL Server API components, see the
Informatica Identity Resolution Developer Guide
.
  1. Copy the
    <Identity Resolution Installation Directory>\mssql\ssasexp.dll
    file to the
    <Microsoft SQL Server Installation Directory>\Binn
    directory.
  2. Copy the following files from the
    <Identity Resolution Installation Directory>\bin
    directory to the
    <Microsoft SQL Server Installation Directory>\Binn
    directory:
    • ssaiok.dll
    • ssasec.dll
  3. Run the following command to run the
    <Identity Resolution Installation Directory>\mssql\ssasexp.sql
    script:
    sqlcmd -U <User Name> -P <Password> -S <Server Name> -i ssasexp.sql
    Configure the following parameters:
    User Name
    Name of the user that can create tables and database objects.
    Password
    Password for the user.
    Server Name
    Name of the Microsoft SQL Server. For example, localhost.