Write access on Hadoop/Hive | Community
Skip to main content
W
WesleyXPL
Level 2
April 21, 2020
Solved

Write access on Hadoop/Hive

  • April 21, 2020
  • 1 reply
  • 4303 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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-an-external-database.html#configure-access-to-hadoop

 

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
April 22, 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-an-external-database.html#configure-access-to-hadoop

 

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

W
WesleyXPLAuthor
Level 2
May 6, 2020

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 ... .

Terms & ConditionsAccessibility statement

Loading footer...