Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Analyst
  3. Library Workspace
  4. Connections Workspace
  5. Job Status Workspace
  6. Projects Workspace
  7. Model Repository
  8. Data Objects
  9. Search
  10. Appendix A: Configure the Web Browser

Analyst Tool Guide

Analyst Tool Guide

Creating a Database Connection

Creating a Database Connection

You can create a database connection in the Analyst tool. Choose a simple connection to include basic database properties. Choose an advanced connection to include additional database specific properties.
  1. Click
    New
    to open the
    New Connection
    dialog box.
  2. Enter the following information:
    Option
    Description
    Name
    Name of the connection. The name is not case sensitive and must be unique within the domain. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
    ~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
    ID
    String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
    Description
    Optional description for the connection.
  3. Select a database type.
    Additional fields appear based on the database type you select.
  4. Choose a simple connection or an advanced connection.
    • To choose a simple connection, select
      Simple Connection
      and specify the connection properties.
    • To choose an advanced connection, select
      Advanced Connection
      and specify additional database connection properties.
  5. Click
    OK
    .
    The Analyst tool tests the connection and displays the test status.

0 COMMENTS

We’d like to hear from you!