Send every customer the price list they expect, on time.
DataBridge turns a query on your price tables into the file layout a customer asks for and delivers it by SFTP, email or cloud storage on a schedule.
Customers want price lists and catalogs in their own layout, and they want them when prices change. Doing that by hand means exporting, reformatting and attaching the same file again and again.
Modules. Everything bundle when the source is a database query. Integrate when the source is a file.
Edition. DataBridge Server for unattended schedules.
How DataBridge does it.
Each step names the feature as it appears in the product.
- Step 1
Saved query
Read current prices and item data from the ERP's database. Parameters let one query serve several customers or price levels.
- Step 2
File template and mapping
Describe the customer's layout as a file template (CSV, TSV, Excel or a custom delimiter) and map your columns onto it. Reuse the mapping every run.
- Step 3
Destinations
Deliver to an SFTP or FTP server, an email address with the file attached, a shared folder, Azure Blob Storage or Amazon S3. File name patterns such as {date} keep each delivery distinct.
- Step 4
Scheduled job
Run weekly, daily or after your nightly price update. A failed run can email you, and a retry setting re-runs the job.
- Step 5
Push History
Every delivery keeps its file name, size and SHA-256 hash, which settles a dispute about what a customer received.
What this does not do.
- A destination holds one recipient or server, so each customer's delivery is its own job step.
- Pushed files are CSV, TSV, JSON or JSON Lines. DataBridge does not produce formatted PDF price books.
Related pages.
Try the parts that are free today.
The free browser edition needs no sign-in and never uploads your files.