Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to Hive Connector
  3. Hive connections
  4. Mappings and mapping tasks with Hive Connector
  5. Migrating a mapping
  6. Data type reference
  7. Troubleshooting

Hive Connector

Hive Connector

Configure IAM authentication for a Hive connection to run mappings in advanced mode

Configure IAM authentication for a Hive connection to run mappings in advanced mode

Before you connect to Hive using IAM authentication from a mapping in advanced mode, you must have the following IAM roles to manage an
advanced cluster
:
  • kops role
  • Secure Agent role
  • master role
  • worker role
Kops role is the default. Master and worker roles are not mandatory if you want to work only with the Kops role.
For more information about these roles, see the
Advanced Cluster
help.
To use IAM authentication for a Hive Connector to run mappings in advanced mode, perform the following tasks for the
advanced cluster
:
  1. Create IAM roles. For more information, see the topic "Create IAM roles" in the see the Advanced Cluster help.
  2. After you create the IAM role, you must assign the following policy to the IAM role:
    { "Version": "2012-10-17", "Statement": [ { "John": "VisualEditor2", "Effect": "Allow", "Action": [ "s3:GetBucketLocation", "s3:GetEncryptionConfiguration", "s3:ListBucket", "s3:PutObject", "s3:GetObjectAcl", "s3:GetObject", "s3:PutObjectAcl", "s3:DeleteObject", "s3:Delete*", "s3:Put*", "s3:ListBucketMultipartUploads", "s3:AbortMultipartUpload" ], "Resource": [ "arn:aws:s3:::<hive-staging-bucket-name>/*", "arn:aws:s3:::<hive-staging-bucket-name>" ] } ] }
  3. Log in to
    Informatica Intelligent Cloud Services
    and from Administrator, navigate to the
    System Configuration Details
    , select
    Elastic Server
    as the service, add the ARN of the kops role created:

0 COMMENTS

We’d like to hear from you!