DataBridge processes records (or rows) and every record is counted. Every DataBridge subscription plan includes a number of records to proces per month. Once the number of included processed records is used, then additional packages of 50.000 records are automatically added to your subscription and charged to your account. This is done automatically to not stop any critical integrations.
The included number of records to proces per month are ‘reset’ every month. The ‘month’ starts when the monthly subscription is renewed or -if you have a quarterly or yearly subscription- on the same day of each month when the subscription period starts.
Here’s an example of how to calculate processed records and any additional packages or processed records.
Your subscription plan includes 150.000 records per month.
You process 12.000 records every working day. That is 60.000 per week and 240.000 per month.
This means that your additional number of records is (240.000 - 150.000 =) 90.000.
Additional packages come with 50.000 records, which means that (90.000 / 50.000 rounded up =) 2 additional packages are needed.
What is counted as a record?
Every record that ‘flows through’ DataBridge is a record that is counted. It does not matter if that record eventually reaches the destination. If a transformation stops a record from being processed, it is counted as one record since DataBridge processed it and applied the logic to it.
The exception here are records that are checked against the previous jobs by Smart Source Control. If Smart Source Control finds that a record did not change, it will stop further processing of the record and this record will not be counted as a processed record.
Sources that hold information from combined entities count as only one record. Let’s look at this in a few examples.
An export from SuperOffice where each record contains both company and contact details, is counted as 1 record.
An import into SuperOffice from a file where each row contains details on a company, a sale and a quote (and which creates or updates a company, a sale and a quote) is counted as 1 record.
Features to prevent too many processed records
- Smart Source Control – determines if there is a difference between the currently processed record and the records that were processed before. If there is a difference it will be further processed. If there is no difference, then further processing is skipped.
- For exports from SuperOffice: use New and changed only – this will only retrieve records from SuperOffice selections that are new or updated. Especially in combination with a database instead of a file, this is the most efficient way to only process new and changed records.