Write access on Hadoop/Hive

[#1]

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!

[WesleyXP · Accepted solution]

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

[WesleyXP · Accepted solution]

Dear Jon,

Thanks for your reply. The matrix is really helpful! We found another one, but this one is way more clear.

We already have the Hadoop connection in place and it's all working. We are rather exploring ways to improve the use of it, for which our technical guys need more insights. However, nobody seem to know the answers.

Related to question

- How can we achieve access to Hive/Hadoop through enrichments/split activities?

  We now know that you can access the data by adding data (cf. add data) and choosing "external data", however option has severe limitations. We are looking further, maybe some has more information ... .