Create connections in the Experience Platform UI

Experience Platform Federated Audience Composition lets you build and enrich audiences from the third-party data warehouses and import the audiences to Adobe Experience Platform.

Supported databases supported-databases

To work with your federated database and Adobe Experience Platform, you must first establish a connection between the two sources. With Federated Audience Composition, you can connect to the following databases.

Create connection create

To create a connection, select Sources within the Connections section.

The Sources catalog appears. Select Federated data to view the list of available federated databases for your organization.

Once you’ve selected the federated database type, select Set up if you’re making a new connection or Add data if you’re using an existing connection.

The connect account page appears. You can either use an existing account or create a new account.

Existing account existing-account

If you select Existing account, you can choose one of the previously created source connections.

New account new-account

If you select New account, the connection details page is displayed. On this page, you can set details about your connection, including account name, description, and account authentication details. The account authentication section differs based on the database type previously chosen.

After adding the connection’s details, please note the following additional settings:

You can now select Connect to source to set up the schema details for the database connection.

Schema selection schema-selection

The Schema selection page appears. On this page, you can define the schema for your federated database connection.

For more information on setting up schema details, read the schemas guide.

After choosing your schemas, select Next to continue.

Review review

The Review page appears. On this page, you can review the details of your federated database connection. If the details look correct, select Finish to create the connection.

The connection is created. A popup appears, asking you to either View schema or Create relationships. If you select View schema, the schema browse page appears. If you select Create relationships, the entity diagram page appears.

Edit connection edit-connection

If you need to edit the login details for the source connection, select Sources followed by Accounts.

The source connectors browse page appears. Find the source connector you want to update, select , followed by Edit details.

The Edit account details popover appears. On this popover, you can update details of the federated database source connection.

Appendix appendix

The following appendix describes how to set up the connections on the external account’s side.

Google BigQuery (Workload Identity Federation) configuration wif-configuration

Before you configure your Google Cloud Platform setup, you will need the following values:

In Google Cloud Console, create a Workload Identity Pool in the IAM & Admin section. This lets you organize and manage external identities.

Select Add provider to create an identity provider. This configures a one-way trust between the identity provider in Google Cloud and the Worker Identity Pool by providing the relevant metadata about the provider.

When you create a provider, you’ll need to provide the following information:

After creating the provider, you need to create an IAM policy to let the Workload Identity Pool identities impersonate the Service Account. Select Grant access to open the Grant access to service account dialog.

In the dialog, select Grant access using service account impersonation. Within the Select principals section, you’ll need to create your attribute mappings.

Select aws_role and add arn:aws:sts::AWSAccountID:assumed-role/AWSRoleName as the value, substituting AWSAccountID and AWSRoleName with the previously provided values.

After granting access to the service account, download the client library configuration.

After downloading the client library configuration, you can now set up a WIF connection with Federated Audience Configuration.

Google BigQuery Apigee Gateway Support apigee

You can use Apigee, Google Cloud’s native API management platform, to proxy your API calls to Google BigQuery.

You’ll first need to create a proxy within the Apigee UI. In Google Cloud, go to Apigee followed by Proxy development, API proxies, and Create to bring up the Create a proxy panel. On the panel, you can fill in the following details:

For Federated Audience Composition, create a proxy endpoint rule for each endpoint that the Google BigQuery connector uses, as listed below:

Once you’ve created your proxy, you’re good to use it to connect with Federated Audience Composition. Once you deploy the proxy, you can find the full URL for your proxy listed under Hostnames when you select Environments followed by Groups within the Admin section.