ÃÛ¶¹ÊÓƵ

1.3.2 Create schemas, data model and links

You can now configure your federated database in ÃÛ¶¹ÊÓƵ Experience Platform.

Log in to ÃÛ¶¹ÊÓƵ Experience Platform by going to this URL: .

After logging in, you’ll land on the homepage of ÃÛ¶¹ÊÓƵ Experience Platform.

Before you continue, you need to select a sandbox. The sandbox to select is named --aepSandboxName--. After selecting the appropriate sandbox, you’ll see the screen change and now you’re in your dedicated sandbox.

1.3.2.1 Set up a Federated database in AEP

Click Federated databases in the left menu. Then, click Add federated database.

As a Label, use --aepUserLdap-- - CitiSignal Snowflake and for the type, choose Snowflake.

Under details, you need to fill out your credentials, which will look like this:

Server:

In Snowflake, go to Admin > Accounts. Click the 3 … next to your account and click Manage URLs.

You’ll then see this. Copy the Current URL and paste it in the Server field in AEP.

User: the user name you created earlier, in exercise 1.3.1.1
Password: the password you created earlier, in exercise 1.3.1.1
Database: use CITISIGNAL

So finally, you should have this. Click Test Connection. If the test is successful, click Deploy Functions, which will create functions on the Snowflake side which are necessary for the workflow engine.

Once the connection was successfully tested and functions are deployed, your configuration will be stored.

When you then go back to the Federated databases menu, you’ll see your connection there.

1.3.2.2 Create schemas in AEP

In the left menu, click Models and then go to Schemas. Click Create schema.

Select your federated database and click + Add tables.

You’ll then see this. Select the 5 tables you created in Snowflake before:

Click Add.

AEP will then load the information of each table and show it in the UI.

For each table, you can:

For this exercise, no changes are needed.

Click Create.

You’ll then see this. You can click any schema and review the information. As an example, click –a±ð±è±«²õ±ð°ù³¢»å²¹±è–_±Ê·¡¸é³§°¿±·³§.

You’ll then see this, with the ability to edit the configuration. Click Data to see a sample of the data that is in the Snowflake database.

You’ll then see a sample of the data.

1.3.2.3 Create a model in AEP

In the left menu, go to Models and then go to Data model. Click Create data model.

For the label, use --aepUserLdap-- - CitiSignal Snowflake Data Model. Click Create.

Click Add schemas.

Select your schemas and click Add.

You’ll then see this. Click Save.

PERSONS - USERS

You can now start defining links between schemas. To start defining a link, you need to click Create links.

First, let’s define the link between the tabel --aepUserLdap--_USERS and --aepUserLdap--_PERSONS.

Click Add.

HOUSEHOLDS - PERSONS

You’ll then be back here. Click Create links to create another link.

Next, let’s define the link between the tabel --aepUserLdap--_HOUSEHOLDS and --aepUserLdap--_PERSONS.

USERS - MONTHLY_DATA_USAGE

You’ll then be back here. Click Create links to create another link.

Next, let’s define the link between the tabel --aepUserLdap--_USERS and --aepUserLdap--_MONTHLY_DATA_USAGE.

USERS - HOUSEHOLDS

You’ll then be back here. Click Create links to create another link.

Next, let’s define the link between the tabel --aepUserLdap--_USERS and --aepUserLdap--_HOUSEHOLDS.

USERS - MOBILE_DATA_USAGE

You’ll then be back here. Click Create links to create another link.

Next, let’s define the link between the tabel --aepUserLdap--_USERS and --aepUserLdap--_MOBILE_DATA_USAGE.

You should then see this. Click Save.

Your setup in AEP is now done. You can now start using your federated data in a federated audience composition.

Next Step: 1.3.3 Create a federated composition

Go Back to Module 1.3

Go Back to All Modules