Privileges Required to Use Informatica Connector

To use Informatica, you need one of the following:

  • scheduler-administrator or redwood-administrator role.
  • scheduler-user or redwood-login role in combination with the following system-wide, Partition-wide or object-level privileges.

Built-in Roles

  • The scheduler-administrator or redwood-administrator built-in role provides full control over Informatica objects.
  • The scheduler-viewer built-in role provides read-only access to Informatica objects.

Creating, Modifying, and Deleting Informatica Connections

You need all of the following privilege ranks to be able to create, modify, and delete Informatica objects:

  • View or any other rank - on the Redwood_InformaticaCloud Application.
  • View or any other rank - on the Redwood_InformaticaCloudConstraint constraint.
  • View or any other rank - on the Redwood_InformaticaCloudConnection extension point.
  • View or any other rank - on the Redwood_Connections extension point.
  • View or any other rank - on the existing Process Server and Queue for the connection, if applicable.
  • Create - on Process Server and Queue, if these need to be created.
  • Edit - on ICSConnection if you want to be able to manage all Informatica Cloud connections.

Using Informatica

  • View or any other rank - on the Redwood_InformaticaCloud Application.
  • View or any other rank - on the Redwood_InformaticaCloudConstraint constraint.
  • View or any other rank - on the Redwood_Informatica extension point.
  • View - on ICSConnection, EXTConnection, EXTObjectRefs, and EXTCertificate.
  • View - on the component's Process Server.
  • JobAdministrator - on the component's Queue.
  • View - on REDWOOD.Redwood_InformaticaCloud library.
  • Submit - on Process Definitions you wish to use.

See Also