How to make it possible for campaign operators to use data via FDA for AWS PostGreSql External Account? | Community
Skip to main content
Level 2
January 29, 2025
Solved

How to make it possible for campaign operators to use data via FDA for AWS PostGreSql External Account?

  • January 29, 2025
  • 2 replies
  • 522 views

I'm trying to exclude records selected from an AWS PostGreSql database from a campaign target in Adobe Campaign Classic.

The workflow selects recipients in AC and selects recipients in AWS then exclude recipients from AWS from recipients in AC. Two parallel Query activities and then an Exclusion activity based on the two queries. 

 

If I have admin access this works.

But for normal campaign operators the exclusion activity in the workflow fails.

 

The Error in the workflow log: 

exclusion You do not have access to data in the data source 'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com:58143:ssl'.

I've created a named right for the data source and assigned it to a non-admin for test.

I've tried naming the named right several things without getting it to work:

'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com:58143:ssl'

'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com:58143'

'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com'

'adobe:transactions@example-eun1-qa-transactions-db' (DB identifier)

 

How do I make this work?

/Peter

 

Best answer by Manoj_Kumar

Hello @plundmark 

What I would do is create a folder and add this external account to that folder and give all permissions (read/write) to the operator group.

 

Another way is not ideal but you can add this data to a list and then non-admin users can use that list to create campaigns/workflows.

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
March 5, 2025

Hello @plundmark 

What I would do is create a folder and add this external account to that folder and give all permissions (read/write) to the operator group.

 

Another way is not ideal but you can add this data to a list and then non-admin users can use that list to create campaigns/workflows.

Manoj  | https://themartech.pro
Sukrity_Wadhwa
Community Manager
Community Manager
March 30, 2025

Hi @plundmark,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know. In case the given solution was helpful, then kindly choose it as the 'Correct Reply'.

Thanks!

Sukrity Wadhwa