Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

Creating a Connection

Creating a Connection

Create a connection to access a compute cluster, database, enterprise application, file system, nonrelational database, NoSQL database, social media application, or web service. Create the connection before you import physical data objects, preview data, profile data, or run mappings.
  1. Click
    Window
    Preferences
    .
  2. Select the type of connection that you want to create:
    • To select a non-web services connection, select
      Informatica
      Connections
      .
    • To select a web services connection, select
      Informatica
      Web Services
      Connections
      .
  3. Expand the domain in the
    Available Connections
    list.
  4. Select a connection type in the
    Available Connections
    list, and click
    Add
    .
    The
    New <Connection Type> Connection
    dialog box appears.
  5. Enter the following information:
    Property
    Description
    Name
    Name of the connection. The name is not case sensitive and must be unique within the domain. It 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.
    Location
    Domain in which the connection exists.
    Type
    Specific connection type, such as Oracle, Twitter, or Web Services.
  6. Click
    Next
    .
  7. Configure the connection properties.
  8. Click
    Test Connection
    to verify that you entered the connection properties correctly and that you can connect to the database, application, file system, or URI.
    Test Connection
    is not supported with Databricks.
  9. Click
    Finish
    .
After you create a connection, you can add it to the
Connection Explorer
view.

0 COMMENTS

We’d like to hear from you!