All Collections
Reporting and Data Export
What is DataSync and how does it work?
What is DataSync and how does it work?

This article describes the features of DataSync

Namita Dodeja avatar
Written by Namita Dodeja
Updated over a week ago

Terminal49 DataSync is a way to automatically sync container, shipment, and tracking request data with your existing systems in a way that is secure, reliable, and easy.

Setup takes between 20 minutes and 2 hours, and can save weeks or months of development time. For many teams, this will be a better option than integrating with our API.

  • Sync directly with databases, data warehouses, object stores, and Google Sheets directly.

  • Power data stores used in TMSs, ERPs, visualization and Business Intelligence tools, custom systems, and Excel.

Data is synced on an hourly basis.

To learn more, read the blog post, the landing page, or the Developer Documentation. You can also book a demo or send us any questions you have.

FAQs

What is Data Synchronization?

Data synchronization, or data sync, is the continual process of keeping a record type (shipments and containers) identical between two or more systems. This can be done in real time, in near real time, or in batches.

How does it work?

  1. You track your shipments/containers on Terminal49 by submitting tracking requests via the API, Dashboard, or CSV/excel upload via dashboard or email.

  2. One-time setup - We send you a magic link so you or your IT team can provide database credentials via a secure link. Credentials are encrypted and stored.

  3. Our system continuously syncs changes to your database across three tables: Tracking Requests, Shipments and Containers. Syncs can be configured to run every 15 minutes or hourly.

How much does it cost?

Terminal49 DataSync is available as an add-on to your existing subscription to the Terminal49 API-only, Data-only or Enterprise plan. The add-on is priced at $500/month for up to 500 containers/month plus $250/month for every additional 500 containers/month.

How long does it take to set up a destination?

Once a secure connection has been established to your database, the initial sync can happen within minutes. Total setup start to finish can happen within a few hours.

Is it a one-way or two-way sync?

Today, we support a one-way data sync (Terminal49 → Data Warehouse).

How do I initiate shipment or container tracking?

You can initiate shipment or container tracking via our dashboard, API and/or email.

Via Terminal49 Dashboard — You can track bill of lading and booking numbers entering them on our dashboard or uploading a CSV file


Via Terminal49 API — You can track a bill of lading, booking or container number by creating a tracking request via the Terminal49 API.


Via email upload — You can send a CSV/excel file with your bill of lading/booking numbers to [email protected] (see guide). This process can be automated.

How is DataSync different than Terminal49's API?

With Terminal49's API, you can select exactly which datapoints you want from Terminal49 and configure them in your system as desired. However, it can take a lot of developer time to build and maintain that integration.

DataSync puts that data straight into your Data Warehouse without you having to write a single line of code.

What exact data am I getting?

We share the container, shipment, and tracking request tables.

You can see the values available in each table in our developer docs.

What do I do if something goes wrong?

If your data is inaccurate, not up to date, or you encounter any other problem with DataSync, please reach out to [email protected].

Is DataSync secure?

DataSync follows all industry best practices for maintaining data security. Details available here.

Did this answer your question?