Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Integration Hub
  • All Products

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

Back Next

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