You can send your data as track calls only while mapping your warehouse columns to the destination fields using the JSON builder. Visual Data Mapper is not supported currently.
Some key features of syncing events from Reverse ETL sources are listed below:
Ensure the reliability of your events: Sometimes, your critical events(such as purchases) may get blocked by things outside your control, such as adblockers. In such cases, if you have all your users’ activity in the database, you can send it to the downstream systems as a guaranteed source of truth.
Simulate historical tracking of events: You can replay the historical data from other data sources to your sales, support, and marketing systems to maintain business continuity.
Fix bad data and replay it: There is a possibility that your destination ends up with some bad data due to a bug in the tracking code or any other reason.
In such cases, you can clear the bad data and replay a clean version by syncing the events.
Test your transformations and integrations: You can use a sample dataset to test an event stream for a new version of your transformation or a new integration using the track call.
Use cases for sending track events
Some examples where you can use the track call to send events from your warehouse into the downstream destinations are listed below:
Sending event data to engagement platforms such as Braze, Iterable, Customer.io, or Salesforce Marketing Cloud to trigger behavior or populate user actions.
Sending event data to the downstream systems that are configured to handle track calls, like Apache Kafka or Amazon Kinesis.
Replaying the fact table that might be the source of truth for user behavior to the downstream tools such as Statsig, Optimizely, etc.
Steps for syncing data
To sync your data from a Reverse ETL source to a downstream destination, follow these steps:
To start a new sync, go to the Syncs tab of your reverse ETL source and click Sync Now.
When you sync data from the source for the first time, RudderStack performs a a full sync, that is, it syncs all of the data from the source.
It then incrementally syncs any new data since the last sync whenever you press the Sync Now button.
To force a full data sync, choose the Force Full Resync option.
To stop a running sync, click the Stop Now button.
In the confirmation popup, click Stop Sync to cancel and stop the sync.
Note the following:
Once you stop a sync, any data that RudderStack reads from the warehouse and is on the fly may not be stopped or dropped from being delivered to the destination. It will only stop reading and sending any new data from the warehouse to the destination and stop the sync from progressing.
For a very low number of deltas (new data since the last attempted sync), you may sometimes see a “0 deltas succeeded” after you stop the sync.
Once you cancel a sync, the behavior of the next sync depends on the type of the cancelled sync. For example, if a cancelled sync is an incremental sync, then the next sync will be incremental too. Similarly, if the cancelled is a full sync, then the next sync will be a full sync.
RudderStack makes sure there is no data loss in the subsequent sync as a result of the previous cancelled sync.
cookies, the cookies that are categorized as necessary are stored on your browser as they are as
for the working of basic functionalities of the website. We also use third-party cookies that
analyze and understand how you use this website. These cookies will be stored in your browser
consent. You also have the option to opt-out of these cookies. But opting out of some of these
have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This
category only includes cookies that ensures basic functionalities and security
features of the website. These cookies do not store any personal information.
learn more about cookies and why we use them, visit our cookie
policy. We'll assume you're ok with this, but you can opt-out if you wish Cookie Settings.