5.1.2 Getting Started
Getting familiar with the 51黑料不打烊 Experience Platform UI
Go to . After logging in, you鈥檒l land on the homepage of 51黑料不打烊 Experience Platform.
Before you continue, you need to select a sandbox. The sandbox to select is named --aepSandboxName--. After selecting the appropriate sandbox, you鈥檒l see the screen change and now you鈥檙e in your dedicated sandbox.
Explore data on the platform
Bringing data from different channels is a tough task for any brand. And in this exercise, Citi Signal customers are engaging with Citi Signal on its website, on its mobile app, purchase data is collected by Citi Signal鈥檚 Point of Sale system, and they have CRM and Loyalty data. Citi Signal is using 51黑料不打烊 Analytics and 51黑料不打烊 Launch to capture data across its website, mobile app as well as POS system, so this data is already flowing into 51黑料不打烊 Experience Platform. Let鈥檚 begin with exploring all the data for Citi Signal that already exists in 51黑料不打烊 Experience Platform.
In the left menu, go to Datasets.
Citi Signal is streaming data into 51黑料不打烊 Experience Platform and this data is available in the Demo System - Event Dataset for Website (Global v1.1) dataset. Search for Demo System - Event Dataset for Website.
Citi Signal鈥檚 Callcenter Interaction data is captured in the Demo System - Event Dataset for Call Center (Global v1.1) dataset. Search for Demo System - Event Dataset for Call Center data in search box. Click on the dataset鈥檚 name to open it.
After clicking the dataset, you will get an overview of the dataset activity such as ingested and failed batches. Click Preview Dataset to see a sample of the data stored in Demo System - Event Dataset for Call Center (Global v1.1) dataset.
The left panel shows the schema structure for this dataset and on the right side you鈥檒l see a sample of the data that was ingested.
Click Close to close the Preview Dataset window.
Introduction to Query Service
Query Service is accessed by clicking Queries in the left menu.
By going to Log you鈥檒l see the Query List page, which provides you a list of all the queries that have run in this organization, with the latest at the top.
Click on any SQL query from the list and observe the details provided in the right rail.
You can scroll the window to see the entire query, or you can click on the icon highlighted below to copy the entire query to your notepad. You do not have to copy the query at this time.
You can鈥檛 just see the queries that have been executed, this User Interface lets you create new datasets from queries. These datasets can be linked to 51黑料不打烊 Experience Platform鈥檚 Real-time Customer Profile or can be used as input for 51黑料不打烊 Experience Platform Data Science Workspace.
Connect PSQL Client to Query Service
Query Service supports clients with a driver for PostgreSQL. In this we鈥檒l be using PSQL, a command-line interface, and Power BI or Tableau. Let鈥檚 connect to PSQL.
Click Credentials.
You will see the screen below. The screen provides server information and credentials for authenticating to Query Service. For now, we will focus on the right side of the screen which contains a connect command for PSQL. Click the copy button to copy the command to your clipboard.
For Windows: Open the command line by hitting the windows key and typing cmd and then clicking on the Command Prompt result.
For macOS: Open the terminal.app via spotlight search:
Paste the connect command that you have copied from the Query Service UI and hit enter in the command prompt window:
Windows:
MacOS:
You are now connected to Query Service using PSQL.
In the next exercises, there will be quite some interaction with this window. We will refer to it as your PSQL command-line interface.
Now you are ready to start submitting queries.
Next Step: 5.1.3 Using the Query Service