Write access on Hadoop/Hive

Avatar

Avatar

WesleyXP

Avatar

WesleyXP

WesleyXP

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!

Hadoop Hive RDBMS

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

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)