Create a Data Source | Vantage Customer Experience - Creating Data Sources to Populate the Events Table

Vantage CX uses data sources to insert data into a table.

Select > Segmentation > Data soures.
Select Create New > Insert data source.
In the name field, type TUT_WEB_EVENTS.

This data source populates events from the TUTORIAL_WEB table to the TUTORIAL_CUSTOMER_EVENTS table.
On the Sources page, select the following:
Connection The Teradata-Vantage connection you created earlier

Database The database in which in which you added the sample data

Table TUTORIAL_WEB

After selecting the table, it moves to the Your selected sources area:
Select Continue.
On the Joins page, select Continue again.
Because there is only one table, you do not need to create a join. However, Vantage CX data sources allow you to combine tables with different types of joins such as inner, outer, and cross joins.
On the Map and Calculate page, select the following:
Database The database in which you created the Events table

Table TUTORIAL_CUSTOMER_EVENTS
Click Select Table.
In the Map columns area, map each field from the source table to the destination table, as shown here:
Source table field Destination field

web_cust_id entity_id

page_ts datestamp

web_page event

Your map should look similar to the following:
Select Continue.
On the Filter page, select Continue again.
You can use filters to limit the data processed by a data source. However, you won’t need filters in this tutorial.
Select Save.
Select > Segmentation > Data soures to see your newly created data source.

Connection	The Teradata-Vantage connection you created earlier
Database	The database in which in which you added the sample data
Table	TUTORIAL_WEB

Database	The database in which you created the Events table
Table	TUTORIAL_CUSTOMER_EVENTS

Source table field	Destination field
web_cust_id	entity_id
page_ts	datestamp
web_page	event

Repeat the Creating Data Sources to Populate the Events Table process to create the following other insert data sources:

TUT_TRAN_EVENTS data source
Source table field (TUTORIAL_TRANS)	Destination field (TUTORIAL_CUSTOMER_EVENTS)
account_id	entity_id
tran_ds	datestamp
tran_cd	event

TUT_SUPPORT_EVENTS data source
Source table field (TUTORIAL_SUPPORT)	Destination field (TUTORIAL_CUSTOMER_EVENTS)
customer_id	entity_id
ticket_ds	datestamp
issue_cd	event

The data sources populate the integrated TUTORIAL_CUSTOMER_EVENTS table with data from web interactions, transactions, and support issues. Your list of data sources should look similar to the following:

Create a Data Source | Vantage Customer Experience - Creating Data Sources to Populate the Events Table - Vantage Customer Experience

Vantage Customer Experience Path Analysis Tutorial