Write access on Hadoop/Hive

Avatar

Avatar
Validate 1
Level 1
WesleyXP
Level 1

Likes

0 likes

Total Posts

15 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
WesleyXP
Level 1

Likes

0 likes

Total Posts

15 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile
WesleyXP
Level 1

21-04-2020

Dear,

 

We are currently investigation how we can setup write rights to Hive/Hadoop to store temporary results on Hive/Hadoop instead of in the SQL DB of AC.

We also read it might be possible to use Hive/Hadoop tables in the enrichment / split activity, and not only in the RDBMS activity.

 

We however have some questions related to this, maybe the community can help us:

- Is it possible to store the result of an RDBMS activity on Hive instead of the SQL DB of Adobe Campaign?
- What rights does AC need to be able to write tables on Hive/Hadoop?
- How can we configure AC to be able to do this?
- How can we achieve access to Hive/Hadoop through enrichments/split activities?
- Is there any risk that giving those rights will also grant rights on other tables?

 

Any input can help!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

21-04-2020

Hi,

 

FDA connector should have what you're looking for.

 

Installation guide here:

https://docs.adobe.com/content/help/en/campaign-classic/using/getting-started/connectors/accessing-a...

 

The access rights matrix hasn't been updated for Hive but should follow a similar pattern:

https://docs.adobe.com/content/help/en/campaign-classic/using/assets/fda_rdbms_rights.pdf

 

Thanks,

-Jon

Answers (0)