Table of Contents

Search

  1. Preface
  2. Introduction to Cloud Integration Hub
  3. Hub administration
  4. Project and Asset Management
  5. Applications
  6. Topics
  7. Data Integration tasks
  8. File ingestion tasks
  9. Publications
  10. Subscriptions
  11. Tracking and monitoring
  12. Cloud Integration Hub REST APIs
  13. Glossary

Cloud Integration Hub

Cloud Integration Hub

Setting up the organization in Informatica Cloud Integration Hub

Setting up the organization in Informatica Cloud Integration Hub

Set up the organization in
Cloud Integration Hub
to create and manage Cloud Integration Hub assets. You must define the settings required by the organization.
  1. Access
    Cloud Integration Hub
    and accept the license agreement.
    The
    Organization Cloud Setup
    dialog box appears.
  2. Define the following settings:
    Property
    Description
    Organization Name
    Name of the organization in
    Informatica Intelligent Cloud Services
    . Appears in view only mode.
    Organization ID
    ID of the organization in
    Informatica Intelligent Cloud Services
    . Appears in view only mode.
    Informatica Cloud User
    Name of the
    Informatica Intelligent Cloud Services
    user to use at run time. The user must have an Admin user role in
    Informatica Intelligent Cloud Services
    . The user must also have Update and Execute permissions for the Data Integration assets associated with publications and subscriptions.
    Informatica Cloud Password
    Password for the
    Informatica Intelligent Cloud Services
    user to use at run time.
    Runtime Environment
    Informatica Intelligent Cloud Services
    Secure Agent runtime environment to use at run time.
    Rotate Key
    Click
    Rotate Key
    to rotate the encryption key used for data encryption.
  3. To use a private publication repository, define the following settings:
    Property
    Description
    Repository Type
    Select
    Private
    .
    Enable Secret Vault
    Stores the publication repository password for the connection in the Secret Manager in the runtime environment that is configured for your organization.
    This property appears only if secrets manager is set up for your organization.
    Select this option to use the credentials from the Secret Manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
    For information about how to configure and use a secrets manager, see "Secrets manager configuration" in the Administrator help.
    Repository Database Type
    Choose Oracle, Microsoft SQL Server, or a MySQL database. If you use an SQL Server database, the collation is case-insensitive.
    Repository URL
    JDBC URL of the repository, based on the database type:
    • Oracle:
      jdbc:informatica:oracle://<ip>:<port>;sid=<sid>;
    • Microsoft SQL Server:
      jdbc:informatica:sqlserver://<ip>:<port>; DatabaseName=<DatabaseName>;
    • MySQL:
      jdbc:mysql://<ip>:<port>/<DatabaseName>;
      When you set up a MySQL 8.x private publication repository, you must add
      disableMariaDbDriver=true
      to the URL for
      Cloud Integration Hub
      to pick the appropriate drivers.
    • Aurora MySQL:
      jdbc:mariadb://<ip>:<port>/<DatabaseName>;
    To successfully establish a connection to the proxy service, add the following string to the repository URL:
    useSystemProxyOptions=false;
    User
    Name of the user to access the repository.
    User Role
    Role granted to the user to access the repository, based on the database type:
    • On an Oracle database, the user must be granted
      CONNECT
      and
      RESOURCE
      roles.
    • On a Microsoft SQL Server database, the user must be granted
      db_datareader
      ,
      db_datawriter
      , and
      db_ddladmin
      roles.
    Password
    Password of the user.
    Repository Schema
    Schema used with the repository. For more information, see Bypass the Publication Repository Service in a private publication repository.
    Use a separate schema as a private publication repository for each organization.
  4. Optionally, define the following file store publication repository settings:
    Property
    Description
    Enable File Store
    If you use an on-premises Secure Agent, select to enable the hub to store published files as-is in a file store publication repository.
    File Store Repository Location
    File directory path of the file store publication repository. The Informatica Cloud Secure Agent must be able to access the location.
  5. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!
Koki Watanabe - October 03, 2023

Can we use RDS for Oracle or Aurora as a repository?

Informatica Documentation Team - October 03, 2023

Hi Koki Watanabe,

Yes, you can use Oracle RDS to set up a private repository. We will update the documentation to reflect this.

From the October 2023 release onwards, Cloud Integration Hub also supports Aurora MySQL for the private and hosted repositories.

Thanks,

Informatica Documentation team

 


Informatica Documentation Team - October 11, 2023

Hi Koki Watanabe,

We’re happy to let you know that we addressed your feedback in the documentation:

https://docs.informatica.com/integration-cloud/integration-hub/current-version/cloud-integration-hub/hub-administration/set-up-a-private-publication-repository.html

Thanks,

Informatica Documentation team