Write access on Hadoop/Hive

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)

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)