Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing MDM Registry Edition
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading MDM Registry Edition
  7. Uninstalling MDM Registry Edition

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 MDM Registry Edition Developer Guide
.
  1. Copy the
    <MDM Registry Edition Installation Directory>\mssql\ssasexp.dll
    file to the
    <Microsoft SQL Server Installation Directory>\Binn
    directory.
  2. Copy the following files from the
    <MDM Registry Edition 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
    <MDM Registry Edition 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.