Salesforce Docs Portal

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
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
Note Make sure you have at least one data stream defined in Data 360 before connecting the two apps.
  1. On the Connect & Mix tab, select Data Streams, and then select Data Streams List.
  2. Click Create New.
  3. In the Technical Vendor section, select Salesforce Data Cloud.
  4. Enter your Data 360 username and password. You may also be prompted for a token, based on the security settings of your organization.
  5. 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.

  6. To view a summary of your query result, click Evaluate.
  7. To confirm your credentials and verify your data, click Validate. 
  8. Click Next and preview your data. If you’re satisfied with the preview, click Next. 
  9. 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.

You can now analyze your Data 360 data.

See Also