We have a custom object in Sales/Service cloud and I have synchronized those objects in Marketing cloud using Marketing cloud connect.

Now, We want to start a journey when we create a new record in our custom record.

We have created Data Extension with exact same fields as out synchronized custom object because we cant use Synchronized data extension directly into journey builder.

I want to SQL activity to load data from Synchronized data extension to data extension but I am not sure how and where to write this.

Please let me know.



Navigate to Automation Studio > Activities and create a new SQL Query.

  1. Navigate to Automation Studio > Activities and click Create Activity.
  2. Select SQL Query
  3. Give your query a name
  4. Now write your SQL query
  5. Select your target data extension
  6. Specify your data handling (Add, Update, Overwrite)
  7. Run your query (you'll likely want to create an actual automation with a schedule) as running the query will only occur once

Your query will look something like this:

    SELECT *
    FROM ENT.[your_sychronized_DE]

You may need more to this query depending on what WHERE statements you need for new records. Please update/post a new question when you get there.

  • Thank you for the reply. I have tried the same steps but I was using my custom object name rather than Synchronized data source name and I found my mistake. I have changed the DE name and it worked fine. Mar 16 '18 at 14:02
  • Great. If that answers your question-mark it as answered! Mar 16 '18 at 14:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.