Use TotalConnect to Pull Data 360 Data into Intelligence
If you have Data 360 data and you want to bring it into Marketing
Cloud Intelligence, you can use the TotalConnect connector. With this connector you can fetch up
to 50,000 rows per query and run up to 1,000 queries per day. After you connect your data, a
data stream is created and you can then get insights on your data.
Required Editions
User Permissions Needed
To create a TotalConnect data stream:
Admin
Note You must first set up access from Data 360 to Marketing Cloud
Intelligence before you can connect your data. For more information, see Set Up Access to Pull Data 360 Data
Note Make sure you have at least one data stream defined in Data 360
before connecting the two apps.
On the Connect & Mix tab, select Data Streams, and then select
Data Streams List.
Click Create New.
In the Technical Vendor section, select Salesforce Data Cloud.
Enter your Data 360 username and password. You may also be prompted for a token, based on the
security settings of your organization.
Write your SQL query.
For example, select * from ssot__Individual__dlm limit
2 queries two rows of all the columns in your data model object. Limiting the query
to two rows gives quick results.
To view a summary of your query result, click Evaluate.
To confirm your credentials and verify your data, click
Validate.
Click Next and preview your data. If you’re satisfied with the
preview, click Next.
To create the data stream, click Create.
If you have mapping errors, a validation screen appears. To fix the errors, click
Show Issues. You can also click Advanced. After
you’ve resolved the mapping issues, click Create again.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
